explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aDQs

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 5,741.245 ↑ 1.0 1 1

Limit (cost=376.14..376.15 rows=1 width=446) (actual time=5,741.244..5,741.245 rows=1 loops=1)

  • Buffers: shared hit=205 read=1,371
  • I/O Timings: read=5,731.643
2. 0.005 5,741.243 ↑ 1.0 1 1

Sort (cost=376.14..376.15 rows=1 width=446) (actual time=5,741.243..5,741.243 rows=1 loops=1)

  • Sort Key: event_metadata.start_time
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=205 read=1,371
  • I/O Timings: read=5,731.643
3. 0.006 5,741.238 ↑ 1.0 1 1

Unique (cost=376.11..376.12 rows=1 width=446) (actual time=5,741.233..5,741.238 rows=1 loops=1)

  • Buffers: shared hit=205 read=1,371
  • I/O Timings: read=5,731.643
4. 0.019 5,741.232 ↓ 6.0 6 1

Sort (cost=376.11..376.12 rows=1 width=446) (actual time=5,741.231..5,741.232 rows=6 loops=1)

  • Sort Key: event_metadata.title_id, event_metadata.start_time
  • Sort Method: quicksort Memory: 28kB
  • Buffers: shared hit=205 read=1,371
  • I/O Timings: read=5,731.643
5. 5,516.280 5,741.213 ↓ 6.0 6 1

Index Scan using rk_test on event_metadata (cost=368.08..376.10 rows=1 width=446) (actual time=5,741.033..5,741.213 rows=6 loops=1)

  • Index 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) AND (NOT (hashed SubPlan 1)))
  • Rows Removed by Filter: 1,660
  • Buffers: shared hit=205 read=1,371
  • I/O Timings: read=5,731.643
6.          

SubPlan (for Index Scan)

7. 0.006 224.933 ↓ 6.0 6 1

Unique (cost=367.51..367.51 rows=1 width=33) (actual time=224.927..224.933 rows=6 loops=1)

  • Buffers: shared hit=32 read=20
  • I/O Timings: read=224.367
8. 0.042 224.927 ↓ 12.0 12 1

Sort (cost=367.51..367.51 rows=1 width=33) (actual time=224.926..224.927 rows=12 loops=1)

  • Sort Key: customer_recording.title_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=32 read=20
  • I/O Timings: read=224.367
9. 0.030 224.885 ↓ 12.0 12 1

Nested Loop (cost=1.24..367.50 rows=1 width=33) (actual time=35.550..224.885 rows=12 loops=1)

  • Buffers: shared hit=32 read=20
  • I/O Timings: read=224.367
10. 134.987 134.987 ↓ 6.0 6 1

Index Scan using idx_temp_dddd on customer_recording (cost=0.55..350.79 rows=1 width=111) (actual time=34.909..134.987 rows=6 loops=1)

  • Index Cond: ((customer_id)::text = 'ndvr-test-cus735694799_nl'::text)
  • Filter: ((recording_type = 'nDVR'::text) AND (channel_id = '9050'::text))
  • Buffers: shared read=10
  • I/O Timings: read=134.887
11. 89.868 89.868 ↓ 2.0 2 6

Index Scan using event_metadata_pkey on event_metadata event_metadata_1 (cost=0.69..16.70 rows=1 width=96) (actual time=14.976..14.978 rows=2 loops=6)

  • Index Cond: ((event_id)::text = (customer_recording.event_id)::text)
  • Filter: (show_id = 'crid:~~2F~~2Fbds.tv~~2F164093675'::text)
  • Buffers: shared hit=32 read=10
  • I/O Timings: read=89.480
Planning time : 0.957 ms
Execution time : 5,741.327 ms