| From: | Vick Khera <vivek(at)khera(dot)org> |
|---|---|
| To: | Joey Quinn <bjquinniii(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: tracking scripts... |
| Date: | 2013-11-26 18:43:17 |
| Message-ID: | CALd+dce-=AGEsWgMq7t1Y-dJLQ-oPhDqYmR-byz_EoWygQTBAw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Nov 26, 2013 at 12:24 PM, Joey Quinn <bjquinniii(at)gmail(dot)com> wrote:
> When I ran that command (select * from pg_stat_activity"), it returned the
> first six lines of the scripts. I'm fairly sure it has gotten a bit beyond
> that (been running over 24 hours now, and the size has increased about 300
> GB). Am I missing something for it to tell me what the last line processed
> was?
>
I agree with what John R Pierce says about your GUI lumping all of it into
one statement. What you can do is get indirect evidence by looking to see
which rows are set. I'm assuming that your IP ranges are non-overlapping,
so just do a binary search until you narrow it down to see how far along
you are.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2013-11-26 19:12:30 | Re: Any advantage of using SSL with a certificate of authority? |
| Previous Message | John R Pierce | 2013-11-26 18:33:47 | Re: Any advantage of using SSL with a certificate of authority? |