Hi.
Is there a way to set up logging in a way that I can see queries
which trigger seq scans? Or to log queries "taking longer than xx ms"?
Background is, that it is nearly impossible to tell, which queries
are used in my applications as they are mostly generated by the
frameworks. Yesterday I found, that one of the more often used
queries has not used an existing index and I had to use another index
for it. Nobody complained about the performance but nevertheless the
query took about 1000ms and therefore slowed down the rest of the
server ...
cug
--
PharmaLine, Essen, GERMANY
Software and Database Development