On T, 2005-09-27 at 16:37 -0500, Joe Markwardt wrote:

> Yep.  And I restarted the slon's as well, so they should be using the
> index as long as the planner thinks it will help.  Is there anyway I can
> see the query that slon is generating to create the cursor? If I could
> see that query then I could do some explain analyze's and see what they
> say...

I usually look at the queries in postgres log.

In your case you could set up postgres to log only long queries, say
over 50 sec, and then just tail -f the log.

When analysing take notice that slon specially sets enable_seqsnam and
enable_indexscan before running the query on sl_log_1.

-- 
Hannu Krosing <hannu at skype.net>