[This topic is migrated from our old forums. The original author name has been removed]
Executing the new execute as explain on a PostgreSQL 9.2 database seems to be always using the analyze option, even when it is unchecked in the database profile. From the Sessions list, the query is shown executing with "EXPLAIN (format xml, analyze)".
Analyze does give more detailed statistics, but when determining why a very long running query is slow, analyze can block getting the information needed.
Product: DbVisualizer Pro 9.0
Build: #1902 (2012/11/30 15:08)
Java VM: Java HotSpot(TM) 64-Bit Server VM
Java Version: 1.6.0_37
Java Vendor: Apple Inc.
OS Name: Mac OS X
OS Arch: x86_64
OS Version: 10.8.2
over 10 years ago
[This reply is migrated from our old forums.]
Re: Explain plan always ANALYZE in DbVis 9.0 ?
Do you press the Apply button in the connection properties when "Explain Analyze" has been unchecked?
I am trying to reproduce but the explain is executed properly here.