explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tmin

Settings
# exclusive inclusive rows x rows loops node
1. 2.933 172.281 ↓ 1.5 3,247 1

Hash Join (cost=9,779.920..10,167.010 rows=2,143 width=371) (actual time=161.292..172.281 rows=3,247 loops=1)

  • Hash Cond: (uniform_charlie.seven_mike = romeo_three.seven_mike)
  • Buffers: shared hit=925, temp read=909 written=910
2. 53.820 164.625 ↑ 1.0 25,592 1

Sort (cost=9,562.060..9,626.040 rows=25,592 width=371) (actual time=156.375..164.625 rows=25,592 loops=1)

  • Sort Key: uniform_charlie.mike DESC
  • Sort Method: external merge Disk: 7272kB
  • Buffers: shared hit=834, temp read=909 written=910
3. 23.449 110.805 ↑ 1.0 25,592 1

Hash Left Join (cost=1,055.790..3,313.290 rows=25,592 width=371) (actual time=25.264..110.805 rows=25,592 loops=1)

  • Hash Cond: (uniform_charlie.oscar = romeo_two.three)
  • Buffers: shared hit=834
4. 6.441 87.242 ↑ 1.0 25,592 1

Hash Left Join (cost=1,047.690..2,532.970 rows=25,592 width=290) (actual time=25.114..87.242 rows=25,592 loops=1)

  • Hash Cond: (xray_foxtrot.charlie_mike = yankee_charlie.charlie_mike)
  • Buffers: shared hit=831
5. 5.180 80.765 ↑ 1.0 25,592 1

Hash Left Join (cost=1,046.350..2,445.470 rows=25,592 width=272) (actual time=25.050..80.765 rows=25,592 loops=1)

  • Hash Cond: (xray_foxtrot.sierra = yankee_seven.sierra)
  • Buffers: shared hit=830
6. 6.115 75.492 ↑ 1.0 25,592 1

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

  • Hash Cond: (papa_juliet.romeo_seven = echo_kilo.romeo_seven)
  • Buffers: shared hit=828
7. 6.160 69.344 ↑ 1.0 25,592 1

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

  • Hash Cond: (uniform_charlie.india = quebec_india.india)
  • Buffers: shared hit=827
8. 6.884 63.155 ↑ 1.0 25,592 1

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

  • Hash Cond: (uniform_charlie.seven_xray = two.seven_xray)
  • Buffers: shared hit=826
9. 5.907 56.238 ↑ 1.0 25,592 1

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

  • Hash Cond: (papa_juliet.uniform_bravo = tango_golf.uniform_bravo)
  • Buffers: shared hit=825
10. 5.599 50.298 ↑ 1.0 25,592 1

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

  • Hash Cond: (papa_juliet.whiskey = xray_hotel.whiskey)
  • Buffers: shared hit=824
11. 5.776 44.449 ↑ 1.0 25,592 1

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

  • Hash Cond: (uniform_charlie.delta = papa_juliet.delta)
  • Buffers: shared hit=819
12. 10.935 38.330 ↑ 1.0 25,592 1

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

  • Hash Cond: (xray_foxtrot.seven_mike = uniform_charlie.seven_mike)
  • Buffers: shared hit=812
13. 4.587 4.587 ↑ 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.026..4.587 rows=25,592 loops=1)

  • Filter: foxtrot
  • Buffers: shared hit=394
14. 13.653 22.808 ↓ 1.0 25,592 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 3256kB
  • Buffers: shared hit=418
15. 9.155 9.155 ↓ 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.092..9.155 rows=25,592 loops=1)

  • Filter: foxtrot
  • Buffers: shared hit=418
16. 0.216 0.343 ↑ 1.0 968 1

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

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

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

  • Buffers: shared hit=7
18. 0.171 0.250 ↑ 1.0 544 1

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

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

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

  • Buffers: shared hit=5
20. 0.019 0.033 ↑ 1.0 7 1

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

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

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

  • Buffers: shared hit=1
22. 0.020 0.033 ↓ 1.1 11 1

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

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

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

  • Buffers: shared hit=1
24. 0.018 0.029 ↑ 1.0 3 1

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

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

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

  • Buffers: shared hit=1
26. 0.020 0.033 ↑ 1.0 16 1

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

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

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

  • Buffers: shared hit=1
28. 0.019 0.093 ↑ 1.0 10 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
29. 0.031 0.074 ↑ 1.0 10 1

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

  • Hash Cond: (yankee_seven.seven_echo = november.seven_echo)
  • Buffers: shared hit=2
30. 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.010..0.011 rows=10 loops=1)

  • Buffers: shared hit=1
31. 0.020 0.032 ↑ 1.0 15 1

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

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

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

  • Buffers: shared hit=1
33. 0.021 0.036 ↑ 1.0 15 1

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

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

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

  • Buffers: shared hit=1
35. 0.071 0.114 ↑ 1.0 227 1

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

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

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

  • Buffers: shared hit=3
37. 2.027 4.723 ↓ 1.5 3,247 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 147kB
  • Buffers: shared hit=91
38. 2.696 2.696 ↓ 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.056..2.696 rows=3,247 loops=1)

  • Index Cond: (five_papa = 1)
  • Buffers: shared hit=91