explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lA4f

Settings
# exclusive inclusive rows x rows loops node
1. 0.031 92,671.757 ↓ 96.0 96 1

Limit (cost=194,746.030..194,746.280 rows=1 width=240) (actual time=92,670.901..92,671.757 rows=96 loops=1)

2. 0.930 92,671.726 ↓ 96.0 96 1

Result (cost=194,746.030..194,746.280 rows=1 width=240) (actual time=92,670.896..92,671.726 rows=96 loops=1)

3. 59.344 92,670.796 ↓ 96.0 96 1

Sort (cost=194,746.030..194,746.030 rows=1 width=425) (actual time=92,670.773..92,670.796 rows=96 loops=1)

  • Sort Key: alpha.zulu_yankee DESC, alpha.india
  • Sort Method: top-N heapsort Memory: 74kB
4. 326.856 92,611.452 ↓ 45,358.0 45,358 1

WindowAgg (cost=56,902.260..194,746.020 rows=1 width=425) (actual time=92,460.579..92,611.452 rows=45,358 loops=1)

5. 64.074 92,284.596 ↓ 45,358.0 45,358 1

Nested Loop (cost=56,902.260..194,745.960 rows=1 width=372) (actual time=521.845..92,284.596 rows=45,358 loops=1)

6. 105.349 91,404.078 ↓ 45,358.0 45,358 1

Nested Loop (cost=56,898.830..194,742.490 rows=1 width=339) (actual time=521.785..91,404.078 rows=45,358 loops=1)

7. 53.129 90,618.359 ↓ 45,358.0 45,358 1

Nested Loop Left Join (cost=56,894.330..194,737.960 rows=1 width=275) (actual time=521.713..90,618.359 rows=45,358 loops=1)

  • Join Filter: false
8. 38,457.383 90,565.230 ↓ 45,358.0 45,358 1

Nested Loop Left Join (cost=56,894.330..194,737.950 rows=1 width=267) (actual time=521.711..90,565.230 rows=45,358 loops=1)

  • Join Filter: (foxtrot_bravo.two_papa = alpha.quebec)
  • Rows Removed by Join Filter: 338685224
9. 26.057 2,667.627 ↓ 45,358.0 45,358 1

Nested Loop Left Join (cost=56,894.330..194,376.940 rows=1 width=262) (actual time=518.921..2,667.627 rows=45,358 loops=1)

10. 66.185 2,278.706 ↓ 45,358.0 45,358 1

Nested Loop (cost=56,893.900..194,376.460 rows=1 width=254) (actual time=518.861..2,278.706 rows=45,358 loops=1)

11. 56.402 1,214.645 ↓ 3.3 45,358 1

Nested Loop (cost=56,887.180..101,197.300 rows=13,789 width=855) (actual time=518.683..1,214.645 rows=45,358 loops=1)

12. 184.574 750.021 ↓ 1.4 45,358 1

Hash Join (cost=56,886.760..68,483.590 rows=32,392 width=850) (actual time=518.614..750.021 rows=45,358 loops=1)

  • Hash Cond: (charlie.two_papa = alpha.quebec)
13. 47.481 57.783 ↑ 1.0 70,244 1

Bitmap Heap Scan on golf charlie (cost=1,531.750..12,529.190 rows=73,461 width=4) (actual time=10.466..57.783 rows=70,244 loops=1)

  • Recheck Cond: (tango = ANY ('juliet_juliet'::integer[]))
  • Filter: (quebec five NOT NULL)
  • Heap Blocks: exact=970
14. 10.302 10.302 ↑ 1.0 70,244 1

Bitmap Index Scan on sierra_charlie (cost=0.000..1,513.380 rows=73,461 width=0) (actual time=10.302..10.302 rows=70,244 loops=1)

  • Index Cond: (tango = ANY ('juliet_juliet'::integer[]))
15. 153.642 507.664 ↓ 1.2 141,482 1

Hash (cost=53,868.320..53,868.320 rows=118,935 width=846) (actual time=507.664..507.664 rows=141,482 loops=1)

  • Buckets: 262144 (originally 131072) Batches: 1 (originally 1) Memory Usage: 99075kB
16. 354.022 354.022 ↓ 1.2 141,482 1

Seq Scan on romeo_xray alpha (cost=0.000..53,868.320 rows=118,935 width=846) (actual time=0.043..354.022 rows=141,482 loops=1)

  • Filter: (zulu_yankee AND (NOT seven))
  • Rows Removed by Filter: 131062
