| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Chris Hoover <revoohc(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Any way to see what queries are currently running? |
| Date: | 2005-08-16 01:33:10 |
| Message-ID: | 20100.1124155990@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Chris Hoover <revoohc(at)gmail(dot)com> writes:
> I'm running 7.3.4. Is there anyway to see the actual sql being run by
> the database via a query? I am having some problems with long running
> load causing querires from our reporting system. I have sql logging
> turned on to log the sql statements to my postgres.log file. However,
> these reporting queries do not appear to be logging the entire query.
> I am only getting the select clause (and I'm not sure if it's all of
> it) but no from or where clause.
That seems exceedingly improbable. Are you sure you are reading the log
correctly? If the source queries are formatted as multiple lines, the
log output will be broken across lines too ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | adey | 2005-08-16 04:07:40 | Re: Any way to see what queries are currently running? |
| Previous Message | Tom Lane | 2005-08-16 01:31:01 | Re: vacuumdb -a -f |