Re: [PERFORM] Monitoring tool for Postgres Database

2017-06-03 Thread Nikolay Samokhvalov
We use OKmeter.io, their Postgres monitoring is really good. On Thu, May 25, 2017 at 10:48 PM, Ravi Tammineni < rtammin...@partner.aligntech.com> wrote: > Hi, > > > > What is the best monitoring tool for Postgres database? >

[PERFORM] Query plan for "heavy" SELECT with "lite" sub-SELECTs

2006-11-02 Thread Nikolay Samokhvalov
Hello, I do not understand, why Postgres very ofter starts execution from sub-select instead of doing main select and then proceeding to "lite" sub-selects. For example: (example is quite weird, but it demonstrates the problem) 1. explain analyze select * from pg_proc offset 1500 limit 1; "Limi