explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1aAn

Settings
# exclusive inclusive rows x rows loops node
1. 52.133 1,069.360 ↑ 2.6 7,766 1

Gather (cost=263,460.590..304,842.750 rows=20,013 width=2,333) (actual time=874.272..1,069.360 rows=7,766 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 3.947 1,017.227 ↑ 3.0 3,883 2 / 2

Hash Left Join (cost=262,460.590..301,841.450 rows=11,772 width=2,333) (actual time=870.296..1,017.227 rows=3,883 loops=2)

  • Hash Cond: (lima_hotel.quebec_seven = quebec_november.quebec_seven)
3. 5.040 1,013.275 ↑ 3.0 3,883 2 / 2

Parallel Hash Left Join (cost=262,408.970..301,729.500 rows=11,772 width=1,521) (actual time=870.274..1,013.275 rows=3,883 loops=2)

  • Hash Cond: (lima_hotel.quebec_seven = victor_kilo.quebec_seven)
4. 3.070 915.608 ↑ 3.0 3,883 2 / 2

Hash Left Join (cost=257,621.160..296,910.790 rows=11,772 width=1,513) (actual time=776.790..915.608 rows=3,883 loops=2)

  • Hash Cond: (xray_lima.echo_golf = tango_foxtrot.quebec_seven)
  • Filter: ((xray_lima.echo_golf five NULL) OR (xray_lima.quebec_seven = tango_foxtrot.foxtrot_tango))
5. 3.049 912.232 ↑ 3.0 3,883 2 / 2

Hash Left Join (cost=257,607.930..296,866.650 rows=11,776 width=1,521) (actual time=776.471..912.232 rows=3,883 loops=2)

  • Hash Cond: (xray_lima.hotel = seven.quebec_seven)
6. 4.067 909.169 ↑ 3.0 3,883 2 / 2

Nested Loop Left Join (cost=257,606.800..296,812.770 rows=11,776 width=1,013) (actual time=776.444..909.169 rows=3,883 loops=2)

7. 3.248 897.336 ↑ 3.0 3,883 2 / 2

Hash Left Join (cost=257,606.370..290,954.090 rows=11,776 width=1,013) (actual time=776.426..897.336 rows=3,883 loops=2)

  • Hash Cond: (xray_lima.foxtrot_papa = victor_romeo.quebec_seven)
8. 3.361 892.255 ↑ 3.0 3,883 2 / 2

Hash Join (cost=257,395.240..290,711.970 rows=11,776 width=1,003) (actual time=774.575..892.255 rows=3,883 loops=2)

  • Hash Cond: (xray_lima.bravo = echo_whiskey.quebec_seven)
9. 5.912 888.803 ↑ 3.0 3,883 2 / 2

Nested Loop (cost=257,305.790..290,460.600 rows=11,776 width=387) (actual time=774.464..888.803 rows=3,883 loops=2)

10. 67.948 875.125 ↑ 3.0 3,883 2 / 2

Parallel Hash Join (cost=257,305.360..260,601.470 rows=11,776 width=196) (actual time=774.433..875.125 rows=3,883 loops=2)

  • Hash Cond: (xray_five.quebec_seven = lima_hotel.quebec_seven)
11. 33.849 33.849 ↑ 1.2 128,400 2 / 2

Parallel Seq Scan on three xray_five (cost=0.000..2,899.580 rows=151,058 width=8) (actual time=0.009..33.849 rows=128,400 loops=2)

12. 231.063 773.328 ↓ 2.0 248,777 2 / 2

Parallel Hash (cost=255,754.030..255,754.030 rows=124,106 width=196) (actual time=773.328..773.328 rows=248,777 loops=2)

  • Buckets: 524,288 Batches: 1 Memory Usage: 117,024kB
13. 476.530 542.265 ↓ 2.0 248,777 2 / 2

Parallel Bitmap Heap Scan on lima_four lima_hotel (cost=9,295.710..255,754.030 rows=124,106 width=196) (actual time=178.235..542.265 rows=248,777 loops=2)

  • Recheck Cond: (foxtrot_seven >= 'romeo'::date)
  • Heap Blocks: exact=93,643
14. 65.734 65.734 ↓ 1.0 497,554 1 / 2

Bitmap Index Scan on six (cost=0.000..9,171.610 rows=496,423 width=0) (actual time=131.469..131.469 rows=497,554 loops=1)

  • Index Cond: (foxtrot_seven >= 'romeo'::date)
15. 7.766 7.766 ↑ 1.0 1 7,766 / 2

Index Scan using echo_november on sierra xray_lima (cost=0.430..2.540 rows=1 width=199) (actual time=0.002..0.002 rows=1 loops=7,766)

  • Index Cond: (quebec_seven = lima_hotel.charlie)
16. 0.012 0.091 ↑ 1.0 14 2 / 2

Hash (cost=89.280..89.280 rows=14 width=632) (actual time=0.090..0.091 rows=14 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
17. 0.023 0.079 ↑ 1.0 14 2 / 2

Nested Loop Left Join (cost=0.280..89.280 rows=14 width=632) (actual time=0.030..0.079 rows=14 loops=2)

18. 0.014 0.014 ↑ 1.0 14 2 / 2

Seq Scan on whiskey echo_whiskey (cost=0.000..1.140 rows=14 width=622) (actual time=0.010..0.014 rows=14 loops=2)

19. 0.042 0.042 ↑ 1.0 1 28 / 2

Index Scan using foxtrot_quebec on echo_six papa (cost=0.280..6.290 rows=1 width=26) (actual time=0.003..0.003 rows=1 loops=28)

  • Index Cond: (quebec_seven = echo_whiskey.alpha_sierra)
20. 0.690 1.833 ↑ 1.0 1,650 2 / 2

Hash (cost=190.500..190.500 rows=1,650 width=26) (actual time=1.833..1.833 rows=1,650 loops=2)

  • Buckets: 2,048 Batches: 1 Memory Usage: 119kB
21. 1.143 1.143 ↑ 1.0 1,650 2 / 2

Seq Scan on echo_six victor_romeo (cost=0.000..190.500 rows=1,650 width=26) (actual time=0.013..1.143 rows=1,650 loops=2)

22. 7.766 7.766 ↑ 1.0 1 7,766 / 2

Index Scan using delta on juliet four (cost=0.430..0.500 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=7,766)

  • Index Cond: (xray_lima.zulu = quebec_seven)
23. 0.005 0.014 ↑ 1.0 6 2 / 2

Hash (cost=1.060..1.060 rows=6 width=524) (actual time=0.014..0.014 rows=6 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
24. 0.009 0.009 ↑ 1.0 6 2 / 2

Seq Scan on alpha_uniform seven (cost=0.000..1.060 rows=6 width=524) (actual time=0.007..0.009 rows=6 loops=2)

25. 0.157 0.306 ↑ 1.0 410 2 / 2

Hash (cost=8.100..8.100 rows=410 width=16) (actual time=0.306..0.306 rows=410 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 28kB
26. 0.149 0.149 ↑ 1.0 410 2 / 2

Seq Scan on victor_november tango_foxtrot (cost=0.000..8.100 rows=410 width=16) (actual time=0.007..0.149 rows=410 loops=2)

27. 51.104 92.627 ↑ 1.2 128,399 2 / 2

Parallel Hash (cost=2,899.580..2,899.580 rows=151,058 width=8) (actual time=92.627..92.627 rows=128,399 loops=2)

  • Buckets: 262,144 Batches: 1 Memory Usage: 12,128kB
28. 41.523 41.523 ↑ 1.2 128,399 2 / 2

Parallel Seq Scan on tango_sierra victor_kilo (cost=0.000..2,899.580 rows=151,058 width=8) (actual time=0.007..41.523 rows=128,399 loops=2)

29. 0.001 0.005 ↓ 0.0 0 2 / 2

Hash (cost=28.500..28.500 rows=1,850 width=8) (actual time=0.005..0.005 rows=0 loops=2)

  • Buckets: 2,048 Batches: 1 Memory Usage: 16kB
30. 0.004 0.004 ↓ 0.0 0 2 / 2

Seq Scan on echo_foxtrot quebec_november (cost=0.000..28.500 rows=1,850 width=8) (actual time=0.004..0.004 rows=0 loops=2)

Planning time : 4.940 ms
Execution time : 1,071.484 ms