explain.depesz.com

PostgreSQL's explain analyze made readable

Result: agy9

Settings
# exclusive inclusive rows x rows loops node
1. 157.021 87,389.644 ↑ 1.0 75 1

Limit (cost=4,289,948.800..4,289,949.360 rows=75 width=49) (actual time=87,232.570..87,389.644 rows=75 loops=1)

  • Buffers: shared hit=381546 read=286196
2. 0.051 87,232.623 ↑ 19.1 75 1

Unique (cost=4,289,948.800..4,289,959.530 rows=1,431 width=49) (actual time=87,232.567..87,232.623 rows=75 loops=1)

  • Buffers: shared hit=381546 read=286196
3. 0.000 87,232.572 ↑ 17.0 84 1

Sort (cost=4,289,948.800..4,289,952.380 rows=1,431 width=49) (actual time=87,232.563..87,232.572 rows=84 loops=1)

  • Sort Key: delta_seven3kilo_oscar.november_lima, delta_seven3kilo_oscar.delta_quebec
  • Sort Method: quicksort Memory: 49kB
  • Buffers: shared hit=381546 read=286196
4. 185.688 87,388.236 ↑ 6.2 229 1

Gather (cost=104,915.800..4,289,873.800 rows=1,431 width=49) (actual time=1,102.592..87,388.236 rows=229 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=381543 read=286196
5. 124.669 87,202.548 ↑ 7.8 76 3

Nested Loop (cost=103,915.800..4,288,730.700 rows=596 width=49) (actual time=1,093.149..87,202.548 rows=76 loops=3)

  • Buffers: shared hit=381543 read=286196
6. 14.466 87,076.229 ↑ 7.8 76 3

Nested Loop Anti Join (cost=103,915.240..4,285,931.430 rows=596 width=33) (actual time=1,093.092..87,076.229 rows=76 loops=3)

  • Buffers: shared hit=380870 read=285722
7. 627.610 87,061.594 ↑ 7.1 84 3

Nested Loop (cost=103,914.820..4,285,669.130 rows=597 width=66) (actual time=1,093.046..87,061.594 rows=84 loops=3)

  • Buffers: shared hit=380263 read=285548
8. 82.314 86,432.020 ↑ 126.7 320 3

Hash Join (cost=103,914.260..4,048,451.690 rows=40,557 width=66) (actual time=1,084.143..86,432.020 rows=320 loops=3)

  • Hash Cond: ((victor0kilo_oscar.sierra_quebec)::text = (hotel2kilo_oscar.sierra_quebec)::text)
  • Buffers: shared hit=377826 read=283170
9. 85,289.785 85,627.791 ↑ 20.6 27,478 3

Parallel Bitmap Heap Scan on tango two (cost=84,807.890..4,026,818.780 rows=565,594 width=99) (actual time=307.147..85,627.791 rows=27,478 loops=3)

  • Recheck Cond: ((sierra_november)::text = 'bravo_yankee'::text)
  • Filter: (kilo_juliet <> delta_kilo)
  • Rows Removed by Filter: 441209
  • Heap Blocks: exact=135072
  • Buffers: shared hit=149818 read=283170
10. 338.006 338.006 ↓ 1.0 1,414,897 1

Bitmap Index Scan on three_romeo (cost=0.000..84,468.540 rows=1,364,246 width=0) (actual time=338.005..338.006 rows=1,414,897 loops=1)

  • Index Cond: ((sierra_november)::text = 'bravo_yankee'::text)
  • Buffers: shared hit=20740
11. 57.176 721.915 ↓ 1.0 193,115 3

Hash (cost=16,764.250..16,764.250 rows=187,369 width=33) (actual time=721.915..721.915 rows=193,115 loops=3)

  • Buckets: 262144 Batches: 1 Memory Usage: 14307kB
  • Buffers: shared hit=228008
12. 344.520 664.739 ↓ 1.0 193,115 3

Nested Loop (cost=198.700..16,764.250 rows=187,369 width=33) (actual time=81.613..664.739 rows=193,115 loops=3)

  • Buffers: shared hit=228008
13. 0.135 0.744 ↑ 1.0 2 3

HashAggregate (cost=25.300..25.320 rows=2 width=33) (actual time=0.741..0.744 rows=2 loops=3)

  • Group Key: (foxtrot4kilo_oscar.quebec_kilo)::text
  • Buffers: shared hit=63
14. 0.609 0.609 ↓ 1.0 350 3

Seq Scan on charlie mike (cost=0.000..24.440 rows=344 width=33) (actual time=0.049..0.609 rows=350 loops=3)

  • Buffers: shared hit=63
15. 288.410 319.475 ↓ 44.4 96,558 6

Bitmap Heap Scan on bravo_six three_victor (cost=173.400..8,347.730 rows=2,174 width=66) (actual time=40.593..319.475 rows=96,558 loops=6)

  • Recheck Cond: ((quebec_kilo)::text = (foxtrot4kilo_oscar.quebec_kilo)::text)
  • Heap Blocks: exact=73998
  • Buffers: shared hit=227945
16. 31.065 31.065 ↓ 44.4 96,558 6

Bitmap Index Scan on romeo_yankee (cost=0.000..172.860 rows=2,174 width=0) (actual time=31.064..31.065 rows=96,558 loops=6)

  • Index Cond: ((quebec_kilo)::text = (foxtrot4kilo_oscar.quebec_kilo)::text)
  • Buffers: shared hit=5951
17. 1.964 1.964 ↓ 0.0 0 959

Index Scan using november_juliet on papa romeo_whiskey (cost=0.560..5.850 rows=1 width=66) (actual time=1.964..1.964 rows=0 loops=959)

  • Index Cond: ((six_mike)::text = (victor0kilo_oscar.six_mike)::text)
  • Filter: (((golf)::text = 'six_charlie'::text) AND ((oscar_kilo)::text = ANY ('uniform'::text[])))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=2437 read=2378
18. 0.169 0.169 ↓ 0.0 0 251

Index Only Scan using oscar_golf on whiskey november_yankee (cost=0.420..0.440 rows=1 width=33) (actual time=0.169..0.169 rows=0 loops=251)

  • Index Cond: (quebec_papa = (victor0kilo_oscar.quebec_papa)::text)
  • Heap Fetches: 18
  • Buffers: shared hit=607 read=174
19. 1.650 1.650 ↑ 1.0 1 229

Index Scan using seven on xray lima (cost=0.560..4.700 rows=1 width=49) (actual time=1.650..1.650 rows=1 loops=229)

  • Index Cond: ((delta_quebec)::text = (zulu1kilo_oscar.delta_quebec)::text)
  • Buffers: shared hit=673 read=474
Planning time : 22.931 ms
Execution time : 87,397.407 ms