explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hxDn

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.42..4,058,131,811.87 rows=143,004 width=4) (actual rows= loops=)

  • Workers Planned: 1
2. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on hydra_subscriber (cost=0.42..4,058,116,511.47 rows=84,120 width=4) (actual rows= loops=)

  • Filter: (active AND (list_id = 1) AND (NOT (SubPlan 1)))
3.          

SubPlan (for Parallel Seq Scan)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=0.42..47,822.81 rows=167,885 width=4) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Unique (cost=0.42..46,327.38 rows=167,885 width=4) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using hydra_subscriberlog_subscriber_id_ecd19f5e on hydra_subscriberlog u0 (cost=0.42..45,789.04 rows=215,336 width=4) (actual rows= loops=)

  • Filter: ((created >= '2019-09-07 21:58:41.959341+00'::timestamp with time zone) AND (created <= '2019-11-06 21:58:41.959341+00'::timestamp with time zone) AND (event = 1) AND (campaign_id = ANY ('{65,59,67,66,64,57}'::integer[])))