| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
|---|---|
| To: | Rushikesh socha <rushikesh(dot)s(at)gmail(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Exact same output - pg_stat_statements |
| Date: | 2023-01-02 13:34:13 |
| Message-ID: | Y7LdVeKa2kq0gOPq@depesz.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Dec 30, 2022 at 11:04:59AM -0500, Rushikesh socha wrote:
> Hi, Whenever I am running the below query on one of my Azure PostgreSQL
> PaaS instances I am getting exact same output. I feel it shows old
> information but as far as i know pg_stat_statements only shows current
> information and not past right ? It may be a bug?
pg_stat_statements has all the data since last reset of stats.
So if you never reset stats, it accumulated data for howeve rlong you
are using pg.
Not really surprising that top total-time uses are the same.
If you want to sensibly use it you should call reset function every now
and then.
Best regards,
depesz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jacktby@gmail.com | 2023-01-02 16:30:27 | what kind of hash algorithm is used by hash_bytes()? |
| Previous Message | Matthias Apitz | 2023-01-02 09:35:55 | Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours |