Обсуждение: Database stats

Поиск
Список
Период
Сортировка

Database stats

От
"Campbell, Lance"
Дата:

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.

 

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

 

Thanks,

 

Lance

Re: Database stats

От
Ron
Дата:
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.