Re: explain analyze rows=%.0f

Поиск
Список
Период
Сортировка
Искать
От
Ilia Evdokimov
Тема
Re: explain analyze rows=%.0f
Дата
Msg-id
88e65a15-2b52-4b44-a636-3736ca030b09@tantorlabs.com
Ответ на
Re: explain analyze rows=%.0f (Guillaume Lelarge)
Список
Дерево обсуждения
explain analyze rows=%.0f Robert Haas <robertmhaas@gmail.com>
Re: explain analyze rows=%.0f Euler Taveira de Oliveira <euler@timbira.com>
Re: explain analyze rows=%.0f Ron Mayer <rm_pg@cheapcomplexdevices.com>
Re: explain analyze rows=%.0f Simon Riggs <simon@2ndQuadrant.com>
Re: explain analyze rows=%.0f Robert Haas <robertmhaas@gmail.com>
Re: explain analyze rows=%.0f Tom Lane <tgl@sss.pgh.pa.us>
Re: explain analyze rows=%.0f Ibrar Ahmed <ibrar.ahmad@gmail.com>
Re: explain analyze rows=%.0f "David G. Johnston" <david.g.johnston@gmail.com>
Re: explain analyze rows=%.0f Ibrar Ahmed <ibrar.ahmad@gmail.com>
Re: explain analyze rows=%.0f Amit Kapila <amit.kapila16@gmail.com>
Re: explain analyze rows=%.0f Ibrar Ahmed <ibrar.ahmad@gmail.com>
Re: explain analyze rows=%.0f vignesh C <vignesh21@gmail.com>
Re: explain analyze rows=%.0f Ibrar Ahmed <ibrar.ahmad@gmail.com>
Re: explain analyze rows=%.0f Greg Stark <stark@mit.edu>
Re: explain analyze rows=%.0f Robert Haas <robertmhaas@gmail.com>
Re: explain analyze rows=%.0f Justin Pryzby <pryzby@telsasoft.com>
Re: explain analyze rows=%.0f Amit Kapila <amit.kapila16@gmail.com>
Re: explain analyze rows=%.0f Andrey Lepikhov <a.lepikhov@postgrespro.ru>
Re: explain analyze rows=%.0f Robert Haas <robertmhaas@gmail.com>
Re: explain analyze rows=%.0f Naeem Akhter <akhternaeem@gmail.com>
Re: explain analyze rows=%.0f Hamid Akhtar <hamid.akhtar@percona.com>
Re: explain analyze rows=%.0f Hamid Akhtar <hamid.akhtar@percona.com>
Re: explain analyze rows=%.0f Tom Lane <tgl@sss.pgh.pa.us>
Re: explain analyze rows=%.0f Ibrar Ahmed <ibrar.ahmad@gmail.com>
Re: explain analyze rows=%.0f "Gregory Stark (as CFM)" <stark.cfm@gmail.com>
Re: explain analyze rows=%.0f Ibrar Ahmed <ibrar.ahmad@gmail.com>
Re: explain analyze rows=%.0f Daniel Gustafsson <daniel@yesql.se>
Re: explain analyze rows=%.0f Daniel Gustafsson <daniel@yesql.se>
Re: explain analyze rows=%.0f Peter Geoghegan <pg@bowt.ie>
Re: explain analyze rows=%.0f Ibrar Ahmed <ibrar.ahmad@gmail.com>
Re: explain analyze rows=%.0f Robert Haas <robertmhaas@gmail.com>
Re: explain analyze rows=%.0f Robert Haas <robertmhaas@gmail.com>
Re: explain analyze rows=%.0f Joshua Tolley <eggyknap@gmail.com>
Re: explain analyze rows=%.0f Tom Lane <tgl@sss.pgh.pa.us>
Re: explain analyze rows=%.0f Robert Haas <robertmhaas@gmail.com>


On 11.01.2025 17:02, Guillaume Lelarge wrote:
Le sam. 11 janv. 2025 à 12:10, Ilia Evdokimov <ilya.evdokimov@tantorlabs.com> a écrit :


On 11.01.2025 12:15, Guillaume Lelarge wrote:


Thanks for your patch, this looks like a very interesting feature that I'd like to see in a future release.

It did a quick run: patch OK, make OK, make install OK, but make check fails quite a lot on partition_prune.sql.

I guess it would need some work on partition_prune.sql tests and perhaps also on the docs.

Thanks again.


--
Guillaume.


Yes, certainly. I have fixed partition_prune.sql. In the documentation example for EXPLAIN ANALYZE where loops is greater than one, I updated how 'rows' and 'loops' values are displayed so they appear as decimal fractions with two digits after the decimal point.

I attached fixed patch.

Any suggestions?


Thanks for the updated patch.

"make check" is happy, so no more suggestions, except you should register it in the next commitfest.


--
Guillaume.


Done!

https://commitfest.postgresql.org/52/5501/

--
Best regards,
Ilia Evdokimov,
Tantor Labs LLC.

В списке pgsql-hackers по дате отправления
От: Amul Sul
Дата:
От: Tom Lane
Дата:
FAQ