| From: | Rui DeSousa <rui(at)crazybean(dot)net> |
|---|---|
| To: | badrinadh p <appsdba18(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: How can we log the sequential scan of queries at DB level |
| Date: | 2023-03-28 05:41:59 |
| Message-ID: | A4A6EAE7-B8D8-4BCD-BDCA-422AE4F3F54E@crazybean.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> On Mar 28, 2023, at 1:35 AM, badrinadh p <appsdba18(at)gmail(dot)com> wrote:
>
> HI Team,
> I tried in different ways to get the slow queries and generated explain plan using explain analyze(only select). I generated a PGBadger report and got the Most frequent queries. My request is there any option to find the list of queries that scan large number of rows regardless of the time they take. I would like to have the log of queries that scan large number of rows regardless of the time they take except for the auto explain option. Is there any tool or extension?
>
> Thanks,
> Venkata.
The pg_stat_statements extension can give you that information:
https://www.postgresql.org/docs/current/pgstatstatements.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sendhu Sendhu | 2023-03-28 14:00:06 | Re: Installing PostGreSQLon Redhat Linux - Help needed |
| Previous Message | parth ratra | 2023-03-28 05:40:13 | facing issues in downloading of packages in pgadmin4 |