explain.depesz.com

PostgreSQL's explain analyze made readable

Result: F2Ff

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 501,430.801 ↑ 761.0 11 1

Unique (cost=183,146.98..183,188.84 rows=8,371 width=96) (actual time=501,430.794..501,430.801 rows=11 loops=1)

  • Buffers: shared hit=67,462 read=29,331 dirtied=6
  • I/O Timings: read=154,824.453
2. 0.168 501,430.793 ↑ 380.5 22 1

Sort (cost=183,146.98..183,167.91 rows=8,371 width=96) (actual time=501,430.792..501,430.793 rows=22 loops=1)

  • Sort Key: em2.event_id
  • Sort Method: quicksort Memory: 28kB
  • Buffers: shared hit=67,462 read=29,331 dirtied=6
  • I/O Timings: read=154,824.453
3. 0.039 501,430.625 ↑ 380.5 22 1

Nested Loop (cost=4,818.60..182,601.56 rows=8,371 width=96) (actual time=201,011.169..501,430.625 rows=22 loops=1)

  • Buffers: shared hit=67,462 read=29,331 dirtied=6
  • I/O Timings: read=154,824.453
4. 0.005 5.996 ↓ 2.0 2 1

Limit (cost=0.69..16.72 rows=1 width=51) (actual time=0.047..5.996 rows=2 loops=1)

  • Buffers: shared hit=7
5. 5.991 5.991 ↓ 2.0 2 1

Index Scan using event_metadata_pkey on event_metadata (cost=0.69..16.72 rows=1 width=51) (actual time=0.046..5.991 rows=2 loops=1)

  • Index Cond: ((event_id)::text = 'crid:~~2F~~2Fjoery.tv~~2FE2E40-Single786-V11,imi:c67554870e2f6411bb09b6aac5e1beaaa3350b56'::text)
  • Filter: (channel_id = 'E2E40'::text)
  • Buffers: shared hit=7
6. 499,985.110 501,424.590 ↑ 760.9 11 2

Bitmap Heap Scan on event_metadata em2 (cost=4,817.91..182,501.13 rows=8,370 width=131) (actual time=206,936.951..250,712.295 rows=11 loops=2)

  • Recheck Cond: (((channel_id = 'E2E40'::text) AND (event_metadata.start_time >= end_time)) OR ((channel_id = 'E2E40'::text) AND (event_metadata.end_time <= start_time)))
  • Filter: ((NOT deleted) AND (event_metadata.language = language) AND (((event_metadata.start_time >= end_time) AND (event_metadata.start_time <= technical_end_time)) OR ((event_metadata.end_time >= technical_start_time) AND (event_metadata.end_time <= start_time))))
  • Rows Removed by Filter: 77,729
  • Heap Blocks: exact=94,838
  • Buffers: shared hit=67,455 read=29,331 dirtied=6
  • I/O Timings: read=154,824.453
7. 0.024 1,439.480 ↓ 0.0 0 2

BitmapOr (cost=4,817.91..4,817.91 rows=55,831 width=0) (actual time=719.740..719.740 rows=0 loops=2)

  • Buffers: shared hit=1,880 read=68
  • I/O Timings: read=30.470
8. 1,409.086 1,409.086 ↓ 1.5 42,015 2

Bitmap Index Scan on idx_event_metadata_channel_id_start_time_end_time (cost=0.00..3,610.02 rows=27,915 width=0) (actual time=704.543..704.543 rows=42,015 loops=2)

  • Index Cond: ((channel_id = 'E2E40'::text) AND (event_metadata.start_time >= end_time))
  • Buffers: shared hit=1,518 read=68
  • I/O Timings: read=30.470
9. 30.370 30.370 ↓ 1.3 36,096 2

Bitmap Index Scan on idx_event_metadata_channel_id_start_time_end_time (cost=0.00..1,203.71 rows=27,915 width=0) (actual time=15.185..15.185 rows=36,096 loops=2)

  • Index Cond: ((channel_id = 'E2E40'::text) AND (event_metadata.end_time <= start_time))
  • Buffers: shared hit=362
Planning time : 0.267 ms
Execution time : 501,430.856 ms