Re: Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached
Date: 2021-02-21 17:14:04
Message-ID: CAHOFxGowtw-ctxrEuo1aGh7ezWQX0LnHt6-vKgi-n62=LSxdMA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

No issues for us. We have used a low sample rate of 1% or so and gotten
some very useful data. Particularly with logging nested statements so we
can profile stored procs more easily than adding a large number of raise
notice statements.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2021-02-21 21:31:18 Re: Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached
Previous Message Dan Nessett 2021-02-21 16:05:31 Re: Getting unexpected results from regexp_replace