explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D8ho

Settings
# exclusive inclusive rows x rows loops node
1. 3.119 74.567 ↓ 1.5 3,247 1

Hash Left Join (cost=1,273.650..2,723.710 rows=2,146 width=371) (actual time=22.850..74.567 rows=3,247 loops=1)

  • Hash Cond: (uniform_charlie.oscar = romeo_two.three)
  • Buffers: shared hit=925
2. 0.942 71.346 ↓ 1.5 3,247 1

Hash Left Join (cost=1,265.540..2,650.860 rows=2,146 width=290) (actual time=22.716..71.346 rows=3,247 loops=1)

  • Hash Cond: (xray_foxtrot.charlie_mike = yankee_charlie.charlie_mike)
  • Buffers: shared hit=922
3. 0.636 70.379 ↓ 1.5 3,247 1

Hash Left Join (cost=1,264.200..2,642.300 rows=2,146 width=272) (actual time=22.668..70.379 rows=3,247 loops=1)

  • Hash Cond: (xray_foxtrot.sierra = yankee_seven.sierra)
  • Buffers: shared hit=921
4. 2.813 69.671 ↓ 1.5 3,247 1

Hash Join (cost=1,261.600..2,631.620 rows=2,146 width=262) (actual time=22.584..69.671 rows=3,247 loops=1)

  • Hash Cond: (uniform_charlie.seven_mike = romeo_three.seven_mike)
  • Buffers: shared hit=919
5. 5.833 64.245 ↑ 1.0 25,592 1

Hash Left Join (cost=1,043.750..2,346.570 rows=25,592 width=262) (actual time=19.855..64.245 rows=25,592 loops=1)

  • Hash Cond: (papa_juliet.romeo_seven = echo_kilo.romeo_seven)
  • Buffers: shared hit=828
6. 5.521 58.391 ↑ 1.0 25,592 1

Hash Left Join (cost=1,042.390..2,260.260 rows=25,592 width=250) (actual time=19.816..58.391 rows=25,592 loops=1)

  • Hash Cond: (uniform_charlie.india = quebec_india.india)
  • Buffers: shared hit=827
7. 6.023 52.853 ↑ 1.0 25,592 1

Hash Left Join (cost=1,041.320..2,097.100 rows=25,592 width=243) (actual time=19.785..52.853 rows=25,592 loops=1)

  • Hash Cond: (uniform_charlie.seven_xray = two.seven_xray)
  • Buffers: shared hit=826
8. 5.148 46.804 ↑ 1.0 25,592 1

Hash Left Join (cost=1,040.100..2,000.230 rows=25,592 width=201) (actual time=19.746..46.804 rows=25,592 loops=1)

  • Hash Cond: (papa_juliet.uniform_bravo = tango_golf.uniform_bravo)
  • Buffers: shared hit=825
9. 4.813 41.636 ↑ 1.0 25,592 1

Hash Left Join (cost=1,038.940..1,891.220 rows=25,592 width=189) (actual time=19.715..41.636 rows=25,592 loops=1)

  • Hash Cond: (papa_juliet.whiskey = xray_hotel.whiskey)
  • Buffers: shared hit=824
10. 5.441 36.628 ↑ 1.0 25,592 1

Hash Left Join (cost=1,021.700..1,806.280 rows=25,592 width=163) (actual time=19.501..36.628 rows=25,592 loops=1)

  • Hash Cond: (uniform_charlie.delta = papa_juliet.delta)
  • Buffers: shared hit=819
11. 8.317 30.899 ↑ 1.0 25,592 1

Hash Right Join (cost=992.920..1,710.030 rows=25,592 width=155) (actual time=19.190..30.899 rows=25,592 loops=1)

  • Hash Cond: (xray_foxtrot.seven_mike = uniform_charlie.seven_mike)
  • Buffers: shared hit=812
12. 3.698 3.698 ↑ 1.0 25,592 1

Seq Scan on papa_sierra xray_foxtrot (cost=0.000..649.920 rows=25,592 width=68) (actual time=0.022..3.698 rows=25,592 loops=1)

  • Filter: foxtrot
  • Buffers: shared hit=394
13. 10.374 18.884 ↓ 1.0 25,592 1

