500 on pghero dashboard when query stats enabled about pghero

[ankuriitk]

Its happening to us too!

[ankuriitk]

NoMethodError: undefined method []' for nil:NilClass pghero/methods/suggested_indexes.rb:121:inblock (2 levels) in best_index_helper'
columns = (where + sort).map { |c| c[:column] }.uniq
pghero/methods/suggested_indexes.rb:121:in map' columns = (where + sort).map { |c| c[:column] }.uniq pghero/methods/suggested_indexes.rb:121:inblock in best_index_helper'
columns = (where + sort).map { |c| c[:column] }.uniq
pghero/methods/suggested_indexes.rb:103:in each' parts.each do |statement, structure| pghero/methods/suggested_indexes.rb:103:inbest_index_helper'
parts.each do |statement, structure|
...
(104 additional frame(s) were not displayed)

[kebling]

I am also experiencing this issue.

[ankane]

I'm having trouble reproducing without the specific query it's trying to parse, but I found a potential cause. Try master to see if it fixes the error.

[kebling]

Still having the same error. The last query executed is below, which returns results when I run it manually:

SELECT schemaname AS schema, tablename AS table, attname AS column, null_frac, n_distinct FROM pg_stats WHERE tablename IN (NULL, 'list', 'of', 'some', 'table', 'names') AND schemaname = 'public' ORDER BY 1, 2, 3

[ankane]

Try the debug_suggested_indexes branch. It'll output the statement it's trying to parse.

[kebling]

Actually, your 2nd attempt fixed it, and I didn't realize you committed it until I checked out the debug_suggested_indexes branch. Everything is working properly on my end now. Thanks so much!