explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zkKY

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 317.303 ↓ 96.0 96 1

Limit (cost=34,285.160..34,285.410 rows=1 width=240) (actual time=316.774..317.303 rows=96 loops=1)

2. 0.551 317.285 ↓ 96.0 96 1

Result (cost=34,285.160..34,285.410 rows=1 width=240) (actual time=316.767..317.285 rows=96 loops=1)

3. 5.198 316.734 ↓ 96.0 96 1

Sort (cost=34,285.160..34,285.170 rows=1 width=425) (actual time=316.719..316.734 rows=96 loops=1)

  • Sort Key: alpha.zulu_yankee DESC, alpha.india
  • Sort Method: top-N heapsort Memory: 77kB
4. 16.819 311.536 ↓ 4,130.0 4,130 1

WindowAgg (cost=163.220..34,285.150 rows=1 width=425) (actual time=301.087..311.536 rows=4,130 loops=1)

5. 3.380 294.717 ↓ 4,130.0 4,130 1

Nested Loop (cost=163.220..34,285.090 rows=1 width=372) (actual time=1.696..294.717 rows=4,130 loops=1)

6. 2.228 233.517 ↓ 4,130.0 4,130 1

Nested Loop (cost=159.780..34,281.620 rows=1 width=339) (actual time=1.651..233.517 rows=4,130 loops=1)

7. 1.941 185.859 ↓ 4,130.0 4,130 1

Nested Loop Left Join (cost=155.280..34,277.090 rows=1 width=275) (actual time=1.619..185.859 rows=4,130 loops=1)

  • Join Filter: false
8. 3.829 183.918 ↓ 4,130.0 4,130 1

Nested Loop Left Join (cost=155.280..34,277.080 rows=1 width=267) (actual time=1.618..183.918 rows=4,130 loops=1)

9. 2.017 167.699 ↓ 4,130.0 4,130 1

Nested Loop Left Join (cost=154.870..34,276.640 rows=1 width=262) (actual time=1.563..167.699 rows=4,130 loops=1)

10. 4.283 145.032 ↓ 4,130.0 4,130 1

Nested Loop (cost=154.450..34,276.160 rows=1 width=254) (actual time=1.549..145.032 rows=4,130 loops=1)

11. 1.259 62.279 ↓ 3.1 4,130 1

Nested Loop (cost=147.730..25,410.320 rows=1,312 width=855) (actual time=1.424..62.279 rows=4,130 loops=1)

12. 1.670 44.500 ↓ 1.3 4,130 1

Nested Loop (cost=147.310..22,298.720 rows=3,081 width=850) (actual time=1.408..44.500 rows=4,130 loops=1)

13. 2.283 3.365 ↓ 1.1 7,893 1

Bitmap Heap Scan on golf charlie (cost=146.880..5,872.020 rows=6,988 width=4) (actual time=1.112..3.365 rows=7,893 loops=1)

  • Recheck Cond: (tango = ANY ('uniform_xray'::integer[]))
  • Filter: (quebec five NOT NULL)
  • Heap Blocks: exact=54
14. 1.082 1.082 ↓ 1.1 7,893 1

Bitmap Index Scan on sierra_charlie (cost=0.000..145.140 rows=6,988 width=0) (actual time=1.082..1.082 rows=7,893 loops=1)

  • Index Cond: (tango = ANY ('uniform_xray'::integer[]))
15. 39.465 39.465 ↑ 1.0 1 7,893

Index Scan using mike_romeo on romeo_xray alpha (cost=0.420..2.340 rows=1 width=846) (actual time=0.005..0.005 rows=1 loops=7,893)

  • Index Cond: (quebec = charlie.two_papa)
  • Filter: (zulu_yankee AND (NOT seven))
  • Rows Removed by Filter: 0
16. 16.520 16.520 ↑ 1.0 1 4,130

