Re: Pet Peeves?
| From: |
Bill Moran <wmoran(at)potentialtech(dot)com> |
| To: |
Terry Fielder <terry(at)ashtonwoodshomes(dot)com> |
| Cc: |
pgsql-general(at)postgresql(dot)org |
| Subject: |
Re: Pet Peeves? |
| Date: |
2009-01-29 16:44:12 |
| Message-ID: |
20090129114412.6278b533.wmoran@potentialtech.com (view raw or flat) |
| Thread: |
|
| Lists: |
pgsql-general |
In response to Terry Fielder <terry(at)ashtonwoodshomes(dot)com>:
>
> 1) if I have multiple pids running queries, say all selects, I have no
> idea which pid is running which query
SELECT * FROM pg_stat_activity;
If the current_query column doesn't have the query in it, then you need
to tweak your postgres.conf settings:
http://www.postgresql.org/docs/8.3/static/monitoring-stats.html
--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/
In response to
pgsql-general by date
| Next: | From: Gregory Stark | Date: 2009-01-29 16:45:53 |
| Subject: Re: Text search segmentation fault |
| Previous: | From: Terry Fielder | Date: 2009-01-29 16:34:24 |
| Subject: Re: Pet Peeves? |
