From: | Thomas Güttler <guettliml(at)thomas-guettler(dot)de> |
---|---|
To: | postgres performance list <pgsql-performance(at)postgresql(dot)org> |
Subject: | Profile what the production server is doing |
Date: | 2018-07-23 11:18:02 |
Message-ID: | 6ffd0115-38b7-8a98-b0c9-93fdd86afe4f@thomas-guettler.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Julien Rouhaud | 2018-07-23 11:38:04 | Re: Profile what the production server is doing |
Previous Message | Mark Kirkwood | 2018-07-23 00:07:16 | Re: Why HDD performance is better than SSD in this case |