It looks like that just timestamps things in its connection pool, that
is what I do now.
What I would like is to know about queries that have not finished yet.
-Aaron
Roberto Mello wrote:
> On Sun, Sep 22, 2002 at 09:51:55PM -0400, Bruce Momjian wrote:
>
>>>Would it be a good idea to add the
mentioned this to the dbadmin that manages the data and found out one
of the other users UPDATED some of the columns the morning that I was
seeing this behavior.
I'll reANALYZE and see what happens.
Thanks,
-Aaron Held
Josh Berkus wrote:
> Aaron,
>
>
>> # SET ena
Bruce Momjian wrote:
> Neil Conway wrote:
>
>>Bruce Momjian <[EMAIL PROTECTED]> writes:
>>
>>>Aaron Held wrote:
>>>
>>>>Is there any way to monitor a long running query?
>>>
>>>Oh, sorry, you want to know how far the query
>
> Bruce Momjian <[EMAIL PROTECTED]>@postgresql.org on 09/20/2002
> 12:18:06 PM
>
> Sent by:[EMAIL PROTECTED]
>
>
> To:Aaron Held <[EMAIL PROTECTED]>
> cc:[EMAIL PROTECTED], [EMAIL PROTECTED]
> Subject:Re: [GENERAL] Monitoring a Query
&g
Is there any way to monitor a long running query?
I have stats turned on and I can see my queries, but is there any better
measure of the progress?
Thanks,
-Aaron Held
select current_query from pg_stat_activity;
current_query
in transaction
FETCH ALL FROM PgSQL_470AEE94
in transaction
r with only
about 6 million. I need to buy more drives and develop on a larger data
set.
Thanks for the help,
-Aaron Held
Chris Ruprecht wrote:
> Aaron,
>
> On Wed September 18 2002 17:17, Aaron Held wrote:
>
>>I am running into a serious performance issue with some basic
WHERE
( ( "DateOfCall"='06/19/02') )
AND ( ( "CallType" = 'LONG DIST' ))
[DateOfCall is a DateTime field]
it takes 15 minutes!
both columns are indexed individually and expalain reports and Index scan for both
queries.
Any pointers where to look ne
seq value and insert my own numbers into the file
Thank You,
-Aaron Held
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
5'
GroupCode was Indexed. I dropped the index and the query ran in under one hour.
Now I have been running Vaccum Analyze for three days..
Thanks,
-Aaron Held
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
on UPDATES. It takes about 4 hours to run an UPDATE (the WHERE
clause is against an INDEX) but about 50 sec for a similar SELECT.
Thank You,
-Aaron Held
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
10 matches
Mail list logo
