175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
|
# File 'lib/pghero/methods/query_stats.rb', line 175
def query_hash_stats(query_hash, user: nil, current: false)
if historical_query_stats_enabled? && supports_query_hash?
start_at = 24.hours.ago
stats = select_all_stats " SELECT\n captured_at,\n total_time / 1000 / 60 AS total_minutes,\n (total_time / calls) AS average_time,\n calls,\n (SELECT regexp_matches(query, '.*/\\\\*(.+?)\\\\*/'))[1] AS origin\n FROM\n pghero_query_stats\n WHERE\n database = \#{quote(id)}\n AND captured_at >= \#{quote(start_at)}\n AND query_hash = \#{quote(query_hash)}\n \#{user ? \"AND \\\"user\\\" = \#{quote(user)}\" : \"\"}\n ORDER BY\n 1 ASC\n SQL\n if current\n captured_at = Time.current\n current_stats = current_query_stats(query_hash: query_hash, user: user, origin: true)\n current_stats.each do |r|\n r[:captured_at] = captured_at\n end\n stats += current_stats\n end\n stats\n else\n raise NotEnabled, \"Query hash stats not enabled\"\n end\nend\n"
|