explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GPrn

Settings
# exclusive inclusive rows x rows loops node
1. 9.047 11.157 ↑ 1.3 6 1

Bitmap Heap Scan on campaign (cost=508.20..1,636.95 rows=8 width=1,166) (actual time=4.227..11.157 rows=6 loops=1)

  • Recheck Cond: ((subscription_lists && '{division:los-angeles,division:orange-county,channel:groupon-plus,notification:send_surveys,division:g1-local,special:n.
  • Filter: ((schedule_type = ANY ('{manual,recurring}'::text[])) AND ((inclusion_pa_ids_v2 && '{466505,468681,463605,468071,468087,459867,460767,463455,460765,46.
  • Rows Removed by Filter: 1686
  • Heap Blocks: exact=1214
2. 2.110 2.110 ↓ 2.8 1,711 1

Bitmap Index Scan on idx_campaign_compound_email_groupon_send_dates (cost=0.00..508.20 rows=612 width=0) (actual time=2.110..2.110 rows=1,711 loops=1)

  • Index Cond: (subscription_lists && '{division:los-angeles,division:orange-county,channel:groupon-plus,notification:send_surveys,division:g1-local,specia.
Planning time : 4.429 ms
Execution time : 11.265 ms