Your data. Anywhere you go.

New Relic for iOS or Android


Download on the App Store    Android App on Google play


New Relic Insights App for iOS


Download on the App Store


Learn more

Close icon

Customer Dashboard: DB Performance

rfb
shared-dashboards

#1

Sharing dashboard that talks about DB performance. as this is my prod had to black out some stuff. enjoy.

worst DB offenders

SELECT sum(databaseDuration) as 'Time', count(*) as 'Count', percentile(databaseDuration, 99, 80, 50) as 'DB' FROM Transaction FACET name SINCE 1 day ago LIMIT 15

Accumulated DB time by trans

SELECT sum(databaseDuration) FROM Transaction FACET name SINCE 1 day ago LIMIT 20

Worst App offenders

SELECT sum(duration) as 'App', count(*) as 'Count', percentile(duration, 99, 80, 50) as 'App' FROM Transaction FACET name SINCE 1 day ago LIMIT 5

Transaction time

SELECT sum(duration) FROM Transaction FACET name SINCE 1 day ago LIMIT 7

Accumulated DB time by histogram

SELECT histogram(databaseDuration) FROM Transaction FACET name SINCE 1 day ago LIMIT 20

Hope it helps. ** sorry for the ugly marks