I decided that it might help to list the cardinalities of the pertinent
tables:
Intsetmedia: 90,000 rows
Interaction: 26,000 rows
Set: 7,000 rows
Media: 80,000 rows
-----Original Message-----
From: Josh Berkus [mailto:josh@agliodbs.com]
Sent: Monday, March 24, 2003 12:47 PM
To: Stephan Szabo; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Slow query
Importance: Low
Stephan,
Hmmm ... I'm a bit confused by the new EXPLAIN output. Stefan, does
Oleg's
output show the time for *one* subplan execution, executed for 44,000
loops,
or does it show the total time? The former would make more sense given
his
query, but I'm just not sure ....
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
*************************************
This email may contain privileged or confidential material intended for the named recipient only.
If you are not the named recipient, delete this message and all attachments.
Any review, copying, printing, disclosure or other use is prohibited.
We reserve the right to monitor email sent through our network.
*************************************