Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
From: John Scalia <jayknowsunix@gmail.com>
Mime-Version: 1.0 (1.0)
Date: Mon, 16 Mar 2020 12:26:04 -0400
Subject: Explain plan on a Select query
Message-Id: <83029EBF-241B-499B-881A-9057399DC67B@gmail.com>
To: Pgsql-admin <pgsql-admin@postgresql.org>
Precedence: bulk

I=E2=80=99m a bit confused on an explain plan I just generated for a select s=
tatement. The plan=E2=80=99s first line begins with the word =E2=80=9CAppend=
=E2=80=9D followed by the usual (cost....) data. What in the world is an App=
end doing here? I=E2=80=99ve recently performed  another analyze on the tabl=
e, btw.=20

Also, the query does not seem to be using an index, as the explain shows a p=
air of sequential scans, speaking of which, the second sequential scan shows=
 it=E2=80=99s on a table, called <table>_test. Which is a little strange, co=
nsidering that does not exist.

The query=E2=80=99s where clause is on a varchar(25) field. And that field h=
as both a btree index and a trigram index on it. I=E2=80=99ve tried using wh=
ere =3D, like, and ~ in order to see if I can get it to use an index. All at=
tempts continue to say sequential scan.
=E2=80=94
Jay
>=20
Sent from my iPad=