explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M4Wz

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

HashAggregate (cost=1,293.79..1,301.08 rows=729 width=78) (actual rows= loops=)

  • Group Key: rid, zone, channel, window_start_epoch, window_duration, break_number, num_position, commercial_spot_id, spot_length, break_time, timezone_ccms
2. 0.000 0.000 ↓ 0.0

Seq Scan on schedule (cost=0.00..1,273.09 rows=753 width=78) (actual rows= loops=)

  • Filter: ((rid = '6'::text) AND (zid = '059'::text) AND (airdate = '2019-02-07'::text) AND (cid = ANY ('{M0,M4,M5}'::text[])))