Postgres Pro
Downloads
Home   >   mailing lists

Re: garbage data back - Mailing list pgsql-general

From Brad White
Subject Re: garbage data back
Date
Msg-id CAA_1=91WcQTdfyHPKu9U2_fEFe-EVSsM-Ra2hOQg7K60bKvtjg@mail.gmail.com
Whole thread Raw
In response to Re: garbage data back  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
David,

Thanks!
'EXPLAIN ANALYZE' is very slick.
Promises to be very helpful.
As soon as I saw the output, it was obvious where my problem was.

Brad.

On Mon, Mar 6, 2023 at 2:30 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Mon, Mar 6, 2023 at 1:18 PM Brad White <b55white@gmail.com> wrote:

As you can see here, when attempting to filter on the FileKey, it is actually filtering on the Order Item ID field.

select "FileKey", "OrderItemID" from "vw_rptInvc_Permits"
where "FileKey" LIKE '%1317'

I'm stumped. Any guesses?

Agreed, what you've shown doesn't make sense.

Try:
EXPLAIN ANALYZE
REINDEX (on any underlying table indexes)

Show the version you are running.

David J.

pgsql-general by date:

Previous
From: Erik Wienhold
Date:
Subject: Re: psql \conninfo in tabular form?
Next
From: Bryn Llewellyn
Date:
Subject: Behavior of PL/pgSQL function following drop and re-create of a table that it uses