Re: Script and tool to monitoring sessions - Mailing list 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.