explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GmBP

Settings
# exclusive inclusive rows x rows loops node
1. 468.958 14,579.050 ↓ 21.0 21 1

Unique (cost=25,116.520..25,116.680 rows=1 width=4,545) (actual time=6,388.871..14,579.050 rows=21 loops=1)

2. 13,426.349 14,110.092 ↓ 262,284.0 262,284 1

Sort (cost=25,116.520..25,116.530 rows=1 width=4,545) (actual time=6,388.864..14,110.092 rows=262,284 loops=1)

  • Sort Key: yankee_delta0kilo_oscar.november_lima, yankee_delta0kilo_oscar.quebec_seven, tango13kilo_oscar.quebec_seven, yankee_delta0kilo_oscar.mike_kilo, tango13kilo_oscar.yankee_two, tango13kilo_oscar.alpha_four, tango13kilo_oscar.delta, tango13kilo_oscar.uniform_lima, tango13kilo_oscar.kilo_kilo, papa_kilo
  • Sort Method: external merge Disk: 236264kB
3. 171.483 683.743 ↓ 262,284.0 262,284 1

Nested Loop Left Join (cost=20,112.500..25,116.510 rows=1 width=4,545) (actual time=238.629..683.743 rows=262,284 loops=1)

4. 14.536 413.500 ↓ 16,460.0 16,460 1

Nested Loop Left Join (cost=20,112.210..25,115.720 rows=1 width=51) (actual time=238.614..413.500 rows=16,460 loops=1)

  • Filter: (((mike_mike8kilo_oscar.november_lima)::text ~~* 'echo'::text) OR ((alpha_romeo12kilo_oscar.six)::text ~~* 'echo'::text))
  • Rows Removed by Filter: 568
5. 0.408 343.686 ↓ 1.8 333 1

Nested Loop Left Join (cost=20,111.080..24,206.210 rows=189 width=65) (actual time=238.513..343.686 rows=333 loops=1)

6. 0.182 342.945 ↓ 1.8 333 1

Nested Loop Left Join (cost=20,110.800..24,149.230 rows=189 width=59) (actual time=238.484..342.945 rows=333 loops=1)

7. 88.530 341.953 ↑ 3.2 54 1

Hash Left Join (cost=20,110.510..24,009.860 rows=175 width=51) (actual time=238.464..341.953 rows=54 loops=1)

  • Hash Cond: (papa_three5kilo_oscar.seven_yankee = alpha_romeo6kilo_oscar.quebec_seven)
  • Filter: (((india2kilo_oscar.november_lima)::text ~~* 'zulu_tango'::text) OR ((alpha_romeo6kilo_oscar.six)::text ~~* 'zulu_tango'::text))
  • Rows Removed by Filter: 57030
8. 30.474 205.236 ↑ 1.8 57,084 1

Hash Right Join (cost=16,737.970..20,362.020 rows=104,866 width=75) (actual time=165.928..205.236 rows=57,084 loops=1)

  • Hash Cond: (papa_three5kilo_oscar.three = india4kilo_oscar.quebec_seven)
9. 9.089 9.089 ↑ 1.3 98,610 1

Seq Scan on juliet_kilo alpha_mike (cost=0.000..2,095.560 rows=127,956 width=16) (actual time=0.014..9.089 rows=98,610 loops=1)

10. 13.514 165.673 ↓ 1.3 40,390 1

Hash (cost=16,362.550..16,362.550 rows=30,033 width=75) (actual time=165.673..165.673 rows=40,390 loops=1)

  • Buckets: 65536 (originally 32768) Batches: 1 (originally 1) Memory Usage: 4589kB
11. 11.486 152.159 ↓ 1.3 40,390 1

Hash Right Join (cost=9,493.070..16,362.550 rows=30,033 width=75) (actual time=110.937..152.159 rows=40,390 loops=1)

  • Hash Cond: (tango1kilo_oscar.uniform_uniform = yankee_delta0kilo_oscar.quebec_seven)
12. 21.926 38.771 ↓ 1.0 27,898 1

Hash Left Join (cost=814.600..7,282.660 rows=27,806 width=24) (actual time=8.875..38.771 rows=27,898 loops=1)

  • Hash Cond: (tango1kilo_oscar.victor = india2kilo_oscar.quebec_seven)
13. 8.151 8.151 ↓ 1.0 27,898 1

Seq Scan on lima_golf papa_juliet (cost=0.000..6,395.060 rows=27,806 width=16) (actual time=0.006..8.151 rows=27,898 loops=1)

14. 4.820 8.694 ↓ 1.0 23,183 1

