Easily reading debug_print_plan

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Easily reading debug_print_plan
Дата
Msg-id 528C6EF3.3020808@2ndquadrant.com
обсуждение исходный текст
Ответы Re: Easily reading debug_print_plan  (Antonin Houska <antonin.houska@gmail.com>)
Re: Easily reading debug_print_plan  (Craig Ringer <craig@2ndquadrant.com>)
Re: Easily reading debug_print_plan  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi all

I'm spending a lot of time staring at parse and plan trees at the
moment, and I'm finding reading them rather cumbersome.

For those of you who do this a lot, do you use any sort of tooling to
help you out? Just being able to collapse and expand subtrees would be a
lifesaver.

If it's a hassle for others too, how would you feel about using json as
an output format in future releases? It'd be pretty simple to retrofit
by the looks, though updating the regression tests would be a PITA. My
main concern would be effects on back-patching.

If the conensus opinion on that is "hell no" or if it's a much bigger
job than I thought I'll just write a converter that ingests node trees
and spits out json I can view using existing tools.

-- Craig Ringer                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: CREATE TABLE IF NOT EXISTS AS
Следующее
От: Antonin Houska
Дата:
Сообщение: Re: Easily reading debug_print_plan