3 ms·
My favorite version is when that UPDATE or DELETE SQL query that you expected to finish instantly takes a few seconds before giving you your cursor back.
by gomox 6y ago
My favorite version is when that UPDATE or DELETE SQL query that you expected to finish instantly takes a few seconds before giving you your cursor back.
- beefield 6y agoIf someone just gave me a tool to show me the expected wall time of query before actually running it, I would be quite happy. I would not even need that much of accuracy, anything up to one order of magnitude would be useful, and even up to two orders of magnitude I would use occasionally.
- yencabulator 6y agohttps://www.postgresql.org/docs/current/using-explain.html https://www.postgresql.org/docs/current/using-explain.html ?
- beefield 6y agoNobody has ever been able to give me a function query cost -> wall time with any accuracy.