Hi Kenia,
Take a look of this link
https://wiki.postgresql.org/wiki/Monitoring#pg_activity
I think you are looking for something line pg_activity
But in that official pgsql documentation you'll find all you need to
monitor queries and pgsql cluster behavior
On Wed, Mar 6, 2019, 7:45 PM Kenia V
On Wed, 6 Mar 2019 at 23:45, Kenia Vergara wrote:
> Good afternoon.
> I need to know the commands to display the execution time, CPU usage and
> memory usage, but through the Postgres console.Thank you.
>
You might want to have a look at,
https://aaronparecki.com/2015/02/19/8/monitoring-cpu-memo
On Wed, Mar 6, 2019 at 11:49 PM Justin Pryzby wrote:
>
> Hi,
>
> On Wed, Mar 06, 2019 at 04:09:46PM -0400, Kenia Vergara wrote:
> > Good afternoon.
> > I need to know the commands to display the execution time, CPU usage and
> > memory usage, but through the Postgres console.Thank you.
>
> Does th
Hi,
On Wed, Mar 06, 2019 at 04:09:46PM -0400, Kenia Vergara wrote:
> Good afternoon.
> I need to know the commands to display the execution time, CPU usage and
> memory usage, but through the Postgres console.Thank you.
Does this do what you want ? Note that the "QUERY STATISTICS" are log output
