Comments (7)
Its happening to us too!
from pghero.
NoMethodError: undefined method []' for nil:NilClass pghero/methods/suggested_indexes.rb:121:in
block (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:in
block 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:in
best_index_helper'
parts.each do |statement, structure|
...
(104 additional frame(s) were not displayed)
from pghero.
I am also experiencing this issue.
from pghero.
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.
from pghero.
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
from pghero.
Try the debug_suggested_indexes
branch. It'll output the statement it's trying to parse.
from pghero.
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!
from pghero.
Related Issues (20)
- [Idea] arm64 Docker arch support HOT 2
- [Idea] list cache/disk utilization for each table HOT 1
- Error in SQL explain HOT 1
- Filter for user on queries tab
- [Idea] Show transaction duration on "Live Queries" page HOT 1
- Upgrade Alpine Linux image HOT 3
- [Idea] Allow sorting of tables on the Maintenance tab
- Issuing a new Release (e.g. v3.3.5) HOT 1
- Multi-architecture images for tags other than `latest` HOT 2
- pghero completed 500 internal error throwing plaintext password HOT 2
- GCP Cloud SQL System Stats not enable. HOT 1
- ArgumentError in `slow_queries` HOT 1
- Unable to show space graph on Azure Flexible Postgres Server if storage auto-growth is enabled HOT 1
- There are no graphs HOT 1
- Upgrading PGSQL Version HOT 3
- [Idea] Live queries parameters HOT 1
- Anonymize explain input
- Support for Debian12 HOT 2
- [Idea] Enable/Disable Option for "Kill" Button
- Unsolicited Email HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pghero.