Hash (cost=524.820..524.820 rows=23,182 width=24) (actual time=8.694..8.694 rows=23,183 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1533kB
15. 3.874 3.874 ↓ 1.0 23,183 1

Seq Scan on lima_alpha november_victor (cost=0.000..524.820 rows=23,182 width=24) (actual time=0.007..3.874 rows=23,183 loops=1)

16. 8.093 101.902 ↑ 1.0 27,590 1

Hash (cost=8,330.900..8,330.900 rows=27,806 width=59) (actual time=101.902..101.902 rows=27,590 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 2606kB
17. 7.114 93.809 ↑ 1.0 27,590 1

Hash Left Join (cost=1,789.840..8,330.900 rows=27,806 width=59) (actual time=24.805..93.809 rows=27,590 loops=1)

  • Hash Cond: (tango3kilo_oscar.victor = india4kilo_oscar.quebec_seven)
18. 28.896 76.994 ↑ 1.0 27,590 1

Hash Right Join (cost=975.240..7,443.300 rows=27,806 width=59) (actual time=14.928..76.994 rows=27,590 loops=1)

  • Hash Cond: (tango3kilo_oscar.uniform_uniform = yankee_delta0kilo_oscar.quebec_seven)
19. 33.346 33.346 ↓ 1.0 27,898 1

Seq Scan on lima_golf bravo_romeo (cost=0.000..6,395.060 rows=27,806 width=16) (actual time=0.015..33.346 rows=27,898 loops=1)

20. 5.875 14.752 ↑ 1.0 25,137 1

Hash (cost=653.440..653.440 rows=25,744 width=51) (actual time=14.752..14.752 rows=25,137 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 2134kB
21. 8.877 8.877 ↑ 1.0 25,137 1

Seq Scan on juliet_two alpha_lima (cost=0.000..653.440 rows=25,744 width=51) (actual time=0.025..8.877 rows=25,137 loops=1)

22. 3.643 9.701 ↓ 1.0 23,183 1

Hash (cost=524.820..524.820 rows=23,182 width=8) (actual time=9.701..9.701 rows=23,183 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1162kB
23. 6.058 6.058 ↓ 1.0 23,183 1

Seq Scan on lima_alpha whiskey_alpha (cost=0.000..524.820 rows=23,182 width=8) (actual time=0.020..6.058 rows=23,183 loops=1)

24. 24.701 48.187 ↑ 1.0 110,144 1

Hash (cost=1,973.910..1,973.910 rows=111,891 width=26) (actual time=48.187..48.187 rows=110,144 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 7353kB
25. 23.486 23.486 ↑ 1.0 110,144 1

Seq Scan on yankee_victor seven_mike (cost=0.000..1,973.910 rows=111,891 width=26) (actual time=0.021..23.486 rows=110,144 loops=1)

26. 0.810 0.810 ↓ 6.0 6 54

Index Scan using foxtrot on lima_golf quebec_whiskey (cost=0.290..0.790 rows=1 width=16) (actual time=0.012..0.015 rows=6 loops=54)

  • Index Cond: (yankee_delta0kilo_oscar.quebec_seven = uniform_uniform)
27. 0.333 0.333 ↑ 1.0 1 333

Index Scan using seven_victor on bravo_whiskey two (cost=0.280..0.300 rows=1 width=22) (actual time=0.001..0.001 rows=1 loops=333)

  • Index Cond: (tango7kilo_oscar.hotel = quebec_seven)
28. 0.000 55.278 ↓ 51.0 51 333

Nested Loop Left Join (cost=1.130..4.800 rows=1 width=26) (actual time=0.009..0.166 rows=51 loops=333)

29. 3.378 22.311 ↓ 51.0 51 333

Nested Loop Left Join (cost=0.710..1.320 rows=1 width=16) (actual time=0.005..0.067 rows=51 loops=333)

30. 4.020 10.323 ↓ 13.0 13 333

Nested Loop Left Join (cost=0.570..1.090 rows=1 width=16) (actual time=0.004..0.031 rows=13 loops=333)

31. 1.998 1.998 ↓ 13.0 13 333

Index Scan using foxtrot on lima_golf november_four (cost=0.290..0.790 rows=1 width=16) (actual time=0.001..0.006 rows=13 loops=333)

  • Index Cond: (yankee_delta0kilo_oscar.quebec_seven = uniform_uniform)
32. 4.305 4.305 ↑ 1.0 1 4,305

Index Only Scan using seven_victor on bravo_whiskey four_juliet (cost=0.280..0.300 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=4,305)

  • Index Cond: (quebec_seven = tango9kilo_oscar.hotel)
  • Heap Fetches: 4305
33. 8.610 8.610 ↓ 1.3 4 4,305

Index Scan using alpha_uniform on oscar four_victor (cost=0.150..0.200 rows=3 width=16) (actual time=0.001..0.002 rows=4 loops=4,305)

  • Index Cond: (mike_mike10kilo_oscar.quebec_seven = whiskey_victor)
34. 34.056 34.056 ↑ 1.0 1 17,028

Index Scan using seven_zulu on yankee_victor zulu_juliet (cost=0.420..3.480 rows=1 width=26) (actual time=0.002..0.002 rows=1 loops=17,028)

  • Index Cond: (papa_three11kilo_oscar.seven_yankee = quebec_seven)
35. 98.760 98.760 ↓ 16.0 16 16,460

Index Scan using foxtrot on lima_golf kilo_mike (cost=0.290..0.790 rows=1 width=4,486) (actual time=0.001..0.006 rows=16 loops=16,460)

  • Index Cond: (yankee_delta0kilo_oscar.quebec_seven = uniform_uniform)
Planning time : 4.630 ms
Execution time : 14,637.050 ms