These are chat archives for ManageIQ/manageiq/performance

18th
Sep 2015
Jason Frey
@Fryguy
Sep 18 2015 15:02
wanted to throw this into the performance tools ring...https://github.com/ankane/pghero
I was playing around with that a few weeks ago and it's pretty sweet
took almost no effort to get it to run with ManageIQ
Keenan Brock
@kbrock
Sep 18 2015 15:04
@fryguy nice - the idea would be to use that instead of our own postgres diagnostics code?
Dennis Metzger
@dmetzger57
Sep 18 2015 15:05
"took almost no effort" :smile:
Keenan Brock
@kbrock
Sep 18 2015 15:05
famous last words
Jason Frey
@Fryguy
Sep 18 2015 15:06
no really...I have it running locally :)
drop in the gem, mount the engine
Keenan Brock
@kbrock
Sep 18 2015 15:06
sure, and you have a girlfriend in canada
Jason Frey
@Fryguy
Sep 18 2015 15:06
for 1 particular feature you have to modify the postgres.conf and restart PG <- that's the almost part
demo app that you can click around in: https://pghero.herokuapp.com/
Dennis Metzger
@dmetzger57
Sep 18 2015 15:08
I played with the demo a little last night, it is very nice
Keenan Brock
@kbrock
Sep 18 2015 15:09
is this the stuff that shows all your queries?
Jason Frey
@Fryguy
Sep 18 2015 15:09
yes
Keenan Brock
@kbrock
Sep 18 2015 15:09
normalizes them
and you can see the queries that don't hit indexes
Jason Frey
@Fryguy
Sep 18 2015 15:09
no?
Keenan Brock
@kbrock
Sep 18 2015 15:09
and count them and stuff
Jason Frey
@Fryguy
Sep 18 2015 15:09
another tool for your toolboxes :)
Keenan Brock
@kbrock
Sep 18 2015 15:09
no - you do a select count(*) of the queries having run, and you can create indexes based upon the hits/misses
Jason Frey
@Fryguy
Sep 18 2015 15:10
oh maybe...I don't know if pghero can do that
but it does make sugestions
Keenan Brock
@kbrock
Sep 18 2015 15:10
was talking about the stats plugin
Keenan Brock
@kbrock
Sep 18 2015 15:25
ok - yea pretty sure it is pg_stat_statements
this stores all sql statements executed and puts into a table
it also stores the indexes used, the number of rows returned, scanned
similar to explain
very cool. looks like heroku enables by default
they then can tell you indexes that have never been used, and to drop them. or where partial indexes may be introduced (using a where clause)
I played for a while when diagnosing miq_queue, but not enough time in the day
Keenan Brock
@kbrock
Sep 18 2015 15:38
hmm. keep it down, don't tell @akrzos about pg_stat_statements - he could be very dangerous with that ;)