explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZkNl

Settings

Optimization(s) for this plan:

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

query plan: +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Unique (cost=743,235.83..743,511.21 rows=55,077 width=96) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=743,235.83..743,373.52 rows=55,077 width=96) (actual rows= loops=)

  • Sort Key: em2.event_id
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=18,387.49..736,074.24 rows=55,077 width=96) (actual rows= loops=)

  • Join Filter: (((event_metadata.start_time >= em2.end_time) AND (event_metadata.start_time <= em2.technical_end_time)) OR ((event_metadata.end_time >= em2.technical_start_time) AND (event_metadata.end_time <= em2.start_time)))
4. 0.000 0.000 ↓ 0.0

Index Scan using event_metadata_pkey on event_metadata (cost=0.69..20.64 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((event_id)::text = 'crid:~~2F~~2Fjoery.tv~~2FE2E40-Single786-V11,imi:c67554870e2f6411bb09b6aac5e1beaaa3350b56'::text)
  • Filter: (channel_id = 'E2E40'::text)
5. 0.000 0.000 ↓ 0.0

Gather (cost=18,386.80..730,805.11 rows=262,425 width=136) (actual rows= loops=)

  • Workers Planned: 2
6. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on event_metadata em2 (cost=17,386.80..703,562.61 rows=109,344 width=136) (actual rows= loops=)

  • Recheck Cond: (channel_id = 'E2E40'::text)
  • Filter: (NOT deleted)
7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_event_metadata_channel_id_start_time_end_time (cost=0.00..17,321.19 rows=290,218 width=0) (actual rows= loops=)

  • Index Cond: (channel_id = 'E2E40'::text)