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

On Wed, 02 Feb 2005 13:23:11 -0500, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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));

OK, i think i see what you're requesting.  How's this:

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

select count(*) from project where (("path")::text =
'projects.meeting_broker_v3'::text);
 count
-------
     1
(1 row)

select count(*) from project where ((("path")::text =
'projects.meeting_broker_v3'::text) OR (("path")::text ~~
'projects.meeting_broker_v3.%'::text));
 count
-------
     1
(1 row)

Let me know if you need more.  thanks

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman                                    netllama@gmail.com
LlamaLand                       http://netllama.linux-sxs.org