3 ms·
Thanks for the shout-out - I'm the author of the base library you listed that can be used to work with the Postgres parser (libpg_query). That said, the tool b
by lfittl 9y ago
Thanks for the shout-out - I'm the author of the base library you listed that can be used to work with the Postgres parser (libpg_query).
That said, the tool being discussed here (pev) is used to interpret EXPLAIN plans, which libpg_query doesn't give you, as its only concerned with the parsing stage, not the planning stage.
In order to plan a query you'll need more information from the actual database, including table statistics, config settings and the size of the underlying table :)