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

2022-06-24 Thread Ekaterina Sokolova
of this patch. -- Ekaterina Sokolova Postgres Professional: http://www.postgrespro.com The Russian Postgres CompanyFrom: Justin Pryzby Subject: [PATCH 1/2] explain.c-refactor-ExplainNode_v3 --- src/backend/commands/explain.c | 110 ++--- 1 file changed, 48

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

2022-04-01 Thread Ekaterina Sokolova
this initialization for min values so comment about it located above the block of code with initialization. I am convinced that the latest changes have affected the patch in a positive way. I'll be pleased to hear your thoughts on this. -- Ekaterina Sokolova Postgres Professional: http

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

2022-02-02 Thread Ekaterina Sokolova
are in file overhead_v0.txt. Please feel free to share your suggestions and comments. Regards, -- Ekaterina Sokolova Postgres Professional: http://www.postgrespro.com The Russian Postgres CompanyFrom: Ekaterina Sokolova Subject: [PATCH] Add extra statistics to explain for Nested Loop For some

Re: RFC: Logging plan of the running query

2021-11-17 Thread Ekaterina Sokolova
? As I know, pg_query_state use non-blocking read and write. I have wrote few tests trying to deadlock it (on 14 version), but all finished correctly. Have a nice day. Please feel free to contact me if you need any further information. -- Ekaterina Sokolova Postgres Professional: http

Re: RFC: Logging plan of the running query

2021-11-02 Thread Ekaterina Sokolova
the cost. I think it would be useful for us to have couple of examples with a different number of rows compared to using without this functionality. Hope this helps. -- Ekaterina Sokolova Postgres Professional: http://www.postgrespro.com The Russian Postgres Company

Re: RFC: Logging plan of the running query

2021-10-13 Thread Ekaterina Sokolova
/postgrespro/pg_query_state [3] https://www.postgresql.org/message-id/dbfb1a42-ee58-88fd-8d77-550498f52...@postgrespro.ru -- Ekaterina Sokolova Postgres Professional: http://www.postgrespro.com The Russian Postgres CompanyFrom 26356efb094ac25b11fe65df93f11c64ad136723 Mon Sep 17 00:00:00 2001 From

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

2021-08-17 Thread Ekaterina Sokolova
l Loops": N, ... I hope you find this patch useful. Please don't hesitate to share any thoughts on this topic! -- Ekaterina Sokolova Postgres Professional: http://www.postgrespro.com The Russian Postgres CompanyAuthor: Ekaterina Sokolova diff --git a/src/backend/commands/explain.c b/src/ba