explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xczY : Optimization for: Optimization for: plan #fg0r; plan #ov3v

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 50.887 198.742 ↓ 109.0 77,923 1

Hash Left Join (cost=105.94..223.10 rows=715 width=5,382) (actual time=38.074..198.742 rows=77,923 loops=1)

  • Hash Cond: (alpha_seven.zulu_lima = papa_india_alpha.quebec)
2. 41.702 147.823 ↓ 109.0 77,923 1

Hash Left Join (cost=104.69..219.25 rows=715 width=4,312) (actual time=38.013..147.823 rows=77,923 loops=1)

  • Hash Cond: (lima_four.hotel_xray = oscar_mike.quebec)
3. 45.529 106.098 ↓ 109.0 77,923 1

Hash Left Join (cost=103.40..215.68 rows=715 width=4,242) (actual time=37.956..106.098 rows=77,923 loops=1)

  • Hash Cond: (alpha_seven.quebec = two.bravo)
4. 23.778 60.475 ↓ 20.3 14,521 1

Hash Right Join (cost=100.81..203.26 rows=715 width=3,102) (actual time=37.841..60.475 rows=14,521 loops=1)

  • Hash Cond: (papa_xray.yankee_whiskey = juliet.quebec)
  • Join Filter: (golf.zulu_lima = 'india_four'::uuid)
  • Rows Removed by Join Filter: 31,949
5. 0.104 0.104 ↑ 1.0 359 1

Seq Scan on foxtrot_oscar papa_xray (cost=0.00..8.59 rows=359 width=55) (actual time=0.020..0.104 rows=359 loops=1)

6. 16.256 36.593 ↓ 7.7 5,540 1