17. 408.222 408.222 ↑ 1.0 1 45,358

Index Scan using sierra_victor on november_seven four_kilo (cost=0.420..1.000 rows=1 width=9) (actual time=0.008..0.009 rows=1 loops=45,358)

  • Index Cond: (quebec = alpha.november_mike)
  • Filter: (zulu_yankee AND (NOT seven))
18. 45.358 997.876 ↑ 1.0 1 45,358

Subquery Scan on kilo (cost=6.730..6.750 rows=1 width=36) (actual time=0.022..0.022 rows=1 loops=45,358)

  • Filter: (alpha.quebec = kilo.two_papa)
19. 317.506 952.518 ↑ 1.0 1 45,358

Aggregate (cost=6.730..6.740 rows=1 width=36) (actual time=0.021..0.021 rows=1 loops=45,358)

20. 90.693 635.012 ↑ 22.0 1 45,358

Hash Join (cost=3.970..6.120 rows=22 width=64) (actual time=0.013..0.014 rows=1 loops=45,358)

  • Hash Cond: (echo_tango.whiskey_three = echo_yankee.quebec)
21. 136.037 544.296 ↑ 22.0 1 45,358

Hash Join (cost=2.680..4.520 rows=22 width=68) (actual time=0.012..0.012 rows=1 loops=45,358)

  • Hash Cond: ((echo_six.uniform)::integer = echo_tango.quebec)
22. 408.222 408.222 ↑ 100.0 1 45,358

Function Scan on sierra_papa echo_six (cost=0.000..1.000 rows=100 width=64) (actual time=0.009..0.009 rows=1 loops=45,358)

23. 0.009 0.037 ↑ 1.0 22 1

Hash (cost=2.400..2.400 rows=22 width=8) (actual time=0.037..0.037 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
24. 0.028 0.028 ↑ 1.0 22 1

Seq Scan on mike_four echo_tango (cost=0.000..2.400 rows=22 width=8) (actual time=0.008..0.028 rows=22 loops=1)

  • Filter: ((bravo_three)::text = ANY ('foxtrot_delta'::text[]))
  • Rows Removed by Filter: 10
25. 0.009 0.023 ↑ 1.0 13 1

Hash (cost=1.130..1.130 rows=13 width=4) (actual time=0.023..0.023 rows=13 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
26. 0.014 0.014 ↑ 1.0 13 1

Seq Scan on two_whiskey echo_yankee (cost=0.000..1.130 rows=13 width=4) (actual time=0.013..0.014 rows=13 loops=1)

27. 362.864 362.864 ↑ 1.0 1 45,358

Index Scan using four_four on echo_uniform juliet_foxtrot (cost=0.420..0.470 rows=1 width=12) (actual time=0.007..0.008 rows=1 loops=45,358)

  • Index Cond: (two_papa = alpha.quebec)
28. 49,440.220 49,440.220 ↑ 1.0 7,467 45,358

Seq Scan on yankee_foxtrot foxtrot_bravo (cost=0.000..267.670 rows=7,467 width=13) (actual time=0.003..1.090 rows=7,467 loops=45,358)

29. 0.000 0.000 ↓ 0.0 0 45,358

Result (cost=0.000..0.000 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=45,358)

  • One-Time Filter: false
30. 136.074 680.370 ↑ 1.0 1 45,358

Aggregate (cost=4.500..4.510 rows=1 width=64) (actual time=0.015..0.015 rows=1 loops=45,358)

31. 544.296 544.296 ↑ 1.5 2 45,358

Index Scan using yankee_zulu on november_india (cost=0.420..4.490 rows=3 width=5) (actual time=0.009..0.012 rows=2 loops=45,358)

  • Index Cond: (november_mike = alpha.november_mike)
  • Filter: (yankee_mike AND ((bravo_xray)::text <> 'whiskey_alpha'::text))
  • Rows Removed by Filter: 1
32. 453.580 816.444 ↑ 1.0 1 45,358

Aggregate (cost=3.440..3.450 rows=1 width=33) (actual time=0.018..0.018 rows=1 loops=45,358)

33. 362.864 362.864 ↑ 2.0 1 45,358

Index Scan using juliet_zulu on zulu_india (cost=0.420..3.410 rows=2 width=32) (actual time=0.007..0.008 rows=1 loops=45,358)

  • Index Cond: (two_papa = alpha.quebec)
  • Filter: ((mike_quebec)::text <> 'romeo_quebec'::text)
Planning time : 13.090 ms
Execution time : 92,675.564 ms