explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3Sbi : ㅁㅁ

Settings
# exclusive inclusive rows x rows loops node
1. 1.108 690.064 ↓ 30.0 30 1

Subquery Scan on romeo_three (cost=4,504.090..4,571.490 rows=1 width=222) (actual time=325.474..690.064 rows=30 loops=1)

  • Filter: ((romeo_three.november_bravo >= 1) AND (romeo_three.november_bravo <= 30))
  • Rows Removed by Filter: 6,669
  • Buffers: shared hit=214,725
2. 263.725 688.956 ↓ 6,699.0 6,699 1

WindowAgg (cost=4,504.090..4,571.480 rows=1 width=222) (actual time=325.473..688.956 rows=6,699 loops=1)

  • Buffers: shared hit=214,725
3. 15.787 325.934 ↓ 6,699.0 6,699 1

Sort (cost=4,504.090..4,504.090 rows=1 width=79) (actual time=325.154..325.934 rows=6,699 loops=1)

  • Sort Key: quebec.delta_zulu DESC, quebec.delta_yankee DESC
  • Sort Method: quicksort Memory: 1,135kB
  • Buffers: shared hit=105,666
4. 5.002 310.147 ↓ 6,699.0 6,699 1

Nested Loop Left Join (cost=4,005.640..4,504.080 rows=1 width=79) (actual time=9.160..310.147 rows=6,699 loops=1)

  • Buffers: shared hit=105,666
5. 3.705 238.155 ↓ 6,699.0 6,699 1

Nested Loop Left Join (cost=4,005.090..4,503.440 rows=1 width=74) (actual time=9.145..238.155 rows=6,699 loops=1)

  • Buffers: shared hit=76,562
6. 0.000 160.761 ↓ 6,699.0 6,699 1

Nested Loop Anti Join (cost=4,004.530..4,502.650 rows=1 width=69) (actual time=9.127..160.761 rows=6,699 loops=1)

  • Join Filter: (tango.three_alpha = six_three.three_alpha)
  • Buffers: shared hit=47,444
7. 7.419 101.461 ↓ 6,699.0 6,699 1

Nested Loop (cost=4,003.680..4,501.380 rows=1 width=69) (actual time=9.110..101.461 rows=6,699 loops=1)

  • Buffers: shared hit=27,308
8. 3.261 13.654 ↓ 1,116.5 6,699 1

Hash Join (cost=4,003.130..4,475.570 rows=6 width=84) (actual time=9.081..13.654 rows=6,699 loops=1)

  • Hash Cond: (((quebec.golf_echo)::text = (six_three.golf_echo)::text) AND (quebec.three_alpha = six_three.three_alpha))
  • Buffers: shared hit=277
9. 1.355 1.643 ↑ 1.0 6,729 1

Bitmap Heap Scan on golf_six quebec (cost=132.440..569.550 rows=6,729 width=69) (actual time=0.308..1.643 rows=6,729 loops=1)

  • Recheck Cond: ((six_lima)::text = 'hotel_november'::text)
  • Heap Blocks: exact=218
  • Buffers: shared hit=239
10. 0.288 0.288 ↑ 1.0 6,729 1

Bitmap Index Scan on alpha_juliet (cost=0.000..130.750 rows=6,729 width=0) (actual time=0.288..0.288 rows=6,729 loops=1)

  • Index Cond: ((six_lima)::text = 'hotel_november'::text)
  • Buffers: shared hit=21
11. 1.224 8.750 ↓ 5.6 6,717 1

Hash (cost=3,852.690..3,852.690 rows=1,200 width=19) (actual time=8.750..8.750 rows=6,717 loops=1)

  • Buckets: 8,192 (originally 2048) Batches: 1 (originally 1) Memory Usage: 399kB
  • Buffers: shared hit=38
12. 7.526 7.526 ↓ 5.6 6,717 1

Index Scan using alpha_charlie on romeo_zulu six_three (cost=0.430..3,852.690 rows=1,200 width=19) (actual time=0.037..7.526 rows=6,717 loops=1)

  • Index Cond: (((five_six)::text = 'november_tango'::text) AND ((november_whiskey)::text = 'india_five'::text))
  • Filter: ((bravo_tango)::text = 'delta_oscar'::text)
  • Rows Removed by Filter: 81
  • Buffers: shared hit=38
13. 80.388 80.388 ↑ 1.0 1 6,699

Index Only Scan using victor_four on xray_india papa (cost=0.560..4.300 rows=1 width=23) (actual time=0.012..0.012 rows=1 loops=6,699)

  • Index Cond: ((bravo_tango = 'delta_oscar'::text) AND (golf_echo = (quebec.golf_echo)::text) AND (bravo_lima = (quebec.bravo_lima)::text) AND (whiskey_three = 'hotel_november'::text))
  • Heap Fetches: 0
  • Buffers: shared hit=27,031
14. 6.699 60.291 ↓ 0.0 0 6,699

Nested Loop (cost=0.840..1.260 rows=1 width=19) (actual time=0.009..0.009 rows=0 loops=6,699)

  • Buffers: shared hit=20,136
