Sorry :) When i look at the "SQL" tab in PGAdmin when i select the index in the
schema browser. But you are right that /d doesn't show that.
________________________________
From: Tom Lane <t...@sss.pgh.pa.us>
Sent: Friday, January 25, 2019 1:34:01 PM
To: l...@laurent-hasson.com
Cc: pgsql-performa...@postgresql.org
Subject: Re: Zero throughput on a query on a very large table.
"l...@laurent-hasson.com" <l...@laurent-hasson.com> writes:
> Also, the original statement i implemented did not have all of that. This is
> the normalized SQL that Postgres now gives when looking at the indices.
[ squint... ] What do you mean exactly by "Postgres gives that"?
I don't see any redundant COLLATE clauses in e.g. psql \d.
regards, tom lane
