explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pQzs : Old

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

Limit (cost=60,039.170..148,730.330 rows=14 width=953) (actual time=0.084..0.084 rows=0 loops=1)

2. 0.001 0.084 ↓ 0.0 0 1

Nested Loop Left Join (cost=60,039.170..148,730.190 rows=14 width=953) (actual time=0.084..0.084 rows=0 loops=1)

3. 0.000 0.083 ↓ 0.0 0 1

Nested Loop Left Join (cost=60,038.740..148,715.530 rows=14 width=770) (actual time=0.083..0.083 rows=0 loops=1)

4. 0.001 0.083 ↓ 0.0 0 1

Nested Loop Left Join (cost=60,038.460..148,711.270 rows=14 width=762) (actual time=0.083..0.083 rows=0 loops=1)

  • Join Filter: (november_echo.mike_tango = kilo_sierra_mike.mike_tango)
5. 0.000 0.082 ↓ 0.0 0 1

Nested Loop Left Join (cost=60,038.460..148,709.310 rows=14 width=646) (actual time=0.082..0.082 rows=0 loops=1)

6. 0.000 0.082 ↓ 0.0 0 1

Nested Loop Left Join (cost=60,038.170..148,705.000 rows=14 width=606) (actual time=0.082..0.082 rows=0 loops=1)

  • Join Filter: ((charlie_charlie.whiskey)::text = (four_hotel.golf_hotel)::text)
7. 0.001 0.082 ↓ 0.0 0 1

Nested Loop Left Join (cost=60,038.170..148,643.490 rows=14 width=584) (actual time=0.082..0.082 rows=0 loops=1)

  • Join Filter: ((three_seven.oscar_golf)::text = (four_hotel.india_papa)::text)
8. 0.081 0.081 ↓ 0.0 0 1

Hash Join (cost=60,038.170..148,563.730 rows=14 width=561) (actual time=0.081..0.081 rows=0 loops=1)

  • Hash Cond: (((zulu_tango.india_delta)::text = (sierra_six.lima)::text) AND (CASE WHEN (romeo_quebec.uniform_foxtrot > 0) THEN 'uniform_five'::text ELSE 'delta_oscar'::text END = (sierra_six.four_yankee)::text))
9. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=59,283.970..147,755.400 rows=9,842 width=439) (never executed)

  • Hash Cond: ((kilo_sierra_mike.delta_four)::text = (six_seven.five_zulu)::text)
10. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=59,235.770..147,681.270 rows=9,842 width=425) (never executed)

  • Hash Cond: (four_hotel.victor_uniform_oscar = tango_whiskey.tango_romeo)
11. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=59,097.480..147,517.110 rows=9,842 width=401) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=59,097.050..125,051.690 rows=9,842 width=379) (never executed)

  • Hash Cond: ((five_hotel.bravo)::text = (zulu_lima.romeo_romeo)::text)
13. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=59,095.650..125,018.360 rows=9,842 width=270) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=59,095.220..117,953.040 rows=9,842 width=218) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=59,094.800..94,508.610 rows=10,611 width=151) (never executed)

  • Hash Cond: ((romeo_quebec.romeo_xray)::text = (kilo_sierra_mike.romeo_xray)::text)
16. 0.000 0.000 ↓ 0.0 0

Seq Scan on sierra_victor romeo_quebec (cost=0.000..31,696.040 rows=38,772 width=104) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Hash (cost=53,273.100..53,273.100 rows=273,416 width=47) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on charlie_six kilo_sierra_mike (cost=5,123.400..53,273.100 rows=273,416 width=47) (never executed)

  • Recheck Cond: (five_four = 1)
19. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on golf_whiskey (cost=0.000..5,055.050 rows=273,416 width=0) (never executed)

  • Index Cond: (five_four = 1)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using alpha_november on seven zulu_tango (cost=0.420..2.210 rows=1 width=67) (never executed)

  • Index Cond: ((india_zulu)::text = (romeo_quebec.india_zulu)::text)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using mike_five on romeo_victor five_hotel (cost=0.420..0.720 rows=1 width=67) (never executed)

  • Index Cond: ((four_papa)::text = (kilo_sierra_mike.four_papa)::text)
22. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.180..1.180 rows=18 width=156) (never executed)

23. 0.000 0.000 ↓ 0.0 0

Seq Scan on alpha_yankee zulu_lima (cost=0.000..1.180 rows=18 width=156) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Index Scan using six_two on quebec four_hotel (cost=0.420..2.270 rows=1 width=42) (never executed)

  • Index Cond: ((romeo_xray)::text = (romeo_quebec.romeo_xray)::text)
  • Filter: (kilo_sierra_romeo = romeo_quebec.kilo_sierra_romeo)
25. 0.000 0.000 ↓ 0.0 0

Hash (cost=82.020..82.020 rows=4,502 width=24) (never executed)

26. 0.000 0.000 ↓ 0.0 0

Seq Scan on victor_oscar tango_whiskey (cost=0.000..82.020 rows=4,502 width=24) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Hash (cost=35.310..35.310 rows=1,031 width=30) (never executed)

28. 0.000 0.000 ↓ 0.0 0

Seq Scan on golf_two six_seven (cost=0.000..35.310 rows=1,031 width=30) (never executed)

29. 0.001 0.013 ↓ 0.0 0 1

Hash (cost=669.600..669.600 rows=5,640 width=131) (actual time=0.013..0.013 rows=0 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 64kB
30. 0.001 0.012 ↓ 0.0 0 1

Bitmap Heap Scan on alpha_hotel sierra_six (cost=112.000..669.600 rows=5,640 width=131) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((oscar_five)::date >= 'mike_six'::date)
31. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on juliet (cost=0.000..110.590 rows=5,640 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((oscar_five)::date >= 'mike_six'::date)
32. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.000..10.040 rows=336 width=31) (never executed)

33. 0.000 0.000 ↓ 0.0 0

Seq Scan on victor_uniform_xray three_seven (cost=0.000..8.360 rows=336 width=31) (never executed)

34. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.000..8.810 rows=254 width=32) (never executed)

35. 0.000 0.000 ↓ 0.0 0

Seq Scan on three_foxtrot charlie_charlie (cost=0.000..7.540 rows=254 width=32) (never executed)

36. 0.000 0.000 ↓ 0.0 0

Index Scan using six_juliet on oscar_juliet four_seven (cost=0.290..0.310 rows=1 width=44) (never executed)

  • Index Cond: (kilo_sierra_romeo = four_hotel.kilo_sierra_romeo)
37. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.000..1.070 rows=5 width=126) (never executed)

38. 0.000 0.000 ↓ 0.0 0

Seq Scan on romeo_mike november_echo (cost=0.000..1.050 rows=5 width=126) (never executed)

39. 0.000 0.000 ↓ 0.0 0

Index Scan using papa on five_six victor_india (cost=0.290..0.300 rows=1 width=12) (never executed)

  • Index Cond: (uniform_india = zulu_tango.kilo_whiskey)
40. 0.000 0.000 ↓ 0.0 0

Index Scan using oscar_oscar on november_yankee tango_sierra (cost=0.420..0.480 rows=1 width=27) (never executed)

  • Index Cond: ((india_zulu)::text = (zulu_tango.india_zulu)::text)
  • Filter: (zulu_tango.kilo_whiskey = uniform_india)
41.          

SubPlan (for Hash)

42. 0.000 0.000 ↓ 0.0 0

Result (cost=0.000..0.020 rows=1 width=4) (never executed)