Re: Database stats

On 12/07/2018 10:38 AM, Campbell, Lance wrote:
>
> PostgreSQL 10.X
>
> Is there a query we can run to answer the following questions:
>
> 1. How many SQL commands have been executed in the last 24 hours?
> 2. How many insert SQL commands have been executed in the last 24 hours?
> 3. How many update SQL commands have been executed in the last 24 hours?
>
> OR
>
> Instead of 2 or 3 maybe how many row updates have occurred in the last 24
> hours?
>
> OR
>
> Something that gives me an idea of rows reads and written.  Or rows read,
> written and created in 24 hours.
>

Look in pg_stat_all_tables.  It keeps a running count since the cluster was
started, but if you capture a snapshot every X hours then you should be able
to approximate what you want.

https://www.postgresql.org/docs/9.6/monitoring-stats.html#PG-STAT-ALL-TABLES-VIEW

> There might be other ways to get to general levels of usage base on a date
> or date range.
>
> Thanks,
>
> Lance
>

--
Angular momentum makes the world go 'round.