Re: Script and tool to monitoring sessions

From: abdujaparov <afmulone(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Script and tool to monitoring sessions
Date: 2015-09-25 08:38:37
Message-ID: 1443170317036-5867339.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,
I am checking

SELECT * FROM pg_stat_activity;

during the ingestion process:

19028;"smapdb";1151;19029;"smap";"";"172.25.10.42";"";62921;"2015-09-25
10:30:31.523041+02";"2015-09-25 10:30:38.013215+02";"2015-09-25
10:34:17.075262+02";"2015-09-25 10:34:17.075295+02";f;"idle in
transaction";;2765;"select nextval ('public.l3smap_partition_id_seq')"

This is the ingestion process that is running. I think that all the time is
spent on the sequence is it correct?

Regards,
Angelo

--
View this message in context: http://postgresql.nabble.com/Script-and-tool-to-monitoring-sessions-tp5867117p5867339.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jayadevan M 2015-09-25 08:58:32 Re: Script and tool to monitoring sessions
Previous Message Sergey Konoplev 2015-09-25 04:00:42 Re: Script and tool to monitoring sessions