postgres_explain_analyze_json_schema/schema.yaml at main · SKalt/postgres_explain_analyze_json_schema · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
$id: /$defs/ExplainAnalyze
$schema: https://json-schema.org/draft-07/schema
definitions:
  ExplainAnalyze:
    properties:
      Execution Time:
        type: number
      Plan:
        $ref: /$defs/Plan
      Planning:
        $ref: /$defs/Planning
      Planning Time:
        type: number
      Triggers:
        type: 'null'
    required:
    - Execution Time
    - Plan
    - Planning
    - Planning Time
    - Triggers
    type: object
  JoinType:
    enum:
    - Inner
    - Left
    - Right
    - Anti
  NodeType:
    enum:
    - Hash Join
    - Hash
    - Index Only Scan
    - Index Scan
    - Materialize
    - Memoize
    - Merge Join
    - Nested Loop
    - Seq Scan
    - Sort
  Plan:
    properties:
      Actual Loops:
        type: integer
      Actual Rows:
        type: integer
      Actual Startup Time:
        type: number
      Actual Total Time:
        type: number
      Alias:
        type: string
      Async Capable:
        type: boolean
      Hash Cond:
        type: string
      Inner Unique:
        type: boolean
      Join Filter:
        type: string
      Join Type:
        $ref: /$defs/JoinType
      Local Dirtied Blocks:
        type: integer
      Local Hit Blocks:
        type: integer
      Local Read Blocks:
        type: integer
      Local Written Blocks:
        type: integer
      Node Type:
        $ref: /$defs/NodeType
      Output:
        items:
          type: string
        type: array
      Parallel Aware:
        type: boolean
      Plan Rows:
        type: integer
      Plan Width:
        type: integer
      Plans:
        items:
          $ref: /$defs/Plan
        type: array
      Relation Name:
        type: string
      Rows Removed by Join Filter:
        type: integer
      Schema:
        type: string
      Shared Dirtied Blocks:
        type: integer
      Shared Hit Blocks:
        type: integer
      Shared Read Blocks:
        type: integer
      Shared Written Blocks:
        type: integer
      Sort Key:
        items:
          type: string
        type: array
      Sort Method:
        type: string
      Sort Space Type:
        type: string
      Sort Space Used:
        type: integer
      Startup Cost:
        type: number
      Temp Read Blocks:
        type: integer
      Temp Written Blocks:
        type: integer
      Total Cost:
        type: number
    required:
    - Actual Loops
    - Actual Rows
    - Actual Startup Time
    - Actual Total Time
    - Async Capable
    - Local Dirtied Blocks
    - Local Hit Blocks
    - Local Read Blocks
    - Local Written Blocks
    - Node Type
    - Output
    - Parallel Aware
    - Plan Rows
    - Plan Width
    - Shared Dirtied Blocks
    - Shared Hit Blocks
    - Shared Read Blocks
    - Shared Written Blocks
    - Startup Cost
    - Temp Read Blocks
    - Temp Written Blocks
    - Total Cost
    type: object
  Planning:
    properties:
      Local Dirtied Blocks:
        type: integer
      Local Hit Blocks:
        type: integer
      Local Read Blocks:
        type: integer
      Local Written Blocks:
        type: integer
      Shared Dirtied Blocks:
        type: integer
      Shared Hit Blocks:
        type: integer
      Shared Read Blocks:
        type: integer
      Shared Written Blocks:
        type: integer
      Temp Read Blocks:
        type: integer
      Temp Written Blocks:
        type: integer
    required:
    - Local Dirtied Blocks
    - Local Hit Blocks
    - Local Read Blocks
    - Local Written Blocks
    - Shared Dirtied Blocks
    - Shared Hit Blocks
    - Shared Read Blocks
    - Shared Written Blocks
    - Temp Read Blocks
    - Temp Written Blocks
    type: object
type: array