Very simple query decomposition

This is just small simple hint but maybe someone could need it. If you have some not complicated query you can decompose it to parts using this query:   with srcquery as (select replace(lower( --this is some "normalization of the query string 'SELECT...

Parse tree in messages output

Do you need to know how is PostgreSQL parsing your query? To see parse tree for select in “messages output” use this: set client_min_messages to 'debug1'; set debug_print_parse to on; select * from pg_class; But parse tree is very very very long and for...