Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Parallel Sequential Scan "Workers" array objects displayed as [Object object] #26

Open
coryfoo opened this issue Feb 24, 2017 · 1 comment

Comments

@coryfoo
Copy link

coryfoo commented Feb 24, 2017

When a query plan results in using a parallel sequential scan, there is an array of objects with statistics for each worker.

Here is a real example from a plan:

"Plans": [
  {
    ...,
    "Workers":[
      {
        "Worker Number": 0,
        "Actual Startup Time": 130407.893,
        "Actual Total Time": 490126.071,
        "Actual Rows": 86,
        "Actual Loops": 1,
        "Shared Hit Blocks": 2945119,
        "Shared Read Blocks": 2804690,
        "Shared Dirtied Blocks": 0,
        "Shared Written Blocks": 0,
        "Local Hit Blocks": 0,
        "Local Read Blocks": 0,
        "Local Dirtied Blocks": 0,
        "Local Written Blocks": 0,
        "Temp Read Blocks": 5602,
        "Temp Written Blocks": 5596
      },
      {
        "Worker Number": 1,
        "Actual Startup Time": 138177.085,
        "Actual Total Time": 529953.618,
        "Actual Rows": 96,
        "Actual Loops": 1,
        "Shared Hit Blocks": 3406372,
        "Shared Read Blocks": 3259171,
        "Shared Dirtied Blocks": 0,
        "Shared Written Blocks": 0,
        "Local Hit Blocks": 0,
        "Local Read Blocks": 0,
        "Local Dirtied Blocks": 0,
        "Local Written Blocks": 0,
        "Temp Read Blocks": 5602,
        "Temp Written Blocks": 5596
      }
    ]
  }
]
@jfinzel
Copy link

jfinzel commented May 25, 2017

Also, with parallel plans, the worker nodes are summed up to create a much higher duration than is actual.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants