Re: monitoring-stats.html is too impenetrable

2019-12-06 Thread James Salsman
wrong. Thank you for your consideration. Best regards, Jim On Thu, Dec 5, 2019 at 7:05 PM Michael Paquier wrote: > > On Wed, Dec 04, 2019 at 03:29:55AM -0800, James Salsman wrote: > > Thank you for your thoughtful reply. This might be much easier: > > > > How about a

Re: monitoring-stats.html is too impenetrable

2019-12-04 Thread James Salsman
Michael, Thank you for your thoughtful reply. This might be much easier: How about adding another example to https://www.postgresql.org/docs/11/planner-stats.html ? SELECT relname, seq_scan-idx_scan AS too_much_seq, case when seq_scan-idx_scan>0 THEN 'Missing Index?' ELSE 'OK' END, pg_rela