On Tue, 12 Mar 2002, Hunter Hillegas wrote:
> vacuum (not vacuum analyze) is run every night... Just ran vacuum analyze
> and it showed some tables with very high "UnUsed", though I don't know what
> that means.
>
> Explain shows that it is indeed using the indexes I created...
>
> Is there a way to see which, if any, queries are taking a long time to
> execute?
Try explain analyze
> In postgresql.conf:
>
> max_connections = 200
> shared_buffers = 400
That shared_buffer setting is pretty low for that number of connections.
> Any other parameters in there that could affect this?
I doubt sort_mem is likely to come up, but if there are sort steps in
the query, possibly.