[ { "Plan": { "Node Type": "Nested Loop", "Parallel Aware": false, "Join Type": "Left", "Startup Cost": 22.44, "Total Cost": 3829.68, "Plan Rows": 279, "Plan Width": 80, "Actual Startup Time": 0.092, "Actual Total Time": 19.788, "Actual Rows": 280, "Actual Loops": 1, "Output": ["workspace_builds.workspace_id", "workspace_builds.template_version_id", "workspace_builds.job_id", "workspace_builds.template_version_preset_id", "workspace_builds.transition", "workspace_builds.created_at", "provisioner_jobs.job_status"], "Inner Unique": false, "Shared Hit Blocks": 2038, "Shared Read Blocks": 0, "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": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Bitmap Heap Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Relation Name": "workspaces", "Schema": "public", "Alias": "workspaces", "Startup Cost": 21.74, "Total Cost": 118.53, "Plan Rows": 279, "Plan Width": 16, "Actual Startup Time": 0.066, "Actual Total Time": 0.341, "Actual Rows": 280, "Actual Loops": 1, "Output": ["workspaces.id"], "Recheck Cond": "(NOT workspaces.deleted)", "Rows Removed by Index Recheck": 0, "Exact Heap Blocks": 74, "Lossy Heap Blocks": 0, "Shared Hit Blocks": 78, "Shared Read Blocks": 0, "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": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Index Name": "workspace_template_id_idx", "Startup Cost": 0.00, "Total Cost": 21.67, "Plan Rows": 279, "Plan Width": 0, "Actual Startup Time": 0.047, "Actual Total Time": 0.047, "Actual Rows": 445, "Actual Loops": 1, "Shared Hit Blocks": 4, "Shared Read Blocks": 0, "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": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000 } ] }, { "Node Type": "Limit", "Parent Relationship": "Inner", "Parallel Aware": false, "Startup Cost": 0.70, "Total Cost": 13.28, "Plan Rows": 1, "Plan Width": 84, "Actual Startup Time": 0.044, "Actual Total Time": 0.044, "Actual Rows": 1, "Actual Loops": 280, "Output": ["workspace_builds.workspace_id", "workspace_builds.template_version_id", "workspace_builds.job_id", "workspace_builds.template_version_preset_id", "workspace_builds.transition", "workspace_builds.created_at", "provisioner_jobs.job_status", "workspace_builds.build_number"], "Shared Hit Blocks": 1960, "Shared Read Blocks": 0, "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": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Join Type": "Inner", "Startup Cost": 0.70, "Total Cost": 176.78, "Plan Rows": 14, "Plan Width": 84, "Actual Startup Time": 0.043, "Actual Total Time": 0.043, "Actual Rows": 1, "Actual Loops": 280, "Output": ["workspace_builds.workspace_id", "workspace_builds.template_version_id", "workspace_builds.job_id", "workspace_builds.template_version_preset_id", "workspace_builds.transition", "workspace_builds.created_at", "provisioner_jobs.job_status", "workspace_builds.build_number"], "Inner Unique": true, "Shared Hit Blocks": 1960, "Shared Read Blocks": 0, "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": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Index Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Scan Direction": "Backward", "Index Name": "workspace_builds_workspace_id_build_number_key", "Relation Name": "workspace_builds", "Schema": "public", "Alias": "workspace_builds", "Startup Cost": 0.41, "Total Cost": 60.47, "Plan Rows": 14, "Plan Width": 80, "Actual Startup Time": 0.005, "Actual Total Time": 0.005, "Actual Rows": 1, "Actual Loops": 280, "Output": ["workspace_builds.id", "workspace_builds.created_at", "workspace_builds.updated_at", "workspace_builds.workspace_id", "workspace_builds.template_version_id", "workspace_builds.build_number", "workspace_builds.transition", "workspace_builds.initiator_id", "workspace_builds.provisioner_state", "workspace_builds.job_id", "workspace_builds.deadline", "workspace_builds.reason", "workspace_builds.daily_cost", "workspace_builds.max_deadline", "workspace_builds.template_version_preset_id"], "Index Cond": "(workspace_builds.workspace_id = workspaces.id)", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1120, "Shared Read Blocks": 0, "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": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000 }, { "Node Type": "Index Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "provisioner_jobs_pkey", "Relation Name": "provisioner_jobs", "Schema": "public", "Alias": "provisioner_jobs", "Startup Cost": 0.29, "Total Cost": 8.31, "Plan Rows": 1, "Plan Width": 20, "Actual Startup Time": 0.004, "Actual Total Time": 0.004, "Actual Rows": 1, "Actual Loops": 280, "Output": ["provisioner_jobs.id", "provisioner_jobs.created_at", "provisioner_jobs.updated_at", "provisioner_jobs.started_at", "provisioner_jobs.canceled_at", "provisioner_jobs.completed_at", "provisioner_jobs.error", "provisioner_jobs.organization_id", "provisioner_jobs.initiator_id", "provisioner_jobs.provisioner", "provisioner_jobs.storage_method", "provisioner_jobs.type", "provisioner_jobs.input", "provisioner_jobs.worker_id", "provisioner_jobs.file_id", "provisioner_jobs.tags", "provisioner_jobs.error_code", "provisioner_jobs.trace_metadata", "provisioner_jobs.job_status"], "Index Cond": "(provisioner_jobs.id = workspace_builds.job_id)", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 840, "Shared Read Blocks": 0, "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": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000 } ] } ] } ] }, "Planning": { "Shared Hit Blocks": 381, "Shared Read Blocks": 0, "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": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000 }, "Planning Time": 11.078, "Triggers": [ ], "Execution Time": 20.208 } ]