Hash (cost=673.520..673.520 rows=25,552 width=91) (actual time=18.884..18.884 rows=25,592 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 3256kB
  • Buffers: shared hit=418
14. 8.510 8.510 ↓ 1.0 25,592 1

Seq Scan on papa_six uniform_charlie (cost=0.000..673.520 rows=25,552 width=91) (actual time=0.044..8.510 rows=25,592 loops=1)

  • Filter: foxtrot
  • Buffers: shared hit=418
15. 0.163 0.288 ↑ 1.0 968 1

Hash (cost=16.680..16.680 rows=968 width=16) (actual time=0.288..0.288 rows=968 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 54kB
  • Buffers: shared hit=7
16. 0.125 0.125 ↑ 1.0 968 1

Seq Scan on kilo papa_juliet (cost=0.000..16.680 rows=968 width=16) (actual time=0.012..0.125 rows=968 loops=1)

  • Buffers: shared hit=7
17. 0.129 0.195 ↑ 1.0 544 1

Hash (cost=10.440..10.440 rows=544 width=34) (actual time=0.195..0.195 rows=544 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 45kB
  • Buffers: shared hit=5
18. 0.066 0.066 ↑ 1.0 544 1

Seq Scan on echo_delta xray_hotel (cost=0.000..10.440 rows=544 width=34) (actual time=0.012..0.066 rows=544 loops=1)

  • Buffers: shared hit=5
19. 0.009 0.020 ↑ 1.0 7 1

Hash (cost=1.070..1.070 rows=7 width=20) (actual time=0.020..0.020 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
20. 0.011 0.011 ↑ 1.0 7 1

Seq Scan on romeo_kilo tango_golf (cost=0.000..1.070 rows=7 width=20) (actual time=0.011..0.011 rows=7 loops=1)

  • Buffers: shared hit=1
21. 0.012 0.026 ↓ 1.1 11 1

Hash (cost=1.100..1.100 rows=10 width=50) (actual time=0.026..0.026 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
22. 0.014 0.014 ↓ 1.1 11 1

Seq Scan on seven_zulu two (cost=0.000..1.100 rows=10 width=50) (actual time=0.013..0.014 rows=11 loops=1)

  • Buffers: shared hit=1
23. 0.008 0.017 ↑ 1.0 3 1

Hash (cost=1.030..1.030 rows=3 width=11) (actual time=0.017..0.017 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
24. 0.009 0.009 ↑ 1.0 3 1

Seq Scan on six quebec_india (cost=0.000..1.030 rows=3 width=11) (actual time=0.008..0.009 rows=3 loops=1)

  • Buffers: shared hit=1
25. 0.010 0.021 ↑ 1.0 16 1

Hash (cost=1.160..1.160 rows=16 width=20) (actual time=0.021..0.021 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
26. 0.011 0.011 ↑ 1.0 16 1

Seq Scan on charlie_alpha echo_kilo (cost=0.000..1.160 rows=16 width=20) (actual time=0.010..0.011 rows=16 loops=1)

  • Buffers: shared hit=1
27. 1.062 2.613 ↓ 1.5 3,247 1

Hash (cost=191.070..191.070 rows=2,143 width=4) (actual time=2.613..2.613 rows=3,247 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 147kB
  • Buffers: shared hit=91
28. 1.551 1.551 ↓ 1.5 3,247 1

Index Scan using tango_yankee on papa_six romeo_three (cost=0.290..191.070 rows=2,143 width=4) (actual time=0.033..1.551 rows=3,247 loops=1)

  • Index Cond: (five_papa = 1)
  • Buffers: shared hit=91
29. 0.013 0.072 ↑ 1.0 10 1

Hash (cost=2.470..2.470 rows=10 width=14) (actual time=0.072..0.072 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
30. 0.023 0.059 ↑ 1.0 10 1

Hash Left Join (cost=1.340..2.470 rows=10 width=14) (actual time=0.057..0.059 rows=10 loops=1)

  • Hash Cond: (yankee_seven.seven_echo = november.seven_echo)
  • Buffers: shared hit=2
31. 0.011 0.011 ↑ 1.0 10 1

Seq Scan on quebec_zulu yankee_seven (cost=0.000..1.100 rows=10 width=8) (actual time=0.009..0.011 rows=10 loops=1)

  • Buffers: shared hit=1
32. 0.014 0.025 ↑ 1.0 15 1

Hash (cost=1.150..1.150 rows=15 width=14) (actual time=0.025..0.025 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
33. 0.011 0.011 ↑ 1.0 15 1

Seq Scan on golf november (cost=0.000..1.150 rows=15 width=14) (actual time=0.009..0.011 rows=15 loops=1)

  • Buffers: shared hit=1
34. 0.011 0.025 ↑ 1.0 15 1

Hash (cost=1.150..1.150 rows=15 width=22) (actual time=0.025..0.025 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
35. 0.014 0.014 ↑ 1.0 15 1

Seq Scan on five_quebec yankee_charlie (cost=0.000..1.150 rows=15 width=22) (actual time=0.010..0.014 rows=15 loops=1)

  • Buffers: shared hit=1
36. 0.061 0.102 ↑ 1.0 227 1

Hash (cost=5.270..5.270 rows=227 width=20) (actual time=0.102..0.102 rows=227 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
  • Buffers: shared hit=3
37. 0.041 0.041 ↑ 1.0 227 1

Seq Scan on charlie_delta romeo_two (cost=0.000..5.270 rows=227 width=20) (actual time=0.011..0.041 rows=227 loops=1)

  • Buffers: shared hit=3