Re: [PATCH] Add extra statistics to explain for Nested Loop

From: Ekaterina Sokolova <e(dot)sokolova(at)postgrespro(dot)ru>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: [PATCH] Add extra statistics to explain for Nested Loop
Date: 2021-08-17 12:30:10
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Hi, hackers.

Here is the new version of patch that add printing of min, max and total
statistics for time and rows across all loops to EXPLAIN ANALYSE.

1) Please add VERBOSE to display extra statistics.
2) Format of extra statistics is:


> Loop min_time: N max_time: N min_rows: N max_rows: N total_rows: N
> Output: ...


> ...
> "Actual Total Time": N,
> "Loop Min Time": N,
> "Loop Max Time": N,
> "Actual Rows": N,
> "Loop Min Rows": N,
> "Loop Max Rows": N,
> "Loop Total Rows": N,
> "Actual Loops": N,
> ...

I hope you find this patch useful.
Please don't hesitate to share any thoughts on this topic!
Ekaterina Sokolova
Postgres Professional:
The Russian Postgres Company

Attachment Content-Type Size
extra_statistics_v5.patch text/x-diff 13.5 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Gustafsson 2021-08-17 12:43:08 Re: [PATCH] OpenSSL: Mark underlying BIO with the appropriate type flags
Previous Message David Rowley 2021-08-17 11:54:51 Re: A problem in ExecModifyTable