explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BjuA

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 11,147.361 ↑ 1.0 1 1

Limit (cost=974.11..974.11 rows=1 width=446) (actual time=11,147.360..11,147.361 rows=1 loops=1)

2. 0.006 11,147.359 ↑ 1.0 1 1

Sort (cost=974.11..974.11 rows=1 width=446) (actual time=11,147.359..11,147.359 rows=1 loops=1)

  • Sort Key: event_metadata.start_time
  • Sort Method: quicksort Memory: 25kB
3. 0.005 11,147.353 ↑ 1.0 1 1

Unique (cost=974.08..974.09 rows=1 width=446) (actual time=11,147.349..11,147.353 rows=1 loops=1)

4. 0.025 11,147.348 ↓ 6.0 6 1

Sort (cost=974.08..974.09 rows=1 width=446) (actual time=11,147.348..11,147.348 rows=6 loops=1)

  • Sort Key: event_metadata.title_id, event_metadata.start_time
  • Sort Method: quicksort Memory: 28kB
5. 10,328.763 11,147.323 ↓ 6.0 6 1

Bitmap Heap Scan on event_metadata (cost=970.05..974.07 rows=1 width=446) (actual time=10,993.838..11,147.323 rows=6 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) AND (NOT (hashed SubPlan 1)))
  • Rows Removed by Filter: 1,660
  • Heap Blocks: exact=1,508
6. 0.549 643.531 ↓ 0.0 0 1

BitmapAnd (cost=596.10..596.10 rows=1 width=0) (actual time=643.531..643.531 rows=0 loops=1)

7. 141.489 141.489 ↓ 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=141.489..141.489 rows=6,944 loops=1)

  • Index Cond: (show_id = 'crid:~~2F~~2Fbds.tv~~2F164093675'::text)
8. 501.493 501.493 ↑ 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=501.493..501.493 rows=9,522 loops=1)

  • Index Cond: (channel_id = '9050'::text)
9.          

SubPlan (for Bitmap Heap Scan)

10. 0.005 175.029 ↓ 6.0 6 1

Unique (cost=373.94..373.95 rows=1 width=33) (actual time=175.024..175.029 rows=6 loops=1)

11. 0.059 175.024 ↓ 12.0 12 1

Sort (cost=373.94..373.94 rows=1 width=33) (actual time=175.023..175.024 rows=12 loops=1)

  • Sort Key: customer_recording.title_id
  • Sort Method: quicksort Memory: 25kB
12. 0.028 174.965 ↓ 12.0 12 1

Nested Loop (cost=1.24..373.93 rows=1 width=33) (actual time=0.558..174.965 rows=12 loops=1)

13. 0.223 0.223 ↓ 6.0 6 1

Index Scan using idx_temp_dddd on customer_recording (cost=0.55..357.22 rows=1 width=111) (actual time=0.199..0.223 rows=6 loops=1)

  • Index Cond: ((customer_id)::text = 'ndvr-test-cus735694799_nl'::text)
  • Filter: ((recording_type = 'nDVR'::text) AND (channel_id = '9050'::text))
14. 174.714 174.714 ↓ 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=20.809..29.119 rows=2 loops=6)

  • Index Cond: ((event_id)::text = (customer_recording.event_id)::text)
  • Filter: (show_id = 'crid:~~2F~~2Fbds.tv~~2F164093675'::text)
Planning time : 1.650 ms
Execution time : 11,147.450 ms