Retrieve the query time for database calls used by a report

K To shared this question 4 months ago
Answered

Hi,

I'm looking for some logs or diagnostics that may be captured by the Yellowfin application server to analyse the database queries and the query time as observed from the Yellowfin application server side.

I can see the queries that are being run against the database and can run explain / execution plans to get database level statistics.

What I'm looking to try and get more insight on is how this is being handled on the Yellowfin side.

Replies (1)

photo
1

Hello,

Thanks for reaching out to Yellowfin Support.

I read your question and have done some investigation on it. Unfortunately, Yellowfin logs won't describe the report execution however I would like to refer you to the link for Audit content.

You may go ahead and download Audit content from the marketplace: https://portal.yellowfinbi.com/public/marketplace/home.

Additionally, you can also refer to the wiki link below https://wiki.yellowfinbi.com/display/yfcurrent/Content+Export+and+Import+Services which would help you more of Content Export and Import Services.

Hope the two links above answer your question. Please reach out to us if you need any more details we would be happy to assist.

Thank you!

Regards,

Yamini Naidu

photo
1

Yamini,

Could you advise which component of the Audit content would be relevant for the specific situation that I'm trying to assess?

photo
1

Hello,

There is a report in the audit content called longest running reports that will provide statistics you can use. Apart from that, there is no much logs or diagnostics that match your particular request available.

To obtain a set of logs, you can activate the debug mode of the logging system. I have a reference article that could help you further.https://community.yellowfinbi.com/knowledge-base/article/how-do-i-turn-on-debug-logging-within-yellowfin-log-file

Note: Also, for my reference I would like to know from you, which database you have integrated with Yellowfin and what is the version of it.

Regards,

Yamini Naidu

photo
1

Yamini,

Thanks for the clarification re: Audit content.

Verbose logging may be an option - could you advise the name of the logger that is used for database operations from Yellowfin, would be better to just set that to a finer grained than the whole application if possible.

Database engine is Amazon Aurora, MySQL 5.7 compatibility for both the source and config database. Yellowfin is 9.7.1.1.

photo
1

Hello,

Hope you are doing well

I did review this issue one more time to see if there are any other possible opportunities to achieve the expected output however there are a couple of pointers that I would like to highlight here.

1. Necessary configuration (Script/Coding) must be carried out on your end unfortunately it's an out-of-scope issue for Yellowfin support.

2. The other option is, you may need to configure it via the Tomcat server as well to give it a try I'll share a couple of helpful links with you, hope this would help you in some way.

https://wiki.yellowfinbi.com/display/yfcurrent/Logs+and+Logging

https://community.yellowfinbi.com/knowledge-base/article/how-to-turn-on-debug-logging-for-one-class-only

Thanks!


Regards,

Yamini Naidu

photo
1

Yamini,

Yes, we understand that we need to apply the configuration changes to our instance to enable the logging needed.

In terms of the name of the logger, what I was hoping to get was a finer grained logger - similar to the 2nd link you shared regarding enabling logging for the ReportBroadcastProcess. I'm not familiar with the Yellowfin application so wanted to get a pointer on which configuration to set so that the database related logs could be enabled at the DEBUG level. As the link mentions, we don't want to be trawling through copious amounts of log outputs.

Hope that clarifies what I was requesting regarding the name of the logger.

photo
1

Hello,

Hope you are doing well.

I apologies for the delayed response.

After having a discussion with the wider teams we would like to conclude that, the issue which you have been facing looks to be an out of scope for Yellowfin support. We will go ahead and create a Jira ticket for further improvements and will keep you posted with the updates as and when we have it from Dev team.

Regards,

Yamini Naidu

photo
1

Hello,

Hope you are doing well

I'm writing to let you know that we've opened a Jira ticket for improvement on the problem you're having. We will keep you posted once we have some updates around this.

Thanks!

Regards,

Yamini Naidu

photo
1

Yamini,

Thanks for the note, definitely will need assistance from the Development team on this. Will keep a lookout for updates on this. Appreciate the help.

photo
Leave a Comment
 
Attach a file