Re: Script and tool to monitoring sessions
| От | Jayadevan M |
|---|---|
| Тема | Re: Script and tool to monitoring sessions |
| Дата | |
| Msg-id | CAFS1N4gb=MHSxYFSB_N-mtC7VZUAR7-7M=y6rxziSmiggp1QeA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Script and tool to monitoring sessions (abdujaparov <afmulone@gmail.com>) |
| Список | pgsql-novice |
On Fri, Sep 25, 2015 at 2:08 PM, abdujaparov <afmulone@gmail.com> wrote:
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')"
To see how much time the sequence is taking, try something like
select nextval('myseq') from generate_series(1,<replace withyour upper limit>);
Please note that the sequence will go up to the high value once the SELECT is executed.
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.--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
В списке pgsql-novice по дате отправления: