explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AYZx

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.078 ↓ 0.0 0 1

Unique (cost=29,964.66..29,964.67 rows=1 width=224) (actual time=0.078..0.078 rows=0 loops=1)

2. 0.010 0.077 ↓ 0.0 0 1

Sort (cost=29,964.66..29,964.67 rows=1 width=224) (actual time=0.077..0.077 rows=0 loops=1)

  • Sort Key: st.stem_key, mdt.value_item DESC NULLS LAST
  • Sort Method: quicksort Memory: 25kB
3. 0.000 0.067 ↓ 0.0 0 1

Nested Loop Left Join (cost=26.68..29,964.65 rows=1 width=224) (actual time=0.067..0.067 rows=0 loops=1)

4. 0.001 0.067 ↓ 0.0 0 1

Nested Loop Left Join (cost=26.25..29,964.17 rows=1 width=197) (actual time=0.067..0.067 rows=0 loops=1)

5. 0.000 0.066 ↓ 0.0 0 1

Nested Loop Left Join (cost=25.82..29,963.71 rows=1 width=188) (actual time=0.066..0.066 rows=0 loops=1)

6. 0.000 0.066 ↓ 0.0 0 1

Nested Loop (cost=25.39..29,963.23 rows=1 width=176) (actual time=0.066..0.066 rows=0 loops=1)

7. 0.000 0.066 ↓ 0.0 0 1

Nested Loop (cost=24.95..29,962.77 rows=1 width=114) (actual time=0.066..0.066 rows=0 loops=1)

  • Join Filter: (shp.single_tree_processed_stem_s_0 = stem_vol.log_single_tree_processed_st_0)
8. 0.001 0.066 ↓ 0.0 0 1

Nested Loop (cost=22.96..2,286.37 rows=1,028 width=82) (actual time=0.066..0.066 rows=0 loops=1)

9. 0.000 0.065 ↓ 0.0 0 1

Nested Loop (cost=22.52..1,816.54 rows=1,028 width=74) (actual time=0.065..0.065 rows=0 loops=1)

  • Join Filter: (mt.hjid = shp.stem_machine_harvested_produ_0)
10. 0.000 0.065 ↓ 0.0 0 1

Nested Loop Left Join (cost=22.09..1,656.71 rows=4 width=74) (actual time=0.065..0.065 rows=0 loops=1)

11. 0.001 0.065 ↓ 0.0 0 1

Nested Loop Left Join (cost=21.80..1,647.47 rows=4 width=77) (actual time=0.065..0.065 rows=0 loops=1)

12. 0.000 0.064 ↓ 0.0 0 1

Nested Loop Left Join (cost=21.51..1,646.05 rows=4 width=73) (actual time=0.064..0.064 rows=0 loops=1)

13. 0.000 0.064 ↓ 0.0 0 1

Nested Loop (cost=21.22..1,644.77 rows=4 width=73) (actual time=0.064..0.064 rows=0 loops=1)

14. 0.010 0.064 ↓ 0.0 0 1

Hash Join (cost=20.93..1,643.49 rows=4 width=73) (actual time=0.064..0.064 rows=0 loops=1)

  • Hash Cond: (xfl.hjid = mhp.machine_harvested_production_0)
15. 0.014 0.014 ↑ 23,696.0 1 1

Seq Scan on xml_file_list xfl (cost=0.00..1,533.66 rows=23,696 width=41) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: ((hjid_tablename)::text = 'sf2010_v2_hpr.harvested_production_type'::text)
16. 0.001 0.040 ↓ 0.0 0 1

Hash (cost=20.86..20.86 rows=6 width=32) (actual time=0.040..0.040 rows=0 loops=1)

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

Nested Loop (cost=1.62..20.86 rows=6 width=32) (actual time=0.039..0.039 rows=0 loops=1)

18. 0.003 0.039 ↓ 0.0 0 1

Bitmap Heap Scan on machine_type mt (cost=1.33..7.02 rows=6 width=24) (actual time=0.039..0.039 rows=0 loops=1)

  • Recheck Cond: ((machine_key)::text = 'FeltGIS_00071'::text)
