Re: Adding NOTICE for differences between estimated and actual rows

2024-09-05 Thread Ilia Evdokimov
On 05.09.2024 23:32, Euler Taveira wrote: On Thu, Sep 5, 2024, at 1:05 PM, Ilia Evdokimov wrote: It's quite common that poor query performance can be attributed to inaccurate row estimations by the planner. To make it easier to detect these discrepancies, rather than scrutinizing the estimat

Re: Adding NOTICE for differences between estimated and actual rows

2024-09-05 Thread Euler Taveira
On Thu, Sep 5, 2024, at 5:32 PM, Euler Taveira wrote: > $ cat /tmp/pcc.pl > #!/usr/bin/perl -n > print "\033[1m\033[35m$1\033[36m$2\033[32m$3\033[33m$4\033[m" while > /([|+-]+)|([0-9]+)|([a-zA-Z_]+)|([^\w])/g; > > and then you can start psql as: > > $ PAGER="/c/mypager.pl" psql I meant: $ PAGE

Re: Adding NOTICE for differences between estimated and actual rows

2024-09-05 Thread Euler Taveira
On Thu, Sep 5, 2024, at 1:05 PM, Ilia Evdokimov wrote: > It's quite common that poor query performance can be attributed to inaccurate > row estimations by the planner. To make it easier to detect these > discrepancies, rather than scrutinizing the estimates manually, it would be > helpful to ou

Adding NOTICE for differences between estimated and actual rows

2024-09-05 Thread Ilia Evdokimov
Hi hackers, It's quite common that poor query performance can be attributed to inaccurate row estimations by the planner. To make it easier to detect these discrepancies, rather than scrutinizing the estimates manually, it would be helpful to output a dedicated |NOTICE| message. In the curre