Comments (2)
Can you please share the plan for the same query in JSON format?
from pev2.
Never mind, here's the equivalent in JSON:
explain (FORMAT JSON) select count(*) from bigtable ;
QUERY PLAN
---------------------------------------------------
[ +
{ +
"Plan": { +
"Node Type": "Aggregate", +
"Strategy": "Plain", +
"Partial Mode": "Finalize", +
"Parallel Aware": false, +
"Startup Cost": 416238.55, +
"Total Cost": 416238.56, +
"Plan Rows": 1, +
"Plan Width": 8, +
"Plans": [ +
{ +
"Node Type": "Gather", +
"Parent Relationship": "Outer", +
"Parallel Aware": false, +
"Startup Cost": 416238.12, +
"Total Cost": 416238.54, +
"Plan Rows": 4, +
"Plan Width": 8, +
"Workers Planned": 4, +
"Single Copy": false, +
"Plans": [ +
{ +
"Node Type": "Aggregate", +
"Strategy": "Plain", +
"Partial Mode": "Partial", +
"Parent Relationship": "Outer", +
"Parallel Aware": false, +
"Startup Cost": 415238.12, +
"Total Cost": 415238.14, +
"Plan Rows": 1, +
"Plan Width": 8, +
"Plans": [ +
{ +
"Node Type": "Seq Scan", +
"Parent Relationship": "Outer",+
"Parallel Aware": true, +
"Relation Name": "bigtable", +
"Alias": "bigtable", +
"Startup Cost": 0.00, +
"Total Cost": 380863.10, +
"Plan Rows": 13750010, +
"Plan Width": 0 +
} +
] +
} +
] +
} +
] +
} +
} +
]
(1 ligne)
Temps : 1,098 ms
from pev2.
Related Issues (20)
- Multiple versions of a plan
- FR: vscode extension HOT 1
- Dashboard to automatically visualize long-running query plans
- Can't parse plan on Firefox (large value for Index Cond)
- Stand alone editor ? HOT 1
- Copy only the plan node
- Add the ability to destroy all plans easily
- Huge constraint delays are not shown (due to missing index) HOT 5
- Incorrect calculation of the total number of estimated / real rows in some parallel plans HOT 3
- Visualization bug HOT 2
- Copying stats table lines
- Incorrectly parsed text plan
- Convert explain json to text
- Emphasize filter HOT 1
- @types packages shouldn't be in dependencies but devDependencies instead
- Add integration tests
- Migrate existing tests fro mjest to vitest
- Having issues with POST requests from pgBadger reports
- Execution time much bigger than the first node total runtime
- Diagram doesn't tell if a node is "Parallel" HOT 1
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 pev2.