Re: capturing/viewing sort_mem utilization on a per query basis - Mailing list pgsql-general

From Tom Lane
Subject Re: capturing/viewing sort_mem utilization on a per query basis
Date
Msg-id 682.1107368591@sss.pgh.pa.us
Whole thread Raw
In response to Re: capturing/viewing sort_mem utilization on a per query basis  (Lonni J Friedman <netllama@gmail.com>)
Responses Re: capturing/viewing sort_mem utilization on a per query basis  (Lonni J Friedman <netllama@gmail.com>)
List pgsql-general
Lonni J Friedman <netllama@gmail.com> writes:
> I'm afraid i'm not clear on what i'm supposed to be checking here.
> Which conditions should I be looking at?  thanks.

Well, for instance,

>> ->  Hash  (cost=108.96..108.96 rows=28 width=24)
>> ->  Index Scan using mntr_subscr_usrevt on mntr_subscription sfmain_monitoringsubscriptio0  (cost=0.00..108.96
rows=28width=24) 
>> Index Cond: (((user_id)::text = 'user1187'::text) AND ((event_operation)::text = 'update'::text))

select count(*) from mntr_subscription where (((user_id)::text =
'user1187'::text) AND ((event_operation)::text = 'update'::text));

            regards, tom lane

pgsql-general by date:

Previous
From: Thomas F.O'Connell
Date:
Subject: Re: PL/PgSQL, Inheritance, Locks, and Deadlocks
Next
From: Tom Lane
Date:
Subject: Re: plpython.so