19. 0.036 0.036 ↓ 0.0 0 1

Bitmap Index Scan on machine_type_machine_key_idx (cost=0.00..1.33 rows=6 width=0) (actual time=0.036..0.036 rows=0 loops=1)

  • Index Cond: ((machine_key)::text = 'FeltGIS_00071'::text)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using machine_harvested_production_1_pkey on machine_harvested_production_1 mhp (cost=0.29..2.31 rows=1 width=8) (never executed)

  • Index Cond: (hjid = mt.hjid)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using harvested_production_type_pkey on harvested_production_type hpt (cost=0.29..0.32 rows=1 width=8) (never executed)

  • Index Cond: (hjid = xfl.hjid)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using message_header_type_pkey on message_header_type mht (cost=0.29..0.32 rows=1 width=8) (never executed)

  • Index Cond: (hpt.harvested_production_header__0 = hjid)
23. 0.000 0.000 ↓ 0.0 0

Index Scan using modification_date_type_pkey on modification_date_type mdt (cost=0.29..0.36 rows=1 width=12) (never executed)

  • Index Cond: (mht.modification_date_message_he_0 = hjid)
24. 0.000 0.000 ↓ 0.0 0

Index Scan using contact_information_type_pkey on contact_information_type cit (cost=0.29..2.31 rows=1 width=5) (never executed)

  • Index Cond: (hjid = mt.logging_contractor_machine_t_0)
25. 0.000 0.000 ↓ 0.0 0

Index Scan using stem_harvested_production_ty_0_stem_machine_harvested_produ_0_i on stem_harvested_production_ty_0 shp (cost=0.43..24.81 rows=1,212 width=12) (never executed)

  • Index Cond: (stem_machine_harvested_produ_0 = mhp.hjid)
26. 0.000 0.000 ↓ 0.0 0

Index Scan using single_tree_processed_stem_t_0_pkey on single_tree_processed_stem_t_0 stps (cost=0.43..0.46 rows=1 width=8) (never executed)

  • Index Cond: (hjid = shp.single_tree_processed_stem_s_0)
27. 0.000 0.000 ↓ 0.0 0

Subquery Scan on stem_vol (cost=2.00..26.91 rows=1 width=44) (never executed)

  • Filter: (stps.hjid = stem_vol.log_single_tree_processed_st_0)
28. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=2.00..26.90 rows=1 width=44) (never executed)

  • Group Key: lhpt.log_single_tree_processed_st_0
29. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.00..26.87 rows=1 width=32) (never executed)

  • Recheck Cond: ((machine_key)::text = 'FeltGIS_00071'::text)
30. 0.036 0.036 ↓ 0.0 0 1

Bitmap Index Scan on machine_type_machine_key_idx (cost=0.00..1.33 rows=6 width=0) (actual time=0.036..0.036 rows=0 loops=1)

  • Index Cond: ((machine_key)::text = 'FeltGIS_00071'::text)
31. 0.000 0.000 ↓ 0.0 0

Index Scan using machine_harvested_production_1_pkey on machine_harvested_production_1 mhp (cost=0.29..2.31 rows=1 width=8) (never executed)

  • Index Cond: (hjid = mt.hjid)
32. 0.000 0.000 ↓ 0.0 0

Index Scan using harvested_production_type_pkey on harvested_production_type hpt (cost=0.29..0.32 rows=1 width=8) (never executed)

  • Index Cond: (hjid = xfl.hjid)
33. 0.000 0.000 ↓ 0.0 0

Index Scan using message_header_type_pkey on message_header_type mht (cost=0.29..0.32 rows=1 width=8) (never executed)

  • Index Cond: (hpt.harvested_production_header__0 = hjid)
34. 0.000 0.000 ↓ 0.0 0

Index Scan using modification_date_type_pkey on modification_date_type mdt (cost=0.29..0.36 rows=1 width=12) (never executed)

  • Index Cond: (mht.modification_date_message_he_0 = hjid)
35. 0.000 0.000 ↓ 0.0 0

