Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [
- {
- "Plan": {
- "Node Type": "Gather Merge",
- "Parallel Aware": false,
- "Actual Startup Time": 1720.052,
- "Actual Total Time": 4252.290,
- "Actual Rows": 10000000,
- "Actual Loops": 1,
- "Output": ["c1", "c2"],
- "Workers Planned": 2,
- "Workers Launched": 2,
- "Plans": [
- {
- "Node Type": "Sort",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Actual Startup Time": 1558.638,
- "Actual Total Time": 2127.522,
- "Actual Rows": 3333333,
- "Actual Loops": 3,
- "Output": ["c1", "c2"],
- "Sort Key": ["t1.c1"],
- "Sort Method": "external merge",
- "Sort Space Used": 126152,
- "Sort Space Type": "Disk",
- "Workers": [
- {
- "Worker Number": 0,
- "Sort Method": "external merge",
- "Sort Space Used": 73552,
- "Sort Space Type": "Disk"
- },
- {
- "Worker Number": 1,
- "Sort Method": "external merge",
- "Sort Space Used": 73320,
- "Sort Space Type": "Disk"
- }
- ],
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 1487.846,
- "Actual Total Time": 1996.879,
- "Actual Rows": 2692973,
- "Actual Loops": 1
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 1468.256,
- "Actual Total Time": 2012.744,
- "Actual Rows": 2684443,
- "Actual Loops": 1
- }
- ],
- "Plans": [
- {
- "Node Type": "Seq Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": true,
- "Relation Name": "t1",
- "Schema": "public",
- "Alias": "t1",
- "Actual Startup Time": 0.211,
- "Actual Total Time": 372.858,
- "Actual Rows": 3333333,
- "Actual Loops": 3,
- "Output": ["c1", "c2"],
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.029,
- "Actual Total Time": 368.356,
- "Actual Rows": 2692973,
- "Actual Loops": 1
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.033,
- "Actual Total Time": 368.874,
- "Actual Rows": 2684443,
- "Actual Loops": 1
- }
- ]
- }
- ]
- }
- ]
- },
- "Planning Time": 0.170,
- "Triggers": [
- ],
- "Execution Time": 4695.141
- }
- ]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement