explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9jla

Settings
# exclusive inclusive rows x rows loops node
1. 0.526 18,145.989 ↓ 6.0 6 1

Nested Loop Left Join (cost=596.65..608.72 rows=1 width=1,130) (actual time=17,903.735..18,145.989 rows=6 loops=1)

  • Filter: (cm.event_id IS NULL)
  • Rows Removed by Filter: 98
  • Buffers: shared hit=746 read=1,541
  • I/O Timings: read=17,764.003
2. 15,862.679 18,141.615 ↓ 104.0 104 1

Bitmap Heap Scan on event_metadata x (cost=596.10..600.12 rows=1 width=530) (actual time=5,062.643..18,141.615 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
  • Buffers: shared hit=174 read=1,541
  • I/O Timings: read=17,764.003
3. 0.401 2,278.936 ↓ 0.0 0 1

BitmapAnd (cost=596.10..596.10 rows=1 width=0) (actual time=2,278.936..2,278.936 rows=0 loops=1)

  • Buffers: shared hit=2 read=205
  • I/O Timings: read=2,273.347
4. 1,431.352 1,431.352 ↓ 11.4 6,944 1

Bitmap Index Scan on idx_event_metadata_show_id (cost=0.00..41.12 rows=608 width=0) (actual time=1,431.352..1,431.352 rows=6,944 loops=1)

  • Index Cond: (show_id = 'crid:~~2F~~2Fbds.tv~~2F164093675'::text)
  • Buffers: shared read=116
  • I/O Timings: read=1,428.865
5. 847.183 847.183 ↑ 1.2 9,522 1

Bitmap Index Scan on idx_event_metadata_channel_id_start_time_end_time (cost=0.00..554.73 rows=10,956 width=0) (actual time=847.183..847.183 rows=9,522 loops=1)

  • Index Cond: (channel_id = '9050'::text)
  • Buffers: shared hit=2 read=89
  • I/O Timings: read=844.482
6. 3.848 3.848 ↑ 1.0 1 104

Index Scan using idx_customer_recording_title_channel on customer_recording cm (cost=0.55..8.59 rows=1 width=600) (actual time=0.036..0.037 rows=1 loops=104)

  • Index Cond: ((title_id = x.title_id) AND (channel_id = x.channel_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) AND (show_id = x.show_id))
  • Buffers: shared hit=572
Planning time : 1.651 ms
Execution time : 18,146.073 ms