[PG13] Planning (time + buffers) data structure in explain plan (format text)
| От | Pierre Giraud |
|---|---|
| Тема | [PG13] Planning (time + buffers) data structure in explain plan (format text) |
| Дата | |
| Msg-id | 07b226e6-fa49-687f-b110-b7c37572f69e@dalibo.com обсуждение исходный текст |
| Ответы |
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text) |
| Список | pgsql-hackers |
Hi all,
As far as I understand, in the upcoming version 13, information about
buffers used during planning is now available in the explain plan.
[…]
Planning Time: 0.203 ms
Buffers: shared hit=14
[…]
In the JSON format, the data structure is a bit different:
[…]
"Planning": {
"Planning Time": 0.533,
"Shared Hit Blocks": 14,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
[…]
For a matter of consistency, I wonder if it would be possible to format
it like the following:
[…]
Planning:
Planning Time: 0.203 ms
Buffers: shared hit=14
[…]
Note: a similar way to format information is already used for JIT.
[…]
JIT:
Functions: 3
Options: Inlining false, Optimization false, Expressions true,
Deforming true
Timing: Generation 0.340 ms, Inlining 0.000 ms, Optimization 0.168
ms, Emission 1.907 ms, Total 2.414 ms
[…]
Regards,
Pierre
В списке pgsql-hackers по дате отправления: