From: | Rushikesh socha <rushikesh(dot)s(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Exact same output - pg_stat_statements |
Date: | 2022-12-30 16:04:59 |
Message-ID: | CANgP4OLwgNE8isVwah5+3Aywh7Dq9N=8oHOBxOAzVtz8+G9DTw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
SELECT dbid,queryid,substring(query, 1, 50) AS short_query,
round(total_time::numeric, 2) AS total_time,
calls,
round(mean_time::numeric, 2) AS mean,
round((100 * total_time / sum(total_time::numeric) OVER
())::numeric, 2) AS percentage_cpu
FROM pg_stat_statements
ORDER BY total_time DESC
LIMIT 20;
I have erased the query text from the screenshot below. but Please look at
the rest of the columns which are exactly the same. How it is possible ?
[image: image.png]
Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2022-12-30 20:24:33 | Re: Exact same output - pg_stat_statements |
Previous Message | Ron | 2022-12-30 14:47:45 | Re: Purging few months old data and vacuuming in production |