"Dave Menendez" <dave@sycamorehq.com> writes:
> Any comments?
Can't say much useful with such a selective report. It'd be interesting
to see the EXPLAIN output in all four cases (small bank_id list for both
index and seq scans, ditto for large bank_id list). Also, I don't
believe the bank_id IN () part can contribute to the index condition,
so the critical number is how many rows will match just time_id = 'P_6'
and org_allow = 1. How many such rows are there really, and how many
does the planner estimate (use EXPLAIN with just those clauses in
WHERE)?
regards, tom lane
