Great!! Your help is very valuable!!
-Original Message-
From: Justin Graf [mailto:jus...@magwerks.com]
Sent: Wednesday, April 14, 2010 7:35 PM
To: Bill Moran
Cc: Satish Burnwal (sburnwal); pgsql-general@postgresql.org
Subject: Re: [GENERAL] Query is stuck
I suggest writting something
On 4/14/2010 9:42 AM, Bill Moran wrote:
>
> Man, it's hard to read your emails. I've reformatted, I suggest you
> improve the formatting on future emails, as I was about to say "to
> hell with this question" because it was just too difficult to read,
> and I expect there are others on the list who
On 4/14/2010 9:20 AM, Satish Burnwal (sburnwal) wrote:
> Index Scan using repcopy_index on repcopy a (cost=0.00..87824607.17
> *rows=28* width=142) (actual time=11773.105..689111.440*rows=1* loops=1)
> Index Cond: ((dm_user)::text = 'u3'::text)
> Filter: ((report_status = 0) AND (repor
In response to "Satish Burnwal (sburnwal)" :
>
Man, it's hard to read your emails. I've reformatted, I suggest you
improve the formatting on future emails, as I was about to say "to
hell with this question" because it was just too difficult to read,
and I expect there are others on the list wh
o...@potentialtech.com]
Sent: Wednesday, April 14, 2010 6:06 PM
To: Satish Burnwal (sburnwal)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Query is stuck
Unless you truncated this output, you _really_ need to add some indexes
to this table. Read back through earlier messages in the th
In response to "Satish Burnwal (sburnwal)" :
> controlsmartdb=# \d repcopy;
> Table "public.repcopy"
> Column | Type | Modifiers
> -++---
> report_id | integer
controlsmartdb=# \d repcopy;
Table "public.repcopy"
Column | Type | Modifiers
-++---
report_id | integer| not null
dm_ip | character varying(64)
sh Burnwal
(sburnwal)
Sent: Tuesday, April 13, 2010 2:04 PM
To: Plugge, Joe R.; pgsql-general@postgresql.org
Cc: pgsql-ad...@postgresql.org
Subject: Re: [GENERAL] Query is stuck
controlsmartdb=# select * from pg_stat_activity where waiting='t';
ERROR: column "waiting"
On Tuesday 13 April 2010 6:03:43 am Satish Burnwal (sburnwal) wrote:
> controlsmartdb=# select * from pg_stat_activity where waiting='t';
>
> ERROR: column "waiting" does not exist
>
>
From here:
http://www.postgresql.org/docs/8.4/interactive/monitoring-stats.html#MONITORING-STATS-VIEWS
My guess
I am on postgres 8.1.
bash-3.2$ postgres --version
postgres (PostgreSQL) 8.1.11
From: Plugge, Joe R. [mailto:jrplu...@west.com]
Sent: Tuesday, April 13, 2010 6:37 PM
To: Satish Burnwal (sburnwal); pgsql-general@postgresql.org
Cc: pgsql-ad...@postgresql.org
Subject: RE: Query is stuck
On Tue, Apr 13, 2010 at 06:28:18PM +0530, Satish Burnwal (sburnwal) wrote:
>
> In such a case what can I do ?
don't crosspost?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
What version of postgres are you on?
From: Satish Burnwal (sburnwal) [mailto:sburn...@cisco.com]
Sent: Tuesday, April 13, 2010 8:04 AM
To: Plugge, Joe R.; pgsql-general@postgresql.org
Cc: pgsql-ad...@postgresql.org
Subject: RE: Query is stuck
controlsmartdb=# select * from pg_stat_activity where
controlsmartdb=# select * from pg_stat_activity where waiting='t';
ERROR: column "waiting" does not exist
From: Plugge, Joe R. [mailto:jrplu...@west.com]
Sent: Tuesday, April 13, 2010 6:32 PM
To: Satish Burnwal (sburnwal); pgsql-general@postgresql.org
Cc: pgsql-ad...@postgresql.org
Subject:
What do you get when you run this?
select * from pg_stat_activity where waiting='t';
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Satish Burnwal (sburnwal)
Sent: Tuesday, April 13, 2010 7:58 AM
To: pgsql-general@postgresql.org
Cc: pgsql-ad...@po
I have a query which is not giving me the result even after 30 minutes.
I want to know how to detect what is going and what's wrong ?
EXPLAIN query - gives me the following:
controlsmartdb=# explain select report_id, dm_ip, dm_mac, dm_user,
dm_os, report_time, sys_name, sys_user, sys_user_do
15 matches
Mail list logo
