Postgres Pro
Downloads
Home   >   mailing lists

Re: Query Performance / Planner estimate off - Mailing list pgsql-performance

From Victor Yegorov
Subject Re: Query Performance / Planner estimate off
Date
Msg-id CAGnEboikAdVz7N+aSGXVEhLoK83RKBRGnqAJPwBe_rR_yehBdQ@mail.gmail.com
Whole thread Raw
In response to Query Performance / Planner estimate off  (Mats Julian Olsen <mats@duneanalytics.com>)
Responses Re: Query Performance / Planner estimate off  (Mats Olsen <mats@duneanalytics.com>)
List pgsql-performance
Tree view
вт, 20 окт. 2020 г. в 11:38, Mats Julian Olsen <mats@duneanalytics.com>:
I'm looking for some help to manage queries against two large tables.

Can you tell the version you're running currently and the output of this query, please?

    select name,setting,source from pg_settings where source not in ('default','override'); 

--
Victor Yegorov

pgsql-performance by date:

Previous
From: aditya desai
Date:
Subject: Re: CPU Consuming query. Sequential scan despite indexing.
Next
From: Victor Yegorov
Date:
Subject: Re: Query Performance / Planner estimate off