View Issue Details

IDProjectCategoryView StatusLast Update
0002242Database Workbench v6PostgreSQL Modulepublic2024-06-27 11:36
ReporterSvein Erling Tysvær Assigned ToMartijn Tonies  
Status closedResolutionwon't fix 
Product Version6.5.0 
Summary0002242: Strange explain analyse
DescriptionIf I type

explain analyze select * from <database>.<table>

in the SQL editor window and run, I do get a result. If I prepare the query, I get 'syntax error at or near "explain"'

If I try to run after a prepare, I get "current transaction is aborted, commands ignored until end of transaction block"
Additional InformationPostgreSQL 13.9
TagsNo tags attached.


Martijn Tonies

2024-06-27 11:36

administrator   ~0000614

EXPLAIN statements cannot be prepared. As this raises an error from PostgreSQL, your transaction is now 'aborted' and should be rolled back or committed. You can do this by clicking the 'start' and then 'commit' or 'rollback' button. I know, this sounds silly, but this is the case with PostgrSQL transactions.

more info about how PostgreSQL handles such transactions:

Issue History

Date Modified Username Field Change
2024-06-26 13:58 Svein Erling Tysvær New Issue
2024-06-27 11:36 Martijn Tonies Assigned To => Martijn Tonies
2024-06-27 11:36 Martijn Tonies Status new => closed
2024-06-27 11:36 Martijn Tonies Resolution open => won't fix
2024-06-27 11:36 Martijn Tonies Note Added: 0000614