index_scan_instead_of_index_only.txt

EXPLAIN ANALYZE SELECT "subscriptions".* FROM "subscriptions" 
WHERE "subscriptions"."project_id" = 12345 AND "subscriptions"."trashed_at" IS NULL AND 
((tags @> ARRAY['crt:2018_04']::varchar[]) OR (tags @> ARRAY['crt:2018_05']::varchar[]) OR (tags @> ARRAY['crt:2018_06']::varchar[]) 
OR (tags @> ARRAY['crt:2018_07']::varchar[]) OR (tags @> ARRAY['crt:2018_08']::varchar[]) OR (tags @> ARRAY['crt:2018_09']::varchar[]) 
OR (tags @> ARRAY['crt:2018_10']::varchar[]) OR (tags @> ARRAY['crt:2018_11']::varchar[]) OR (tags @> ARRAY['crt:2018_12']::varchar[]) 
OR (tags @> ARRAY['crt:2019_01']::varchar[]) OR (tags @> ARRAY['crt:2019_02']::varchar[]) OR (tags @> ARRAY['crt:2019_03']::varchar[]) 
OR (tags @> ARRAY['crt:2019_04']::varchar[]) OR (tags @> ARRAY['crt:2019_05']::varchar[]) OR (tags @> ARRAY['crt:2019_06']::varchar[]) 
OR (tags @> ARRAY['crt:2019_07']::varchar[]) OR (tags @> ARRAY['crt:2019_08']::varchar[]) OR (tags @> ARRAY['crt:2019_09']::varchar[]) 
OR (tags @> ARRAY['crt:2019_10']::varchar[]) OR (tags @> ARRAY['crt:2019_11']::varchar[]) OR (tags @> ARRAY['crt:2019_12']::varchar[]) 
OR (tags @> ARRAY['crt:2020_01']::varchar[]) OR (tags @> ARRAY['crt:2020_02']::varchar[]) OR (tags @> ARRAY['crt:2020_03']::varchar[]) 
OR (tags @> ARRAY['crt:2020_04']::varchar[]) OR (tags @> ARRAY['crt:2020_05']::varchar[]) OR (tags @> ARRAY['crt:2020_06']::varchar[]) 
OR (tags @> ARRAY['crt:2020_07']::varchar[]) OR (tags @> ARRAY['crt:2020_08']::varchar[]) OR (tags @> ARRAY['crt:2020_09']::varchar[]) 
OR (tags @> ARRAY['crt:2020_10']::varchar[]) OR (tags @> ARRAY['crt:2020_11']::varchar[]) OR (tags @> ARRAY['crt:2020_12']::varchar[])) 
ORDER BY "subscriptions"."created_at" DESC LIMIT 30 OFFSET 0;
 
 Limit  (cost=1000.81..9713.64 rows=30 width=383) (actual time=58047.610..58047.610 rows=0 loops=1)
   ->  Gather Merge  (cost=1000.81..4846203.31 rows=16683 width=383) (actual time=58047.608..58314.635 rows=0 loops=1)
         Workers Planned: 7
         Workers Launched: 7
         ->  Parallel Index Scan using index_subscriptions_on_project_id_and_created_at_and_tags on subscriptions  (cost=0.69..4843159.53 rows=2383 width=383) (actual time=58038.080..58038.080 rows=0 loops=8)
               Index Cond: (project_id = 12345)
               Filter: ((tags @> '{crt:2018_04}'::character varying[]) OR (tags @> '{crt:2018_05}'::character varying[]) OR (tags @> '{crt:2018_06}'::character varying[]) OR (tags @> '{crt:2018_07}'::character varying[]) OR (tags @> '{crt:2018_08}'::character varying[]) OR (tags @> '{crt:2018_09}'::character varying[]) OR (tags @> '{crt:2018_10}'::character varying[]) OR (tags @> '{crt:2018_11}'::character varying[]) OR (tags @> '{crt:2018_12}'::character varying[]) OR (tags @> '{crt:2019_01}'::character varying[]) OR (tags @> '{crt:2019_02}'::character varying[]) OR (tags @> '{crt:2019_03}'::character varying[]) OR (tags @> '{crt:2019_04}'::character varying[]) OR (tags @> '{crt:2019_05}'::character varying[]) OR (tags @> '{crt:2019_06}'::character varying[]) OR (tags @> '{crt:2019_07}'::character varying[]) OR (tags @> '{crt:2019_08}'::character varying[]) OR (tags @> '{crt:2019_09}'::character varying[]) OR (tags @> '{crt:2019_10}'::character varying[]) OR (tags @> '{crt:2019_11}'::character varying[]) OR (tags @> '{crt:2019_12}'::character varying[]) OR (tags @> '{crt:2020_01}'::character varying[]) OR (tags @> '{crt:2020_02}'::character varying[]) OR (tags @> '{crt:2020_03}'::character varying[]) OR (tags @> '{crt:2020_04}'::character varying[]) OR (tags @> '{crt:2020_05}'::character varying[]) OR (tags @> '{crt:2020_06}'::character varying[]) OR (tags @> '{crt:2020_07}'::character varying[]) OR (tags @> '{crt:2020_08}'::character varying[]) OR (tags @> '{crt:2020_09}'::character varying[]) OR (tags @> '{crt:2020_10}'::character varying[]) OR (tags @> '{crt:2020_11}'::character varying[]) OR (tags @> '{crt:2020_12}'::character varying[]))
               Rows Removed by Filter: 1055504
 Planning Time: 1.760 ms
 Execution Time: 58314.737 ms
(10 rows)