© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
0e1f616
(Get the code!)
EXPLAIN (without analyze) is fast.
We only want to do this for queries that take longer than some threshold (eg. 5 seconds, or 50% of the soft timeone, or whatever). We don't want query plans for all queries because there might be an awful lot of them, making the whole process slow and consuming gobs of disk space.