explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xzvq : Optimization for: mysql; plan #TaSa

Settings

Optimization path:

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

Append (cost=0..0 rows=0 width=0) (never executed)

2.          

CTE new_accomp

3. 0.000 0.000 ↓ 0.0

Aggregate (cost=0..0 rows=0 width=0) (never executed)

4. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: a.id, (COALESCE(py.geom, l.geom, pt_1.geom)), ht.name, at.name, ((a.id)::text), pt.name, acalc.acres, acalc.miles, acalc.num_structures, (COALESCE((a.report_fiscal_year)::integer, habits4.fiscal_year(a.completion_date))), ((((person.fname)::text || ' '::text) || (person.lname)::text)), person.email, person.phone, st.name, tr.name
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

7. 0.000 0.000 ↓ 0.0

Seq Scan on accomp_treatment_cross tc (cost=0..0 rows=0 width=0) (never executed)

8. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

9. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

10. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

11. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

12. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

13. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

14. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

15. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

16. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

17. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

18. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

19. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

20. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

21. 0.000 0.000 ↓ 0.0

Seq Scan on accomplishment_poly py (cost=0..0 rows=0 width=0) (never executed)

22. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

23. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

24. 0.000 0.000 ↓ 0.0

Seq Scan on mv_rprt_accomp_sptl_calc acalc (cost=0..0 rows=0 width=0) (never executed)

25. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

26. 0.000 0.000 ↓ 0.0

Seq Scan on accomplishment a (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (a.report_fiscal_year > '2012'::numeric)
27. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

28. 0.000 0.000 ↓ 0.0

Seq Scan on accomplishment_line l (cost=0..0 rows=0 width=0) (never executed)

29. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

30. 0.000 0.000 ↓ 0.0

Seq Scan on accomplishment_point pt_1 (cost=0..0 rows=0 width=0) (never executed)

31. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

32. 0.000 0.000 ↓ 0.0

Seq Scan on habitat_type_lut ht (cost=0..0 rows=0 width=0) (never executed)

33. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

34. 0.000 0.000 ↓ 0.0

Seq Scan on accomp_type_lut at (cost=0..0 rows=0 width=0) (never executed)

35. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

36. 0.000 0.000 ↓ 0.0

Seq Scan on program_type_lut pt (cost=0..0 rows=0 width=0) (never executed)

37. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

38. 0.000 0.000 ↓ 0.0

Seq Scan on project p (cost=0..0 rows=0 width=0) (never executed)

39. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

40. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

41. 0.000 0.000 ↓ 0.0

Seq Scan on person person (cost=0..0 rows=0 width=0) (never executed)

42. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

43. 0.000 0.000 ↓ 0.0

Index Only Scan using s7_office_jurisdiction_spatial_office_id on cmt_lut cl (cost=0..0 rows=0 width=0) (never executed)

44. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

45. 0.000 0.000 ↓ 0.0

Seq Scan on accomp_status_lut st (cost=0..0 rows=0 width=0) (never executed)

46. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

47. 0.000 0.000 ↓ 0.0

Seq Scan on trust_resource_lut tr (cost=0..0 rows=0 width=0) (never executed)

48. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

49. 0.000 0.000 ↓ 0.0

Seq Scan on accomp_fws_initiative_cross ic (cost=0..0 rows=0 width=0) (never executed)

50. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

51. 0.000 0.000 ↓ 0.0

Seq Scan on fws_initiative_lut il (cost=0..0 rows=0 width=0) (never executed)

52. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

53. 0.000 0.000 ↓ 0.0

Seq Scan on treatment_type_lut tl (cost=0..0 rows=0 width=0) (never executed)

54.          

CTE wmd_refuges

55. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

56. 0.000 0.000 ↓ 0.0

Index Only Scan using module_valid_office_cross_pkey on module_valid_office_cross m (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (m.module_id = 34)
57. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

58. 0.000 0.000 ↓ 0.0

Seq Scan on cmt_lut c (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((c.orgtypeacro)::text = 'WMD'::text)
59.          

CTE wmd_counties

60. 0.000 0.000 ↓ 0.0

Aggregate (cost=0..0 rows=0 width=0) (never executed)

61. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: r.orgcode, r.orgname, r.region, r.cost_center_code, r.office_id
62. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

63. 0.000 0.000 ↓ 0.0

Seq Scan on county_g cg (cost=0..0 rows=0 width=0) (never executed)

64. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

65. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

66. 0.000 0.000 ↓ 0.0

Seq Scan on cmt_fips cf (cost=0..0 rows=0 width=0) (never executed)

67. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

68. 0.000 0.000 ↓ 0.0

CTE Scan on wmd_refuges r (cost=0..0 rows=0 width=0) (never executed)

69.          

CTE rhi_refuges

70. 0.000 0.000 ↓ 0.0

Aggregate (cost=0..0 rows=0 width=0) (never executed)

71. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

72. 0.000 0.000 ↓ 0.0

Index Only Scan using module_valid_office_cross_pkey on module_valid_office_cross m_1 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (m_1.module_id = 34)
73. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

74. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

75. 0.000 0.000 ↓ 0.0

Seq Scan on cmt_lut c_1 (cost=0..0 rows=0 width=0) (never executed)

76. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

77. 0.000 0.000 ↓ 0.0

Seq Scan on refuge_rhi rr (cost=0..0 rows=0 width=0) (never executed)

78.          

CTE fws_refuges

79. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

80. 0.000 0.000 ↓ 0.0

Index Only Scan using module_valid_office_cross_pkey on module_valid_office_cross m_2 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (m_2.module_id = 34)
81. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

82. 0.000 0.000 ↓ 0.0

Seq Scan on cmt_lut c_2 (cost=0..0 rows=0 width=0) (never executed)

83.          

CTE united_refuges

84. 0.000 0.000 ↓ 0.0

Aggregate (cost=0..0 rows=0 width=0) (never executed)

85. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: g.orgcode, r_1.orgname, r_1.region, r_1.cost_center_code, r_1.office_id
86. 0.000 0.000 ↓ 0.0

Merge Join (cost=0..0 rows=0 width=0) (never executed)

87. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: r_1.orgcode
88. 0.000 0.000 ↓ 0.0

CTE Scan on fws_refuges r_1 (cost=0..0 rows=0 width=0) (never executed)

89. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: ((g.orgcode)::numeric)
90. 0.000 0.000 ↓ 0.0

Seq Scan on fws_cadastral_interest_g g (cost=0..0 rows=0 width=0) (never executed)

91. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

92. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

93. 0.000 0.000 ↓ 0.0

CTE Scan on wmd_counties ur (cost=0..0 rows=0 width=0) (never executed)

94. 0.000 0.000 ↓ 0.0

CTE Scan on new_accomp na (cost=0..0 rows=0 width=0) (never executed)

95. 0.000 0.000 ↓ 0.0

CTE Scan on united_refuges nur (cost=0..0 rows=0 width=0) (never executed)

96. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

97. 0.000 0.000 ↓ 0.0

CTE Scan on united_refuges nur_1 (cost=0..0 rows=0 width=0) (never executed)

98. 0.000 0.000 ↓ 0.0

Materialize (cost=0..0 rows=0 width=0) (never executed)

99. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

100. 0.000 0.000 ↓ 0.0

CTE Scan on rhi_refuges ur_1 (cost=0..0 rows=0 width=0) (never executed)

101. 0.000 0.000 ↓ 0.0

CTE Scan on new_accomp na_1 (cost=0..0 rows=0 width=0) (never executed)