Hash (cost=91.88..91.88 rows=715 width=3,047) (actual time=36.593..36.593 rows=5,540 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 3,121kB
7. 6.495 20.337 ↓ 7.7 5,540 1

Hash Left Join (cost=44.01..91.88 rows=715 width=3,047) (actual time=9.047..20.337 rows=5,540 loops=1)

  • Hash Cond: (lima_four.quebec = juliet.sierra)
8. 4.394 13.653 ↓ 6.4 2,306 1

Hash Right Join (cost=39.37..82.31 rows=358 width=1,837) (actual time=8.842..13.653 rows=2,306 loops=1)

  • Hash Cond: (alpha_two.quebec = foxtrot_mike.hotel_echo)
9. 0.469 0.469 ↑ 1.0 1,561 1

Seq Scan on kilo_hotel_papa alpha_two (cost=0.00..29.61 rows=1,561 width=41) (actual time=0.024..0.469 rows=1,561 loops=1)

10. 4.962 8.790 ↓ 6.4 2,306 1

Hash (cost=34.89..34.89 rows=358 width=1,796) (actual time=8.790..8.790 rows=2,306 loops=1)

  • Buckets: 4,096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 845kB
11. 3.313 3.828 ↓ 6.4 2,306 1

Hash Right Join (cost=3.56..34.89 rows=358 width=1,796) (actual time=0.270..3.828 rows=2,306 loops=1)

  • Hash Cond: (foxtrot_mike.india_sierra = romeo.quebec)
12. 0.320 0.320 ↑ 1.0 1,073 1

Seq Scan on oscar_alpha foxtrot_mike (cost=0.00..23.73 rows=1,073 width=61) (actual time=0.013..0.320 rows=1,073 loops=1)

13. 0.040 0.195 ↓ 6.7 20 1

Hash (cost=3.52..3.52 rows=3 width=1,735) (actual time=0.195..0.195 rows=20 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
14. 0.032 0.155 ↓ 6.7 20 1

Hash Left Join (cost=2.38..3.52 rows=3 width=1,735) (actual time=0.101..0.155 rows=20 loops=1)

  • Hash Cond: (lima_four.bravo = alpha_seven.quebec)
15. 0.043 0.101 ↓ 6.7 20 1

Hash Right Join (cost=1.31..2.45 rows=3 width=893) (actual time=0.069..0.101 rows=20 loops=1)

  • Hash Cond: (romeo.quebec = lima_four.india_sierra)
16. 0.009 0.009 ↑ 1.0 9 1

Seq Scan on zulu_oscar romeo (cost=0.00..1.09 rows=9 width=804) (actual time=0.006..0.009 rows=9 loops=1)

17. 0.013 0.049 ↓ 6.7 20 1

Hash (cost=1.27..1.27 rows=3 width=89) (actual time=0.049..0.049 rows=20 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
18. 0.036 0.036 ↓ 6.7 20 1

Seq Scan on yankee_hotel lima_four (cost=0.00..1.27 rows=3 width=89) (actual time=0.025..0.036 rows=20 loops=1)

  • Filter: (bravo = ANY ('seven'::uuid[]))
19. 0.009 0.022 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=842) (actual time=0.022..0.022 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
20. 0.013 0.013 ↑ 1.0 3 1

Seq Scan on foxtrot_xray alpha_seven (cost=0.00..1.03 rows=3 width=842) (actual time=0.010..0.013 rows=3 loops=1)

21. 0.045 0.189 ↑ 1.0 38 1

Hash (cost=4.16..4.16 rows=38 width=1,210) (actual time=0.189..0.189 rows=38 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 17kB
22. 0.039 0.144 ↑ 1.0 38 1

Hash Left Join (cost=2.54..4.16 rows=38 width=1,210) (actual time=0.076..0.144 rows=38 loops=1)

  • Hash Cond: (golf.zulu_lima = yankee_bravo.quebec)
23. 0.046 0.082 ↑ 1.0 38 1

Hash Left Join (cost=1.29..2.78 rows=38 width=140) (actual time=0.040..0.082 rows=38 loops=1)

  • Hash Cond: (juliet.papa_india_india = golf.quebec)
24. 0.019 0.019 ↑ 1.0 38 1

Seq Scan on yankee_two juliet (cost=0.00..1.38 rows=38 width=70) (actual time=0.011..0.019 rows=38 loops=1)

25. 0.007 0.017 ↑ 1.0 13 1

Hash (cost=1.13..1.13 rows=13 width=70) (actual time=0.017..0.017 rows=13 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
26. 0.010 0.010 ↑ 1.0 13 1

Seq Scan on lima_juliet golf (cost=0.00..1.13 rows=13 width=70) (actual time=0.006..0.010 rows=13 loops=1)

27. 0.010 0.023 ↑ 1.0 11 1

Hash (cost=1.11..1.11 rows=11 width=1,070) (actual time=0.023..0.023 rows=11 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
28. 0.013 0.013 ↑ 1.0 11 1

Seq Scan on charlie yankee_bravo (cost=0.00..1.11 rows=11 width=1,070) (actual time=0.009..0.013 rows=11 loops=1)

29. 0.024 0.094 ↑ 1.0 13 1

Hash (cost=2.42..2.42 rows=13 width=1,140) (actual time=0.094..0.094 rows=13 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
30. 0.021 0.070 ↑ 1.0 13 1

Hash Left Join (cost=1.25..2.42 rows=13 width=1,140) (actual time=0.056..0.070 rows=13 loops=1)

  • Hash Cond: (two.zulu_lima = kilo_hotel_tango.quebec)
31. 0.011 0.011 ↑ 1.0 13 1

Seq Scan on lima_juliet two (cost=0.00..1.13 rows=13 width=70) (actual time=0.008..0.011 rows=13 loops=1)

32. 0.026 0.038 ↑ 1.0 11 1

Hash (cost=1.11..1.11 rows=11 width=1,070) (actual time=0.038..0.038 rows=11 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
33. 0.012 0.012 ↑ 1.0 11 1

Seq Scan on charlie kilo_hotel_tango (cost=0.00..1.11 rows=11 width=1,070) (actual time=0.008..0.012 rows=11 loops=1)

34. 0.015 0.023 ↑ 1.0 13 1

Hash (cost=1.13..1.13 rows=13 width=70) (actual time=0.023..0.023 rows=13 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
35. 0.008 0.008 ↑ 1.0 13 1

Seq Scan on lima_juliet oscar_mike (cost=0.00..1.13 rows=13 width=70) (actual time=0.005..0.008 rows=13 loops=1)

36. 0.021 0.032 ↑ 1.0 11 1

Hash (cost=1.11..1.11 rows=11 width=1,070) (actual time=0.032..0.032 rows=11 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
37. 0.011 0.011 ↑ 1.0 11 1

Seq Scan on charlie papa_india_alpha (cost=0.00..1.11 rows=11 width=1,070) (actual time=0.008..0.011 rows=11 loops=1)

Planning time : 5.847 ms
Execution time : 203.005 ms