| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | PT <wmoran(at)potentialtech(dot)com> |
| Cc: | nikhil raj <nikhilraj474(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>, pgsql-admin(at)postgresql(dot)com, Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> |
| Subject: | Re: How to find the hits on the databases and tables in Postgres |
| Date: | 2018-05-05 12:13:36 |
| Message-ID: | CAFj8pRAokvENsVLu1v-OOLdPf+fGQhrpw+mf6KabgjoaHKZY=Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2018-05-05 13:03 GMT+02:00 PT <wmoran(at)potentialtech(dot)com>:
> On Fri, 4 May 2018 17:14:39 +0530
> nikhil raj <nikhilraj474(at)gmail(dot)com> wrote:
>
> > Hi,
> > Any one can please help me out
> >
> > How to monitor the Hits on database and how many hits on each user tables
> > Through query.
> > Is there any other tools for that so it can full fill my requirement for
> it
>
> pgBadger has always been my goto tool for that: https://github.com/dalibo/
> pgbadger
>
>
There are some statistic per tables: .. select * from pg_stat_user_tables,
indexes: select * from pg_stat_user_indexes, and databases: select * from
pg_stat_database;
Regards
Pavel
--
> Bill Moran <wmoran(at)potentialtech(dot)com>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neto pr | 2018-05-05 13:26:55 | comparison between 2 execution plans |
| Previous Message | PT | 2018-05-05 11:03:22 | Re: How to find the hits on the databases and tables in Postgres |