Index Scan using sierra_victor on november_seven four_kilo (cost=0.420..1.000 rows=1 width=9) (actual time=0.004..0.004 rows=1 loops=4,130)

  • Index Cond: (quebec = alpha.november_mike)
  • Filter: (zulu_yankee AND (NOT seven))
17. 0.000 78.470 ↑ 1.0 1 4,130

Subquery Scan on kilo (cost=6.730..6.750 rows=1 width=36) (actual time=0.019..0.019 rows=1 loops=4,130)

  • Filter: (alpha.quebec = kilo.two_papa)
18. 33.040 78.470 ↑ 1.0 1 4,130

Aggregate (cost=6.730..6.740 rows=1 width=36) (actual time=0.019..0.019 rows=1 loops=4,130)

19. 8.241 45.430 ↑ 7.3 3 4,130

Hash Join (cost=3.970..6.120 rows=22 width=64) (actual time=0.007..0.011 rows=3 loops=4,130)

  • Hash Cond: (echo_tango.whiskey_three = echo_yankee.quebec)
20. 12.351 37.170 ↑ 7.3 3 4,130

Hash Join (cost=2.680..4.520 rows=22 width=68) (actual time=0.007..0.009 rows=3 loops=4,130)

  • Hash Cond: ((echo_six.uniform_yankee)::integer = echo_tango.quebec)
21. 24.780 24.780 ↑ 20.0 5 4,130

Function Scan on sierra_papa echo_six (cost=0.000..1.000 rows=100 width=64) (actual time=0.005..0.006 rows=5 loops=4,130)

22. 0.016 0.039 ↑ 1.0 22 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
23. 0.023 0.023 ↑ 1.0 22 1

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

  • Filter: ((bravo_three)::text = ANY ('foxtrot_delta'::text[]))
  • Rows Removed by Filter: 10
24. 0.008 0.019 ↑ 1.0 13 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
25. 0.011 0.011 ↑ 1.0 13 1

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

26. 20.650 20.650 ↑ 1.0 1 4,130

Index Scan using four_four on echo_uniform juliet_foxtrot (cost=0.420..0.470 rows=1 width=12) (actual time=0.005..0.005 rows=1 loops=4,130)

  • Index Cond: (two_papa = alpha.quebec)
27. 12.390 12.390 ↓ 0.0 0 4,130

Index Only Scan using juliet_zulu_oscar on yankee_foxtrot foxtrot_bravo (cost=0.410..0.430 rows=1 width=13) (actual time=0.003..0.003 rows=0 loops=4,130)

  • Index Cond: (two_papa = alpha.quebec)
  • Heap Fetches: 0
28. 0.000 0.000 ↓ 0.0 0 4,130

Result (cost=0.000..0.000 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=4,130)

  • One-Time Filter: false
29. 8.260 45.430 ↑ 1.0 1 4,130

Aggregate (cost=4.500..4.510 rows=1 width=64) (actual time=0.011..0.011 rows=1 loops=4,130)

30. 37.170 37.170 ↑ 1.0 3 4,130

Index Scan using yankee_zulu on november_india (cost=0.420..4.490 rows=3 width=5) (actual time=0.004..0.009 rows=3 loops=4,130)

  • Index Cond: (november_mike = alpha.november_mike)
  • Filter: (yankee_mike AND ((bravo_xray)::text <> 'whiskey_alpha'::text))
  • Rows Removed by Filter: 5
31. 28.910 57.820 ↑ 1.0 1 4,130

Aggregate (cost=3.440..3.450 rows=1 width=33) (actual time=0.014..0.014 rows=1 loops=4,130)

32. 28.910 28.910 ↓ 2.5 5 4,130

Index Scan using juliet_zulu_charlie on zulu_india (cost=0.420..3.410 rows=2 width=32) (actual time=0.005..0.007 rows=5 loops=4,130)

  • Index Cond: (two_papa = alpha.quebec)
  • Filter: ((mike_quebec)::text <> 'romeo_quebec'::text)
  • Rows Removed by Filter: 0
Planning time : 6.816 ms
Execution time : 317.716 ms