Questions tagged [seqscan]

I have this query running on Greenplum 6(Postgres 9.4) too slow as it performing a sequential scan. But I am thinking why it's not performing an index backward scan to fetch the records since there is an index on the same column. explain analyse…

This is my table: CREATE TABLE IF NOT EXISTS public.ob_samples_sc5555 ( stamp timestamp(6) with time zone NOT NULL, oblvl smallint NOT NULL, olots integer NOT NULL, CONSTRAINT prk_ob_samples_sc5555 PRIMARY KEY (stamp, oblvl) ); This…