explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NA2g : tasklist LOV

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.923 ↓ 0.0 0 1

WindowAgg (cost=164,836.380..164,905.160 rows=1,448 width=514) (actual time=0.923..0.923 rows=0 loops=1)

2. 0.001 0.923 ↓ 0.0 0 1

WindowAgg (cost=164,836.380..164,868.960 rows=1,448 width=399) (actual time=0.923..0.923 rows=0 loops=1)

3. 0.011 0.922 ↓ 0.0 0 1

Sort (cost=164,836.380..164,840.000 rows=1,448 width=391) (actual time=0.922..0.922 rows=0 loops=1)

  • Sort Key: lima_mike.victor_yankee, lima_mike.oscar_whiskey, three_india.uniform
  • Sort Method: quicksort Memory: 25kB
4. 0.036 0.911 ↓ 0.0 0 1

Hash Right Join (cost=148,395.800..164,760.360 rows=1,448 width=391) (actual time=0.911..0.911 rows=0 loops=1)

  • Hash Cond: ((quebec_three.yankee_golf)::text = ((papa_zulu(oscar_lima((three_india.uniform)::text, 'victor_india'::numeric)))::text))
5. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=139,539.450..151,625.660 rows=679,103 width=27) (never executed)

  • Merge Cond: (((quebec_sierra.zulu)::numeric) = quebec_three.kilo_delta)
6. 0.000 0.000 ↓ 0.0 0

Sort (cost=2,879.370..2,946.700 rows=26,930 width=22) (never executed)

  • Sort Key: ((quebec_sierra.zulu)::numeric)
7. 0.000 0.000 ↓ 0.0 0

Index Only Scan using two_charlie on whiskey quebec_sierra (cost=0.290..897.740 rows=26,930 width=22) (never executed)

  • Heap Fetches: 0
8. 0.000 0.000 ↓ 0.0 0

Sort (cost=136,660.080..136,859.480 rows=79,762 width=18) (never executed)

  • Sort Key: quebec_three.kilo_delta
9. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=53,122.230..130,166.090 rows=79,762 width=18) (never executed)

  • Hash Cond: (quebec_three.yankee_golf = five.yankee_golf)
10. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=14.990..75,962.130 rows=79,762 width=15) (never executed)

  • Hash Cond: ((quebec_three.yankee_golf)::text = two_juliet((hotel.uniform)::text, 14))
11. 0.000 0.000 ↓ 0.0 0

Index Scan using bravo_charlie on lima_tango quebec_three (cost=0.420..62,537.940 rows=136,346 width=15) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Hash (cost=13.100..13.100 rows=117 width=19) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Index Only Scan using papa_oscar on sierra hotel (cost=0.560..13.100 rows=117 width=19) (never executed)

  • Index Cond: (victor_yankee = 'xray_quebec'::numeric)
  • Heap Fetches: 0
14. 0.000 0.000 ↓ 0.0 0

Hash (cost=42,662.660..42,662.660 rows=835,566 width=13) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Seq Scan on kilo_golf five (cost=0.000..42,662.660 rows=835,566 width=13) (never executed)

16. 0.000 0.875 ↓ 0.0 0 1

Hash (cost=8,856.340..8,856.340 rows=1 width=342) (actual time=0.875..0.875 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
17. 0.000 0.875 ↓ 0.0 0 1

Nested Loop (cost=1,303.030..8,856.340 rows=1 width=342) (actual time=0.875..0.875 rows=0 loops=1)

  • Join Filter: ((lima_mike.foxtrot)::numeric = alpha.foxtrot)
18. 0.000 0.875 ↓ 0.0 0 1

Nested Loop (cost=1,302.750..8,851.670 rows=3 width=324) (actual time=0.875..0.875 rows=0 loops=1)

  • Join Filter: (three_india.two_xray = charlie_bravo.two_xray)
19. 0.087 0.087 ↓ 1.0 33 1

Index Scan using yankee_mike on november charlie_bravo (cost=0.140..9.930 rows=32 width=35) (actual time=0.045..0.087 rows=33 loops=1)

  • Index Cond: (bravo_yankee = 'kilo_tango'::numeric)
20. 0.022 0.792 ↓ 0.0 0 33

Materialize (cost=1,302.610..8,837.920 rows=8 width=289) (actual time=0.024..0.024 rows=0 loops=33)

21. 0.002 0.770 ↓ 0.0 0 1

Nested Loop (cost=1,302.610..8,837.880 rows=8 width=289) (actual time=0.770..0.770 rows=0 loops=1)

22. 0.332 0.332 ↑ 1.0 1 1

Function Scan on six victor_bravo (cost=0.250..0.260 rows=1 width=32) (actual time=0.332..0.332 rows=1 loops=1)

23. 0.001 0.436 ↓ 0.0 0 1

WindowAgg (cost=1,302.360..8,837.460 rows=8 width=269) (actual time=0.436..0.436 rows=0 loops=1)

24. 0.001 0.435 ↓ 0.0 0 1

Nested Loop (cost=1,302.360..8,837.160 rows=8 width=209) (actual time=0.435..0.435 rows=0 loops=1)

25. 0.005 0.434 ↓ 0.0 0 1

Hash Join (cost=1,302.070..8,834.610 rows=8 width=203) (actual time=0.434..0.434 rows=0 loops=1)

  • Hash Cond: ((juliet_tango.xray_zulu)::numeric = lima_mike.india)
26. 0.007 0.007 ↑ 147,192.0 1 1

Seq Scan on four_xray juliet_tango (cost=0.000..6,796.500 rows=147,192 width=16) (actual time=0.007..0.007 rows=1 loops=1)

  • Filter: (juliet_charlie = 1)
27. 0.000 0.422 ↓ 0.0 0 1

Hash (cost=1,302.060..1,302.060 rows=1 width=201) (actual time=0.422..0.422 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
28. 0.004 0.422 ↓ 0.0 0 1

Nested Loop (cost=1.110..1,302.060 rows=1 width=201) (actual time=0.422..0.422 rows=0 loops=1)

29. 0.244 0.244 ↑ 39.0 3 1

Index Scan using papa_oscar on sierra lima_mike (cost=0.560..414.030 rows=117 width=67) (actual time=0.199..0.244 rows=3 loops=1)

  • Index Cond: (victor_yankee = 'xray_quebec'::numeric)
30. 0.174 0.174 ↓ 0.0 0 3

Index Scan using charlie_victor on three_yankee three_india (cost=0.560..7.580 rows=1 width=153) (actual time=0.058..0.058 rows=0 loops=3)

  • Index Cond: (uniform = lima_mike.uniform)
  • Filter: ((bravo_yankee)::text = 'kilo_tango'::text)
  • Rows Removed by Filter: 1
31. 0.000 0.000 ↓ 0.0 0

Index Only Scan using two_charlie on whiskey seven (cost=0.290..0.310 rows=1 width=22) (never executed)

  • Index Cond: (zulu = juliet_tango.delta)
  • Heap Fetches: 0
32. 0.000 0.000 ↓ 0.0 0

Index Scan using three_three on romeo alpha (cost=0.280..1.520 rows=2 width=43) (never executed)

  • Index Cond: ((bravo_yankee = 'kilo_tango'::numeric) AND (two_xray = charlie_bravo.two_xray))
  • Filter: (two_xray <> 'four_bravo'::numeric)
Planning time : 3.512 ms
Execution time : 1.298 ms