Re: How to improve the performance of my SQL query？

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: gzh <gzhcoder(at)126(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: How to improve the performance of my SQL query？
Date: 2023-07-24 15:58:50
Message-ID: ca1e00239309c95c63157941facdbb4b80a798da.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 2023-07-24 at 17:54 +0800, gzh wrote:
> EXPLAIN (ANALYZE ON, VERBOSE ON, COSTS ON, BUFFERS ON) 

I asked for EXPLAIN (ANALYZE, BUFFERS, SETTINGS) ...
Or do you have a version that is too old for SETTINGS?

One other idea: check if the index is INVALID (this will
be visible if you run "\d tablenane" in "psql").
Invalid indexes won't be used.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message De Lan 2023-07-24 16:59:36 Re: Duplicate Primary keys in postgresql tables
Previous Message David G. Johnston 2023-07-24 14:59:35 Re: Grant all privileges to user on a database