Sample Header Ad - 728x90

Greenplum/Postgres - Why not backward index scan?

1 vote
1 answer
41 views
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 select * from tab1 where create_time > now() - interval '1d' order by create_time desc limit 20; https://explain.depesz.com/s/UTA7#html The index is a composite index (create_time,col2), could it be the reason behind sequential scan? I have already updated statistics of the table and also the bloat ≈5% only.
Asked by goodfella (595 rep)
Apr 3, 2025, 09:03 AM
Last activity: Apr 4, 2025, 04:42 AM