Re: capturing/viewing sort_mem utilization on a per query basis

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