Index Scan using contact_information_type_pkey on contact_information_type cit (cost=0.29..2.31 rows=1 width=5) (never executed)

  • Index Cond: (hjid = mt.logging_contractor_machine_t_0)
36. 0.000 0.000 ↓ 0.0 0

Index Scan using stem_harvested_production_ty_0_stem_machine_harvested_produ_0_i on stem_harvested_production_ty_0 shp (cost=0.43..24.81 rows=1,212 width=12) (never executed)

  • Index Cond: (stem_machine_harvested_produ_0 = mhp.hjid)
37. 0.000 0.000 ↓ 0.0 0

Index Scan using single_tree_processed_stem_t_0_pkey on single_tree_processed_stem_t_0 stps (cost=0.43..0.46 rows=1 width=8) (never executed)

  • Index Cond: (hjid = shp.single_tree_processed_stem_s_0)
38. 0.000 0.000 ↓ 0.0 0

Subquery Scan on stem_vol (cost=2.00..26.91 rows=1 width=44) (never executed)

  • Filter: (stps.hjid = stem_vol.log_single_tree_processed_st_0)
39. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=2.00..26.90 rows=1 width=44) (never executed)

  • Group Key: lhpt.log_single_tree_processed_st_0
40. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.00..26.87 rows=1 width=32) (never executed)

41. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.56..24.42 rows=1 width=32) (never executed)

42. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.00..12.51 rows=4 width=16) (never executed)

43. 0.000 0.000 ↓ 0.0 0

Index Scan using log_harvested_production_type_log_single_tree_processed_st_0_id on log_harvested_production_type lhpt (cost=0.56..2.70 rows=4 width=12) (never executed)

  • Index Cond: (stps.hjid = log_single_tree_processed_st_0)
44. 0.000 0.000 ↓ 0.0 0

Index Only Scan using log_type_pkey on log_type lt (cost=0.43..2.45 rows=1 width=4) (never executed)

  • Index Cond: (hjid = lhpt.hjid)
  • Heap Fetches: 0
45. 0.000 0.000 ↓ 0.0 0

Subquery Scan on lvt (cost=0.56..2.97 rows=1 width=28) (never executed)

  • Filter: (lt.hjid = lvt.log_volume_log_type_hjid)
46. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=0.56..2.92 rows=4 width=28) (never executed)

  • Group Key: log_volume_type.log_volume_log_type_hjid
47. 0.000 0.000 ↓ 0.0 0

Index Scan using log_volume_type_log_volume_log_type_hjid_idx on log_volume_type (cost=0.56..2.72 rows=4 width=20) (never executed)

  • Index Cond: (log_volume_log_type_hjid = lt.hjid)
48. 0.000 0.000 ↓ 0.0 0

Index Scan using log_measurement_type_pkey on log_measurement_type lmt (cost=0.43..2.45 rows=1 width=8) (never executed)

  • Index Cond: (hjid = lhpt.log_measurement_log_harveste_0)
49. 0.000 0.000 ↓ 0.0 0

Index Scan using stem_type_pkey on stem_type st (cost=0.43..0.46 rows=1 width=66) (never executed)

  • Index Cond: (hjid = shp.hjid)
50. 0.000 0.000 ↓ 0.0 0

Index Scan using coordinates_type_stem_coordinates_stem_type_h_0_idx on coordinates_type ct (cost=0.43..0.47 rows=1 width=20) (never executed)

  • Index Cond: (st.hjid = stem_coordinates_stem_type_h_0)
51. 0.000 0.000 ↓ 0.0 0

Index Scan using longitude_type_pkey on longitude_type lon (cost=0.43..0.46 rows=1 width=17) (never executed)

  • Index Cond: (ct.longitude_coordinates_type_h_0 = hjid)
52. 0.000 0.000 ↓ 0.0 0

Index Scan using latitude_type_pkey on latitude_type lat (cost=0.43..0.46 rows=1 width=18) (never executed)

  • Index Cond: (ct.latitude_coordinates_type_hj_0 = hjid)
Planning time : 13.553 ms
Execution time : 0.481 ms