15. 53.592 53.592 ↓ 0.0 0 6,699

Index Scan using uniform_tango on two_alpha juliet_xray (cost=0.420..0.480 rows=1 width=23) (actual time=0.008..0.008 rows=0 loops=6,699)

  • Index Cond: ((golf_echo)::text = (papa.golf_echo)::text)
  • Filter: ((three_zulu_juliet)::text = 'hotel_november'::text)
  • Buffers: shared hit=20,136
16. 0.000 0.000 ↓ 0.0 0

Index Scan using five_juliet on juliet_golf tango (cost=0.420..0.750 rows=2 width=12) (never executed)

  • Index Cond: ((three_foxtrot)::text = (juliet_xray.three_foxtrot)::text)
17. 73.689 73.689 ↓ 0.0 0 6,699

Index Scan using juliet_seven on delta_papa kilo (cost=0.560..0.770 rows=2 width=20) (actual time=0.011..0.011 rows=0 loops=6,699)

  • Index Cond: ((golf_echo)::text = (papa.golf_echo)::text)
  • Filter: ((charlie_mike)::text = ANY ('echo'::text[]))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=29,118
18. 66.990 66.990 ↓ 0.0 0 6,699

Index Scan using juliet_seven on delta_papa yankee_zulu (cost=0.560..0.720 rows=2 width=20) (actual time=0.010..0.010 rows=0 loops=6,699)

  • Index Cond: (((papa.golf_echo)::text = (golf_echo)::text) AND (whiskey_foxtrot = 1))
  • Buffers: shared hit=29,104
19.          

SubPlan (for WindowAgg)

20. 6.699 26.796 ↑ 1.0 1 6,699

Aggregate (cost=24.400..24.410 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=6,699)

  • Buffers: shared hit=23,937
21. 20.097 20.097 ↑ 2.5 4 6,699

Index Scan using mike on hotel_papa juliet_victor (cost=0.420..24.340 rows=10 width=7) (actual time=0.002..0.003 rows=4 loops=6,699)

  • Index Cond: (delta_yankee = quebec.delta_yankee)
  • Buffers: shared hit=23,937
22. 13.398 26.796 ↑ 1.0 1 6,699

Aggregate (cost=24.380..24.390 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=6,699)

  • Buffers: shared hit=23,937
23. 13.398 13.398 ↑ 4.0 1 6,699

Index Scan using mike on hotel_papa two_papa (cost=0.420..24.370 rows=4 width=8) (actual time=0.002..0.002 rows=1 loops=6,699)

  • Index Cond: (delta_yankee = quebec.delta_yankee)
  • Filter: ((two_bravo)::text = 'delta_oscar'::text)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=23,937
24. 1.385 45.705 ↑ 1.0 1 1,385

Limit (cost=1.990..18.160 rows=1 width=32) (actual time=0.032..0.033 rows=1 loops=1,385)

  • Buffers: shared hit=25,272
25. 1.385 44.320 ↑ 1.0 1 1,385

Nested Loop (cost=1.990..18.160 rows=1 width=32) (actual time=0.032..0.032 rows=1 loops=1,385)

  • Buffers: shared hit=25,272
26. 1.385 34.625 ↑ 1.0 1 1,385

Nested Loop (cost=1.550..17.650 rows=1 width=7) (actual time=0.025..0.025 rows=1 loops=1,385)

  • Buffers: shared hit=19,730
27. 1.385 22.160 ↑ 1.0 1 1,385

Nested Loop (cost=0.990..17.030 rows=1 width=20) (actual time=0.016..0.016 rows=1 loops=1,385)

  • Buffers: shared hit=12,491
28. 15.235 15.235 ↑ 1.0 1 1,385

Index Scan using three_zulu_xray on seven_mike india_november (cost=0.430..8.450 rows=1 width=4) (actual time=0.011..0.011 rows=1 loops=1,385)

  • Index Cond: (((golf_echo)::text = (papa.golf_echo)::text) AND (three_alpha = six_three.three_alpha))
  • Buffers: shared hit=5,560
29. 5.540 5.540 ↑ 1.0 1 1,385

Index Scan using yankee_yankee on five_uniform uniform_two (cost=0.560..8.580 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=1,385)

  • Index Cond: (charlie_oscar = india_november.charlie_oscar)
  • Buffers: shared hit=6,931
30. 11.080 11.080 ↑ 1.0 1 1,385

Index Scan using xray_delta on xray_victor seven_foxtrot (cost=0.560..0.620 rows=1 width=27) (actual time=0.008..0.008 rows=1 loops=1,385)

  • Index Cond: ((victor_alpha)::text = (uniform_two.victor_alpha)::text)
  • Buffers: shared hit=7,239
31. 8.310 8.310 ↑ 1.0 1 1,385

Index Scan using whiskey_delta on five_oscar four (cost=0.430..0.510 rows=1 width=51) (actual time=0.006..0.006 rows=1 loops=1,385)

  • Index Cond: ((six_romeo)::text = (seven_foxtrot.six_romeo)::text)
  • Buffers: shared hit=5,542