explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z1d

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.300 0.710 ↑ 40.1 9 1

Bitmap Heap Scan on final (cost=54.80..1,343.34 rows=361 width=71) (actual time=0.506..0.710 rows=9 loops=1)

  • Recheck Cond: ('{amd-aggr_AAABMCYP,amd-gds_ADABMCAA,expedia_554955}'::text[] && provider_ids)
  • Filter: (active AND ('{amd-aggr_AAABMCYP,amd-gds_ADABMCAA,expedia_554955}'::text[] <> provider_ids))
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=2
2. 0.410 0.410 ↑ 36.1 10 1

Bitmap Index Scan on final_provider_ids_idx (cost=0.00..54.71 rows=361 width=0) (actual time=0.410..0.410 rows=10 loops=1)

  • Index Cond: ('{amd-aggr_AAABMCYP,amd-gds_ADABMCAA,expedia_554955}'::text[] && provider_ids)