Comments (3)
Hi @jonathan-wondereur, thanks for sharing, but this doesn't seem specific to PgHero.
from pghero.
Sorry, I forgot to include details of the error:
PG::UndefinedColumn: ERROR: column "total_time" does not exist (PG::UndefinedColumn)
LINE 1: ...S query, queryid AS query_hash, rolname AS user, (total_time...
{
name: null,
sql: WITH query_stats AS ( SELECT LEFT(query, 10000) AS query, queryid AS query_hash, rolname AS user, (total_time / 1000 / 60) AS total_minutes, (total_time / calls) AS average_time, calls FROM pg_stat_statements INNER JOIN pg_database ON pg_database.oid = pg_stat_statements.dbid INNER JOIN pg_roles ON pg_roles.oid = pg_stat_statements.userid WHERE calls > 0 AND pg_database.datname = current_database() ) SELECT query, query AS explainable_query, query_hash, query_stats.user, total_minutes, average_time, calls, total_minutes * 100.0 / (SELECT SUM(total_minutes) FROM query_stats) AS total_percent, (SELECT SUM(total_minutes) FROM query_stats) AS all_queries_total_minutes FROM query_stats ORDER BY "total_minutes" DESC LIMIT 100 /*pghero*/,
statement_name: null
}
from pghero.
from pghero.
Related Issues (20)
- 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
- [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
- `undefined method 'symbolize_keys'` when running on Rails' main branch HOT 2
- GCP stats not working anymore HOT 1
- Known CVE's in current docker image HOT 1
- PgHero.capture_space_stats fails with "No unique index found for #{name_or_columns}" HOT 5
- How to visualize the query stats stored on "pghero_query_stats" HOT 4
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.