explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b3vV : 2

Settings
# exclusive inclusive rows x rows loops node
1. 2.239 1,738.355 ↑ 3.8 6,678 1

Hash Anti Join (cost=30,331.430..218,037.750 rows=25,605 width=4) (actual time=1,016.700..1,738.355 rows=6,678 loops=1)

  • Hash Cond: (kilo.quebec_seven = november_mike.sierra)
2. 1.589 1,736.079 ↑ 3.8 6,678 1

Hash Anti Join (cost=30,310.390..217,693.450 rows=25,606 width=4) (actual time=1,016.652..1,736.079 rows=6,678 loops=1)

  • Hash Cond: (kilo.quebec_seven = november_charlie.sierra)
3. 2.540 1,734.426 ↑ 3.8 6,678 1

Hash Anti Join (cost=30,305.530..217,365.280 rows=25,612 width=4) (actual time=1,016.577..1,734.426 rows=6,678 loops=1)

  • Hash Cond: (kilo.quebec_seven = echo_two.sierra)
4. 2.220 1,646.859 ↑ 3.9 6,678 1

Hash Anti Join (cost=24,837.170..211,523.250 rows=26,204 width=4) (actual time=931.492..1,646.859 rows=6,678 loops=1)

  • Hash Cond: (kilo.quebec_seven = quebec_sierra.sierra)
5. 5.425 1,644.249 ↑ 3.9 6,679 1

Nested Loop Anti Join (cost=24,789.100..211,143.580 rows=26,221 width=4) (actual time=931.085..1,644.249 rows=6,679 loops=1)

6. 42.487 1,625.038 ↑ 4.1 6,893 1

Nested Loop Anti Join (cost=24,788.660..182,635.030 rows=28,353 width=4) (actual time=445.884..1,625.038 rows=6,893 loops=1)

7. 18.869 1,320.175 ↓ 1.7 65,594 1

Hash Anti Join (cost=24,788.240..153,654.870 rows=38,013 width=4) (actual time=445.855..1,320.175 rows=65,594 loops=1)

  • Hash Cond: (kilo.quebec_seven = zulu_tango.sierra)
8. 56.480 1,299.732 ↓ 1.7 65,594 1

Hash Anti Join (cost=24,620.040..152,983.210 rows=38,240 width=4) (actual time=444.267..1,299.732 rows=65,594 loops=1)

  • Hash Cond: (kilo.quebec_seven = echo_victor.sierra)
9. 61.614 1,077.804 ↓ 1.6 65,597 1

Hash Anti Join (cost=12,869.370..138,862.540 rows=42,021 width=4) (actual time=278.672..1,077.804 rows=65,597 loops=1)

  • Hash Cond: (kilo.quebec_seven = tango_golf.sierra)
10. 188.876 844.357 ↑ 1.7 65,609 1

Merge Anti Join (cost=52.000..118,072.800 rows=111,339 width=4) (actual time=48.059..844.357 rows=65,609 loops=1)

  • Merge Cond: (kilo.quebec_seven = five_delta.sierra)
11. 375.190 375.190 ↓ 1.0 561,792 1

Index Only Scan using yankee on tango_whiskey kilo (cost=0.420..75,180.760 rows=552,360 width=4) (actual time=0.033..375.190 rows=561,792 loops=1)

  • Heap Fetches: 354374
12. 280.291 280.291 ↑ 1.0 518,247 1

Index Only Scan using zulu_hotel on echo_five five_delta (cost=0.420..35,560.190 rows=519,566 width=4) (actual time=0.011..280.291 rows=518,247 loops=1)

  • Heap Fetches: 518283
13. 65.477 171.833 ↑ 1.1 325,775 1

Hash (cost=7,052.500..7,052.500 rows=351,350 width=4) (actual time=171.833..171.833 rows=325,775 loops=1)

  • Buckets: 131072 Batches: 8 Memory Usage: 2457kB
14. 106.356 106.356 ↑ 1.1 325,775 1

Seq Scan on india_romeo tango_golf (cost=0.000..7,052.500 rows=351,350 width=4) (actual time=0.022..106.356 rows=325,775 loops=1)

15. 49.354 165.448 ↑ 1.0 229,940 1

Hash (cost=7,949.740..7,949.740 rows=231,674 width=4) (actual time=165.448..165.448 rows=229,940 loops=1)

  • Buckets: 131072 Batches: 4 Memory Usage: 3045kB
16. 116.094 116.094 ↑ 1.0 229,940 1

Seq Scan on four echo_victor (cost=0.000..7,949.740 rows=231,674 width=4) (actual time=0.185..116.094 rows=229,940 loops=1)

17. 0.582 1.574 ↓ 1.1 4,135 1

Hash (cost=119.200..119.200 rows=3,920 width=4) (actual time=1.574..1.574 rows=4,135 loops=1)

  • Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 210kB
18. 0.992 0.992 ↓ 1.1 4,135 1

Seq Scan on six zulu_tango (cost=0.000..119.200 rows=3,920 width=4) (actual time=0.006..0.992 rows=4,135 loops=1)

19. 262.376 262.376 ↑ 4.0 1 65,594

Index Only Scan using two on five_five india_yankee (cost=0.420..1.560 rows=4 width=4) (actual time=0.004..0.004 rows=1 loops=65,594)

  • Index Cond: (sierra = kilo.quebec_seven)
  • Heap Fetches: 58684
20. 13.786 13.786 ↓ 0.0 0 6,893

Index Only Scan using oscar on victor_papa five_two (cost=0.430..193.160 rows=364 width=4) (actual time=0.002..0.002 rows=0 loops=6,893)

  • Index Cond: (sierra = kilo.quebec_seven)
  • Heap Fetches: 214
21. 0.132 0.390 ↓ 1.0 982 1

Hash (cost=35.810..35.810 rows=981 width=4) (actual time=0.390..0.390 rows=982 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 43kB
22. 0.258 0.258 ↓ 1.0 982 1

Seq Scan on echo_uniform quebec_sierra (cost=0.000..35.810 rows=981 width=4) (actual time=0.006..0.258 rows=982 loops=1)

23. 9.305 85.027 ↑ 1.0 35,135 1

Hash (cost=5,025.940..5,025.940 rows=35,394 width=4) (actual time=85.027..85.027 rows=35,135 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 1748kB
24. 75.722 75.722 ↑ 1.0 35,135 1

Seq Scan on victor_golf echo_two (cost=0.000..5,025.940 rows=35,394 width=4) (actual time=0.020..75.722 rows=35,135 loops=1)

25. 0.026 0.064 ↓ 1.0 131 1

Hash (cost=3.270..3.270 rows=127 width=4) (actual time=0.064..0.064 rows=131 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
26. 0.038 0.038 ↓ 1.0 131 1

Seq Scan on tango_four november_charlie (cost=0.000..3.270 rows=127 width=4) (actual time=0.010..0.038 rows=131 loops=1)

27. 0.005 0.037 ↑ 1.3 36 1

Hash (cost=20.460..20.460 rows=46 width=4) (actual time=0.037..0.037 rows=36 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
28. 0.032 0.032 ↑ 1.3 36 1

Seq Scan on charlie november_mike (cost=0.000..20.460 rows=46 width=4) (actual time=0.003..0.032 rows=36 loops=1)

Planning time : 4.099 ms
Execution time : 1,739.219 ms