explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Txf4

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 113,890.759 ↑ 1.9 39 1

Limit (cost=1,660,853.300..1,660,853.870 rows=75 width=49) (actual time=113,890.721..113,890.759 rows=39 loops=1)

  • Buffers: shared hit=154486 read=250267
2. 0.032 113,890.750 ↑ 2.9 39 1

Unique (cost=1,660,853.300..1,660,854.140 rows=112 width=49) (actual time=113,890.718..113,890.750 rows=39 loops=1)

  • Buffers: shared hit=154486 read=250267
3. 0.000 113,890.718 ↑ 2.6 43 1

Sort (cost=1,660,853.300..1,660,853.580 rows=112 width=49) (actual time=113,890.713..113,890.718 rows=43 loops=1)

  • Sort Key: delta_seven3kilo_oscar.november_lima, delta_seven3kilo_oscar.delta_quebec
  • Sort Method: quicksort Memory: 29kB
  • Buffers: shared hit=154486 read=250267
4. 132.412 113,998.991 ↑ 2.6 43 1

Gather (cost=49,431.130..1,660,849.490 rows=112 width=49) (actual time=65,999.763..113,998.991 rows=43 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=154486 read=250267
5. 6.969 113,866.579 ↑ 3.4 14 3

Nested Loop Anti Join (cost=48,431.130..1,659,838.290 rows=47 width=49) (actual time=66,274.947..113,866.579 rows=14 loops=3)

  • Buffers: shared hit=154486 read=250267
6. 20.427 113,859.249 ↑ 2.4 20 3

Nested Loop (cost=48,430.720..1,659,815.220 rows=47 width=82) (actual time=66,273.789..113,859.249 rows=20 loops=3)

  • Buffers: shared hit=154351 read=250203
7. 133.692 113,837.754 ↑ 2.4 20 3

Nested Loop (cost=48,430.160..1,659,479.700 rows=47 width=66) (actual time=66,271.462..113,837.754 rows=20 loops=3)

  • Buffers: shared hit=154187 read=250065
8. 21.547 113,702.709 ↑ 141.6 99 3

Hash Join (cost=48,429.590..1,557,588.620 rows=14,021 width=66) (actual time=66,202.476..113,702.709 rows=99 loops=3)

  • Hash Cond: ((victor0kilo_oscar.sierra_quebec)::text = (hotel_charlie2kilo_oscar.sierra_quebec)::text)
  • Buffers: shared hit=153323 read=249435
9. 47,993.861 54,138.323 ↑ 22.3 8,770 3

Parallel Bitmap Heap Scan on tango two (cost=29,323.230..1,537,608.810 rows=195,530 width=99) (actual time=6,220.158..54,138.323 rows=8,770 loops=3)

  • Recheck Cond: ((sierra_november)::text = 'charlie_zulu'::text)
  • Filter: (kilo_juliet <> delta_kilo)
  • Rows Removed by Filter: 121147
  • Heap Blocks: exact=56504
  • Buffers: shared hit=761 read=173989
10. 6,144.462 6,144.462 ↑ 1.2 392,688 1

Bitmap Index Scan on three_romeo (cost=0.000..29,205.910 rows=471,629 width=0) (actual time=6,144.462..6,144.462 rows=392,688 loops=1)

  • Index Cond: ((sierra_november)::text = 'charlie_zulu'::text)
  • Buffers: shared hit=2 read=5284
11. 236.144 59,542.839 ↓ 1.0 193,115 3

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

  • Buckets: 262144 Batches: 1 Memory Usage: 14307kB
  • Buffers: shared hit=152562 read=75446
12. 29,705.657 59,306.695 ↓ 1.0 193,115 3

Nested Loop (cost=198.700..16,764.250 rows=187,369 width=33) (actual time=1,541.431..59,306.695 rows=193,115 loops=3)

  • Buffers: shared hit=152562 read=75446
13. 0.190 0.803 ↑ 1.0 2 3

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

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

Seq Scan on charlie_charlie mike (cost=0.000..24.440 rows=344 width=33) (actual time=0.046..0.613 rows=350 loops=3)

  • Buffers: shared hit=63
15. 28,832.861 29,600.235 ↓ 44.4 96,558 6

Bitmap Heap Scan on bravo three_victor (cost=173.400..8,347.730 rows=2,174 width=66) (actual time=781.938..29,600.235 rows=96,558 loops=6)

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

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

  • Index Cond: ((quebec_kilo)::text = (foxtrot4kilo_oscar.quebec_kilo)::text)
  • Buffers: shared hit=3969 read=1982
17. 1.353 1.353 ↓ 0.0 0 298

Index Scan using november_juliet on papa romeo_whiskey (cost=0.560..7.270 rows=1 width=66) (actual time=1.353..1.353 rows=0 loops=298)

  • Index Cond: ((six_mike)::text = (victor0kilo_oscar.six_mike)::text)
  • Filter: (((golf)::text = 'six_charlie'::text) AND ((oscar_kilo)::text = ANY ('four'::text[])))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=864 read=630
18. 1.068 1.068 ↑ 1.0 1 60

Index Scan using seven on xray lima (cost=0.560..7.140 rows=1 width=49) (actual time=1.068..1.068 rows=1 loops=60)

  • Index Cond: ((delta_quebec)::text = (zulu1kilo_oscar.delta_quebec)::text)
  • Buffers: shared hit=164 read=138
19. 0.361 0.361 ↓ 0.0 0 60

Index Scan using oscar_golf on whiskey november_yankee (cost=0.420..0.490 rows=1 width=33) (actual time=0.361..0.361 rows=0 loops=60)

  • Index Cond: ((quebec_papa)::text = (victor0kilo_oscar.quebec_papa)::text)
  • Filter: ((hotel_bravo)::text <> 'delta_mike'::text)
  • Buffers: shared hit=135 read=64
Planning time : 5.972 ms
Execution time : 114,006.927 ms