explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qcmn

Settings
# exclusive inclusive rows x rows loops node
1. 2.878 74.431 ↓ 1.5 3,247 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Filter: foxtrot
  • Buffers: shared hit=418
15. 0.151 0.282 ↑ 1.0 968 1

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

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

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

  • Buffers: shared hit=7
17. 0.217 0.333 ↑ 1.0 544 1

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

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

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

  • Buffers: shared hit=5
19. 0.028 0.064 ↑ 1.0 7 1

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

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

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

  • Buffers: shared hit=1
21. 0.014 0.067 ↓ 1.1 11 1

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

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

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

  • Buffers: shared hit=1
23. 0.054 0.062 ↑ 1.0 3 1

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

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

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

  • Buffers: shared hit=1
25. 0.039 0.050 ↑ 1.0 16 1

Hash (cost=1.160..1.160 rows=16 width=20) (actual time=0.050..0.050 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.009..0.011 rows=16 loops=1)

  • Buffers: shared hit=1
27. 0.659 1.479 ↓ 1.5 3,247 1

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

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

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

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

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

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

  • Hash Cond: (yankee_seven.seven_echo = november.seven_echo)
  • Buffers: shared hit=2
31. 0.009 0.009 ↑ 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.009 rows=10 loops=1)

  • Buffers: shared hit=1
32. 0.019 0.030 ↑ 1.0 15 1

Hash (cost=1.150..1.150 rows=15 width=14) (actual time=0.030..0.030 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.008..0.011 rows=15 loops=1)

  • Buffers: shared hit=1
34. 0.009 0.020 ↑ 1.0 15 1

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

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

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

  • Buffers: shared hit=1
36. 0.056 0.091 ↑ 1.0 227 1

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

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

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

  • Buffers: shared hit=3