Am 23.07.2018 um 16:01 schrieb Baron Schwartz:
I'm biased, but I think VividCortex (my company's product) is amazing at this.
Looks goog, but "Contact us for pricing options" from https://www.vividcortex.com/product/pricing
Why do you hide your prices?
Regards,
Thomas Güttler
On Mon, Jul 23, 2018 at 7:18 AM Thomas Güttler <guettliml@xxxxxxxxxxxxxxxxxx <mailto:guettliml@xxxxxxxxxxxxxxxxxx>> wrote:
Is there a tool which does this for PostgreSQL?
Take a "snapshot" of what the server is doing about 10 times per second.
Write this to a file.
After N hours you can aggregate the file.
What does the server do most of the time?
Which tables/index gets used the most.
Before optimizing a database, I would like to know what is going
on in the production system.
I know that there are internal tables like pg_stat_statements.
But I guess doing a snapshot every N millseconds will present a
better picture of what is going in in real life.
Is there already a tool which goes this way?
Or is there a better way?
Regards,
Thomas Güttler
--
Thomas Guettler http://www.thomas-guettler.de/
I am looking for feedback: https://github.com/guettli/programming-guidelines
--
Thomas Guettler http://www.thomas-guettler.de/
I am looking for feedback: https://github.com/guettli/programming-guidelines
