explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wpOh

Settings
# exclusive inclusive rows x rows loops node
1. 0.460 13,093.064 ↓ 6.0 6 1

Nested Loop Left Join (cost=605.06..617.12 rows=1 width=1,135) (actual time=12,860.137..13,093.064 rows=6 loops=1)

  • Filter: (cm.event_id IS NULL)
  • Rows Removed by Filter: 98
2. 11,368.578 12,856.836 ↓ 104.0 104 1

Bitmap Heap Scan on event_metadata x (cost=604.51..608.53 rows=1 width=533) (actual time=3,515.974..12,856.836 rows=104 loops=1)

  • Recheck Cond: ((show_id = 'crid:~~2F~~2Fbds.tv~~2F164093675'::text) AND (channel_id = '9050'::text))
  • Filter: ((NOT is_blackout) AND (NOT deleted) AND ((season_number >= 100,000) OR (season_number IS NULL)) AND (COALESCE(actual_start_time, start_time) > '2020-08-27 21:59:50+02'::timestamp with time zone))
  • Rows Removed by Filter: 1,562
  • Heap Blocks: exact=1,508
3. 0.433 1,488.258 ↓ 0.0 0 1

BitmapAnd (cost=604.51..604.51 rows=1 width=0) (actual time=1,488.258..1,488.258 rows=0 loops=1)

4. 912.083 912.083 ↓ 11.6 6,944 1

Bitmap Index Scan on idx_event_metadata_show_id (cost=0.00..41.04 rows=597 width=0) (actual time=912.083..912.083 rows=6,944 loops=1)

  • Index Cond: (show_id = 'crid:~~2F~~2Fbds.tv~~2F164093675'::text)
5. 575.742 575.742 ↑ 1.2 9,522 1

Bitmap Index Scan on idx_event_metadata_channel_id_start_time_end_time (cost=0.00..563.22 rows=11,021 width=0) (actual time=575.742..575.742 rows=9,522 loops=1)

  • Index Cond: (channel_id = '9050'::text)
6. 235.768 235.768 ↑ 1.0 1 104

Index Scan using idx_customer_recording_title_channel on customer_recording cm (cost=0.55..8.58 rows=1 width=602) (actual time=2.266..2.267 rows=1 loops=104)

  • Index Cond: ((title_id = x.title_id) AND (channel_id = '9050'::text) AND (recording_type = 'nDVR'::text) AND ((customer_id)::text = 'ndvr-test-cus735694799_nl'::text))
  • Filter: (show_id = 'crid:~~2F~~2Fbds.tv~~2F164093675'::text)
Planning time : 1.741 ms
Execution time : 13,093.156 ms