Database stats

From: "Campbell, Lance" <lance(at)illinois(dot)edu>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Database stats
Date: 2018-12-07 16:38:36
Message-ID: 1B1BD261-2B29-4B3A-84CA-4C57C125B712@illinois.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2018-12-07 16:46:15 Re: Database stats
Previous Message pavan95 2018-12-07 13:47:54 Re: Error when starting postgres database!!