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
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
