Skip to content

Instantly share code, notes, and snippets.

@sulami

sulami/9.5 m4.2xlarge.json

Created February 1, 2021 16:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sulami/b8c3196c314b220eb5862f374570f43d to your computer and use it in GitHub Desktop.
Save sulami/b8c3196c314b220eb5862f374570f43d to your computer and use it in GitHub Desktop.
Download ZIP
DB benchmarks
Raw
9.5 m4.2xlarge.json
[
{
"Plan": {
"Node Type": "ModifyTable",
"Operation": "Insert",
"Relation Name": "build_jobs",
"Alias": "build_jobs",
"Startup Cost": 0.00,
"Total Cost": 0.02,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 1.006,
"Actual Total Time": 1.006,
"Actual Rows": 0,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Result",
"Parent Relationship": "Member",
"Startup Cost": 0.00,
"Total Cost": 0.02,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.009,
"Actual Total Time": 0.010,
"Actual Rows": 1,
"Actual Loops": 1
}
]
},
"Planning Time": 0.045,
"Triggers": [
],
"Execution Time": 1.111
}
]
[
{
"Plan": {
"Node Type": "ModifyTable",
"Operation": "Insert",
"Relation Name": "unsatisfieds",
"Alias": "unsatisfieds",
"Startup Cost": 0.00,
"Total Cost": 0.02,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.146,
"Actual Total Time": 0.146,
"Actual Rows": 0,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Result",
"Parent Relationship": "Member",
"Startup Cost": 0.00,
"Total Cost": 0.02,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.004,
"Actual Total Time": 0.005,
"Actual Rows": 1,
"Actual Loops": 1
}
]
},
"Planning Time": 0.010,
"Triggers": [
],
"Execution Time": 0.209
}
]
[
{
"Plan": {
"Node Type": "ModifyTable",
"Operation": "Insert",
"Relation Name": "jobs",
"Alias": "jobs",
"Startup Cost": 0.00,
"Total Cost": 0.02,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 1.052,
"Actual Total Time": 1.052,
"Actual Rows": 0,
"Actual Loops": 1,
"Conflict Resolution": "UPDATE",
"Conflict Arbiter Indexes": ["jobs_pkey"],
"Conflict Filter": "((jobs.job_id)::text = '76d2ff9a-d245-4ce8-a05e-a901656bc2a8'::text)",
"Rows Removed by Conflict Filter": 0,
"Tuples Inserted": 0,
"Conflicting Tuples": 1,
"Plans": [
{
"Node Type": "Result",
"Parent Relationship": "Member",
"Startup Cost": 0.00,
"Total Cost": 0.02,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.007,
"Actual Total Time": 0.008,
"Actual Rows": 1,
"Actual Loops": 1
}
]
},
"Planning Time": 0.076,
"Triggers": [
{
"Trigger Name": "set_job_updated_at",
"Relation": "jobs",
"Time": 0.209,
"Calls": 1
}
],
"Execution Time": 1.110
}
]
[
{
"Plan": {
"Node Type": "ModifyTable",
"Operation": "Insert",
"Relation Name": "workflows",
"Alias": "workflows",
"Startup Cost": 0.00,
"Total Cost": 0.02,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 108.406,
"Actual Total Time": 108.406,
"Actual Rows": 0,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Result",
"Parent Relationship": "Member",
"Startup Cost": 0.00,
"Total Cost": 0.02,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.004,
"Actual Total Time": 0.005,
"Actual Rows": 1,
"Actual Loops": 1
}
]
},
"Planning Time": 0.017,
"Triggers": [
],
"Execution Time": 108.561
}
]
[
{
"Plan": {
"Node Type": "ModifyTable",
"Operation": "Insert",
"Relation Name": "workflow_jobs",
"Alias": "workflow_jobs",
"Startup Cost": 0.00,
"Total Cost": 0.02,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.624,
"Actual Total Time": 0.624,
"Actual Rows": 0,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Result",
"Parent Relationship": "Member",
"Startup Cost": 0.00,
"Total Cost": 0.02,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.003,
"Actual Total Time": 0.003,
"Actual Rows": 1,
"Actual Loops": 1
}
]
},
"Planning Time": 0.022,
"Triggers": [
{
"Trigger Name": "RI_ConstraintTrigger_c_17351",
"Constraint Name": "workflow_jobs_workflow_id_fkey",
"Relation": "workflow_jobs",
"Time": 1.114,
"Calls": 1
},
{
"Trigger Name": "RI_ConstraintTrigger_c_17356",
"Constraint Name": "workflow_jobs_job_id_fkey",
"Relation": "workflow_jobs",
"Time": 2.730,
"Calls": 1
}
],
"Execution Time": 4.607
}
]
[
{
"Plan": {
"Node Type": "ModifyTable",
"Operation": "Insert",
"Relation Name": "build_details",
"Alias": "build_details",
"Startup Cost": 0.00,
"Total Cost": 0.01,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 1.455,
"Actual Total Time": 1.455,
"Actual Rows": 0,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Result",
"Parent Relationship": "Member",
"Startup Cost": 0.00,
"Total Cost": 0.01,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.002,
"Actual Total Time": 0.003,
"Actual Rows": 1,
"Actual Loops": 1
}
]
},
"Planning Time": 0.019,
"Triggers": [
{
"Trigger Name": "RI_ConstraintTrigger_c_79029405",
"Constraint Name": "build_details_workflow_id_fkey",
"Relation": "build_details",
"Time": 0.328,
"Calls": 1
}
],
"Execution Time": 1.854
}
]
[
{
"Plan": {
"Node Type": "ModifyTable",
"Operation": "Insert",
"Relation Name": "job_approved_events",
"Alias": "job_approved_events",
"Startup Cost": 0.00,
"Total Cost": 0.02,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.088,
"Actual Total Time": 0.088,
"Actual Rows": 0,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Result",
"Parent Relationship": "Member",
"Startup Cost": 0.00,
"Total Cost": 0.02,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.004,
"Actual Total Time": 0.004,
"Actual Rows": 1,
"Actual Loops": 1
}
]
},
"Planning Time": 0.010,
"Triggers": [
{
"Trigger Name": "RI_ConstraintTrigger_c_13090458",
"Constraint Name": "job_approved_events_job_id_fkey",
"Relation": "job_approved_events",
"Time": 0.137,
"Calls": 1
}
],
"Execution Time": 0.270
}
]
[
{
"Plan": {
"Node Type": "ModifyTable",
"Operation": "Insert",
"Relation Name": "job_satisfied_events",
"Alias": "job_satisfied_events",
"Startup Cost": 0.00,
"Total Cost": 0.02,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.029,
"Actual Total Time": 0.029,
"Actual Rows": 0,
"Actual Loops": 1,
"Conflict Resolution": "NOTHING",
"Conflict Arbiter Indexes": ["job_satisfied_events_job_id_key"],
"Tuples Inserted": 0,
"Conflicting Tuples": 1,
"Plans": [
{
"Node Type": "Result",
"Parent Relationship": "Member",
"Startup Cost": 0.00,
"Total Cost": 0.02,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.003,
"Actual Total Time": 0.003,
"Actual Rows": 1,
"Actual Loops": 1
}
]
},
"Planning Time": 0.086,
"Triggers": [
],
"Execution Time": 0.054
}
]
[
{
"Plan": {
"Node Type": "ModifyTable",
"Operation": "Insert",
"Relation Name": "job_ended_events",
"Alias": "job_ended_events",
"Startup Cost": 0.00,
"Total Cost": 0.02,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.026,
"Actual Total Time": 0.026,
"Actual Rows": 0,
"Actual Loops": 1,
"Conflict Resolution": "NOTHING",
"Conflict Arbiter Indexes": ["job_ended_events_job_id_key"],
"Tuples Inserted": 0,
"Conflicting Tuples": 1,
"Plans": [
{
"Node Type": "Result",
"Parent Relationship": "Member",
"Startup Cost": 0.00,
"Total Cost": 0.02,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.003,
"Actual Total Time": 0.004,
"Actual Rows": 1,
"Actual Loops": 1
}
]
},
"Planning Time": 0.060,
"Triggers": [
],
"Execution Time": 0.041
}
]
[
{
"Plan": {
"Node Type": "ModifyTable",
"Operation": "Insert",
"Relation Name": "workflow_canceling_events",
"Alias": "workflow_canceling_events",
"Startup Cost": 0.00,
"Total Cost": 0.02,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.125,
"Actual Total Time": 0.125,
"Actual Rows": 0,
"Actual Loops": 1,
"Conflict Resolution": "NOTHING",
"Conflict Arbiter Indexes": ["workflow_canceling_events_workflow_id_key"],
"Tuples Inserted": 1,
"Conflicting Tuples": 0,
"Plans": [
{
"Node Type": "Result",
"Parent Relationship": "Member",
"Startup Cost": 0.00,
"Total Cost": 0.02,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.003,
"Actual Total Time": 0.004,
"Actual Rows": 1,
"Actual Loops": 1
}
]
},
"Planning Time": 0.036,
"Triggers": [
{
"Trigger Name": "RI_ConstraintTrigger_c_13479516",
"Constraint Name": "workflow_canceling_events_workflow_id_fkey",
"Relation": "workflow_canceling_events",
"Time": 0.163,
"Calls": 1
}
],
"Execution Time": 0.303
}
]
[
{
"Plan": {
"Node Type": "ModifyTable",
"Operation": "Insert",
"Relation Name": "workflow_created_events",
"Alias": "workflow_created_events",
"Startup Cost": 0.00,
"Total Cost": 0.02,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.769,
"Actual Total Time": 0.769,
"Actual Rows": 0,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Result",
"Parent Relationship": "Member",
"Startup Cost": 0.00,
"Total Cost": 0.02,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.007,
"Actual Total Time": 0.008,
"Actual Rows": 1,
"Actual Loops": 1
}
]
},
"Planning Time": 0.020,
"Triggers": [
{
"Trigger Name": "RI_ConstraintTrigger_c_13392315",
"Constraint Name": "workflow_created_events_workflow_id_fkey",
"Relation": "workflow_created_events",
"Time": 0.160,
"Calls": 1
}
],
"Execution Time": 1.010
}
]
[
{
"Plan": {
"Node Type": "ModifyTable",
"Operation": "Insert",
"Relation Name": "workflow_errored_events",
"Alias": "workflow_errored_events",
"Startup Cost": 0.00,
"Total Cost": 0.02,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.076,
"Actual Total Time": 0.076,
"Actual Rows": 0,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Result",
"Parent Relationship": "Member",
"Startup Cost": 0.00,
"Total Cost": 0.02,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.004,
"Actual Total Time": 0.005,
"Actual Rows": 1,
"Actual Loops": 1
}
]
},
"Planning Time": 0.010,
"Triggers": [
{
"Trigger Name": "RI_ConstraintTrigger_c_13552389",
"Constraint Name": "workflow_errored_events_workflow_id_fkey",
"Relation": "workflow_errored_events",
"Time": 0.165,
"Calls": 1
}
],
"Execution Time": 0.283
}
]
[
{
"Plan": {
"Node Type": "ModifyTable",
"Operation": "Insert",
"Relation Name": "auto_cancel_data",
"Alias": "auto_cancel_data",
"Startup Cost": 0.00,
"Total Cost": 0.01,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.082,
"Actual Total Time": 0.082,
"Actual Rows": 0,
"Actual Loops": 1,
"Conflict Resolution": "NOTHING",
"Conflict Arbiter Indexes": ["auto_cancel_data_pkey"],
"Tuples Inserted": 1,
"Conflicting Tuples": 0,
"Plans": [
{
"Node Type": "Result",
"Parent Relationship": "Member",
"Startup Cost": 0.00,
"Total Cost": 0.01,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.003,
"Actual Total Time": 0.004,
"Actual Rows": 1,
"Actual Loops": 1
}
]
},
"Planning Time": 0.133,
"Triggers": [
{
"Trigger Name": "RI_ConstraintTrigger_c_27452373",
"Constraint Name": "auto_cancel_data_workflow_id_fkey",
"Relation": "auto_cancel_data",
"Time": 0.157,
"Calls": 1
}
],
"Execution Time": 0.271
}
]
[
{
"Plan": {
"Node Type": "ModifyTable",
"Operation": "Update",
"Relation Name": "build_jobs",
"Alias": "build_jobs",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 47,
"Actual Startup Time": 0.013,
"Actual Total Time": 0.013,
"Actual Rows": 0,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Scan Direction": "Forward",
"Index Name": "build_jobs_pkey",
"Relation Name": "build_jobs",
"Alias": "build_jobs",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 47,
"Actual Startup Time": 0.013,
"Actual Total Time": 0.013,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((build_id)::text = '436c0aab-8b48-4892-b00d-e540b5e193d8'::text)",
"Rows Removed by Index Recheck": 0
}
]
},
"Planning Time": 0.855,
"Triggers": [
],
"Execution Time": 0.031
}
]
[
{
"Plan": {
"Node Type": "ModifyTable",
"Operation": "Update",
"Relation Name": "jobs",
"Alias": "jobs",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 413,
"Actual Startup Time": 0.106,
"Actual Total Time": 0.106,
"Actual Rows": 0,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Scan Direction": "Forward",
"Index Name": "jobs_pkey",
"Relation Name": "jobs",
"Alias": "jobs",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 413,
"Actual Startup Time": 0.035,
"Actual Total Time": 0.037,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((job_id)::text = '76d2ff9a-d245-4ce8-a05e-a901656bc2a8'::text)",
"Rows Removed by Index Recheck": 0
}
]
},
"Planning Time": 0.164,
"Triggers": [
{
"Trigger Name": "set_job_updated_at",
"Relation": "jobs",
"Time": 0.033,
"Calls": 1
}
],
"Execution Time": 0.146
}
]
[
{
"Plan": {
"Node Type": "ModifyTable",
"Operation": "Update",
"Relation Name": "auto_cancel_data",
"Alias": "auto_cancel_data",
"Startup Cost": 344.58,
"Total Cost": 346.80,
"Plan Rows": 1,
"Plan Width": 96,
"Actual Startup Time": 0.113,
"Actual Total Time": 0.113,
"Actual Rows": 0,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "InitPlan",
"Subplan Name": "InitPlan 1 (returns $1)",
"Join Type": "Inner",
"Startup Cost": 1.53,
"Total Cost": 22948.88,
"Plan Rows": 67,
"Plan Width": 0,
"Actual Startup Time": 0.055,
"Actual Total Time": 0.055,
"Actual Rows": 0,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Index Only Scan",
"Parent Relationship": "Outer",
"Scan Direction": "Forward",
"Index Name": "workflow_jobs_workflow_id_job_id_index",
"Relation Name": "workflow_jobs",
"Alias": "workflow_jobs",
"Startup Cost": 0.83,
"Total Cost": 331.60,
"Plan Rows": 7713,
"Plan Width": 37,
"Actual Startup Time": 0.031,
"Actual Total Time": 0.032,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "(workflow_id = 'b003e3b1-1845-45e1-bb6d-4e1c6c675a51'::text)",
"Rows Removed by Index Recheck": 0,
"Heap Fetches": 2
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Inner",
"Scan Direction": "Forward",
"Index Name": "jobs_pkey",
"Relation Name": "jobs",
"Alias": "jobs",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 37,
"Actual Startup Time": 0.018,
"Actual Total Time": 0.018,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((job_id)::text = (workflow_jobs.job_id)::text)",
"Rows Removed by Index Recheck": 0,
"Filter": "((status)::text = 'running'::text)",
"Rows Removed by Filter": 1
}
]
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Scan Direction": "Forward",
"Index Name": "auto_cancel_data_pkey",
"Relation Name": "auto_cancel_data",
"Alias": "auto_cancel_data",
"Startup Cost": 0.56,
"Total Cost": 2.77,
"Plan Rows": 1,
"Plan Width": 96,
"Actual Startup Time": 0.072,
"Actual Total Time": 0.072,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((workflow_id)::text = 'b003e3b1-1845-45e1-bb6d-4e1c6c675a51'::text)",
"Rows Removed by Index Recheck": 0
}
]
},
"Planning Time": 1.865,
"Triggers": [
],
"Execution Time": 0.160
}
]
[
{
"Plan": {
"Node Type": "Aggregate",
"Strategy": "Plain",
"Startup Cost": 1.82,
"Total Cost": 1.83,
"Plan Rows": 1,
"Plan Width": 25,
"Actual Startup Time": 0.021,
"Actual Total Time": 0.021,
"Actual Rows": 1,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Index Only Scan",
"Parent Relationship": "Outer",
"Scan Direction": "Forward",
"Index Name": "build_jobs_pkey",
"Relation Name": "build_jobs",
"Alias": "build_jobs",
"Startup Cost": 0.70,
"Total Cost": 1.82,
"Plan Rows": 1,
"Plan Width": 25,
"Actual Startup Time": 0.016,
"Actual Total Time": 0.016,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "(build_id = '6011cf9fd91a9a0c08995f54'::text)",
"Rows Removed by Index Recheck": 0,
"Heap Fetches": 0
}
]
},
"Planning Time": 0.042,
"Triggers": [
],
"Execution Time": 0.046
}
]
[
{
"Plan": {
"Node Type": "Index Scan",
"Scan Direction": "Forward",
"Index Name": "workflows_pkey",
"Relation Name": "workflows",
"Alias": "workflows",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 1303,
"Actual Startup Time": 0.015,
"Actual Total Time": 0.016,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((id)::text = 'b003e3b1-1845-45e1-bb6d-4e1c6c675a51'::text)",
"Rows Removed by Index Recheck": 0
},
"Planning Time": 0.105,
"Triggers": [
],
"Execution Time": 0.030
}
]
[
{
"Plan": {
"Node Type": "LockRows",
"Startup Cost": 0.70,
"Total Cost": 301.65,
"Plan Rows": 264,
"Plan Width": 43,
"Actual Startup Time": 0.020,
"Actual Total Time": 0.022,
"Actual Rows": 1,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Outer",
"Scan Direction": "Forward",
"Index Name": "unsatisfieds_unsatisfied_index",
"Relation Name": "unsatisfieds",
"Alias": "unsatisfieds",
"Startup Cost": 0.70,
"Total Cost": 299.01,
"Plan Rows": 264,
"Plan Width": 43,
"Actual Startup Time": 0.016,
"Actual Total Time": 0.018,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((unsatisfied)::text = '76d2ff9a-d245-4ce8-a05e-a901656bc2a8'::text)",
"Rows Removed by Index Recheck": 0
}
]
},
"Planning Time": 0.422,
"Triggers": [
],
"Execution Time": 0.038
}
]
[
{
"Plan": {
"Node Type": "Index Scan",
"Scan Direction": "Forward",
"Index Name": "unsatisfieds_unsatisfied_index",
"Relation Name": "unsatisfieds",
"Alias": "unsatisfieds",
"Startup Cost": 0.70,
"Total Cost": 299.01,
"Plan Rows": 264,
"Plan Width": 37,
"Actual Startup Time": 0.015,
"Actual Total Time": 0.016,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((unsatisfied)::text = '76d2ff9a-d245-4ce8-a05e-a901656bc2a8'::text)",
"Rows Removed by Index Recheck": 0
},
"Planning Time": 0.082,
"Triggers": [
],
"Execution Time": 0.047
}
]
[
{
"Plan": {
"Node Type": "Index Only Scan",
"Scan Direction": "Forward",
"Index Name": "unsatisfieds_pkey",
"Relation Name": "unsatisfieds",
"Alias": "unsatisfieds",
"Startup Cost": 0.70,
"Total Cost": 31.52,
"Plan Rows": 316,
"Plan Width": 37,
"Actual Startup Time": 0.029,
"Actual Total Time": 0.029,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "(job_id = '98f42947-9557-47e8-b304-5e9f6f23713b'::text)",
"Rows Removed by Index Recheck": 0,
"Heap Fetches": 1
},
"Planning Time": 0.075,
"Triggers": [
],
"Execution Time": 0.060
}
]
[
{
"Plan": {
"Node Type": "Nested Loop",
"Join Type": "Left",
"Startup Cost": 1.40,
"Total Cost": 5.85,
"Plan Rows": 1,
"Plan Width": 76,
"Actual Startup Time": 0.035,
"Actual Total Time": 0.047,
"Actual Rows": 1,
"Actual Loops": 1,
"Join Filter": "((build_jobs.job_id)::text = (jobs.job_id)::text)",
"Rows Removed by Join Filter": 0,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Outer",
"Scan Direction": "Forward",
"Index Name": "jobs_pkey",
"Relation Name": "jobs",
"Alias": "jobs",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 51,
"Actual Startup Time": 0.016,
"Actual Total Time": 0.017,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((job_id)::text = '76d2ff9a-d245-4ce8-a05e-a901656bc2a8'::text)",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Inner",
"Scan Direction": "Forward",
"Index Name": "build_jobs_job_id_index",
"Relation Name": "build_jobs",
"Alias": "build_jobs",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 62,
"Actual Startup Time": 0.015,
"Actual Total Time": 0.026,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((job_id)::text = '76d2ff9a-d245-4ce8-a05e-a901656bc2a8'::text)",
"Rows Removed by Index Recheck": 0
}
]
},
"Planning Time": 0.153,
"Triggers": [
],
"Execution Time": 0.069
}
]
[
{
"Plan": {
"Node Type": "Index Scan",
"Scan Direction": "Forward",
"Index Name": "jobs_pkey",
"Relation Name": "jobs",
"Alias": "jobs",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 59,
"Actual Startup Time": 0.016,
"Actual Total Time": 0.016,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((job_id)::text = '76d2ff9a-d245-4ce8-a05e-a901656bc2a8'::text)",
"Rows Removed by Index Recheck": 0
},
"Planning Time": 0.034,
"Triggers": [
],
"Execution Time": 0.029
}
]
[
{
"Plan": {
"Node Type": "Index Scan",
"Scan Direction": "Forward",
"Index Name": "unsatisfieds_unsatisfied_index",
"Relation Name": "unsatisfieds",
"Alias": "unsatisfieds",
"Startup Cost": 0.70,
"Total Cost": 299.01,
"Plan Rows": 264,
"Plan Width": 74,
"Actual Startup Time": 0.015,
"Actual Total Time": 0.015,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((unsatisfied)::text = '76d2ff9a-d245-4ce8-a05e-a901656bc2a8'::text)",
"Rows Removed by Index Recheck": 0
},
"Planning Time": 0.041,
"Triggers": [
],
"Execution Time": 0.027
}
]
[
{
"Plan": {
"Node Type": "Limit",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 37,
"Actual Startup Time": 0.018,
"Actual Total Time": 0.018,
"Actual Rows": 1,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Outer",
"Scan Direction": "Forward",
"Index Name": "build_jobs_pkey",
"Relation Name": "build_jobs",
"Alias": "build_jobs",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 37,
"Actual Startup Time": 0.016,
"Actual Total Time": 0.016,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((build_id)::text = '6011cf9fd91a9a0c08995f54'::text)",
"Rows Removed by Index Recheck": 0
}
]
},
"Planning Time": 0.035,
"Triggers": [
],
"Execution Time": 0.029
}
]
[
{
"Plan": {
"Node Type": "Limit",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 25,
"Actual Startup Time": 0.049,
"Actual Total Time": 0.050,
"Actual Rows": 1,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Outer",
"Scan Direction": "Forward",
"Index Name": "build_jobs_job_id_index",
"Relation Name": "build_jobs",
"Alias": "build_jobs",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 25,
"Actual Startup Time": 0.048,
"Actual Total Time": 0.048,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((job_id)::text = '76d2ff9a-d245-4ce8-a05e-a901656bc2a8'::text)",
"Rows Removed by Index Recheck": 0
}
]
},
"Planning Time": 0.067,
"Triggers": [
],
"Execution Time": 0.105
}
]
[
{
"Plan": {
"Node Type": "Limit",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 348,
"Actual Startup Time": 0.017,
"Actual Total Time": 0.018,
"Actual Rows": 1,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Outer",
"Scan Direction": "Forward",
"Index Name": "jobs_pkey",
"Relation Name": "jobs",
"Alias": "jobs",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 348,
"Actual Startup Time": 0.016,
"Actual Total Time": 0.016,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((job_id)::text = '76d2ff9a-d245-4ce8-a05e-a901656bc2a8'::text)",
"Rows Removed by Index Recheck": 0
}
]
},
"Planning Time": 0.034,
"Triggers": [
],
"Execution Time": 0.028
}
]
[
{
"Plan": {
"Node Type": "Limit",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 1267,
"Actual Startup Time": 0.016,
"Actual Total Time": 0.017,
"Actual Rows": 1,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Outer",
"Scan Direction": "Forward",
"Index Name": "build_details_workflow_id_index",
"Relation Name": "build_details",
"Alias": "build_details",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 1267,
"Actual Startup Time": 0.015,
"Actual Total Time": 0.015,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((workflow_id)::text = 'b003e3b1-1845-45e1-bb6d-4e1c6c675a51'::text)",
"Rows Removed by Index Recheck": 0
}
]
},
"Planning Time": 0.304,
"Triggers": [
],
"Execution Time": 0.028
}
]
[
{
"Plan": {
"Node Type": "Limit",
"Startup Cost": 15.52,
"Total Cost": 30.34,
"Plan Rows": 10,
"Plan Width": 45,
"Actual Startup Time": 0.024,
"Actual Total Time": 0.024,
"Actual Rows": 0,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Outer",
"Scan Direction": "Forward",
"Index Name": "workflows_vcs_url_branch_updated_at_no_project_index",
"Relation Name": "workflows",
"Alias": "workflows",
"Startup Cost": 0.70,
"Total Cost": 970.00,
"Plan Rows": 654,
"Plan Width": 45,
"Actual Startup Time": 0.024,
"Actual Total Time": 0.024,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "(((vcs_url)::text = 'https://github.invalid/circleci/circle'::text) AND ((project_analytics_id IS NULL) = true))",
"Rows Removed by Index Recheck": 0,
"Filter": "(project_analytics_id IS NULL)",
"Rows Removed by Filter": 0
}
]
},
"Planning Time": 0.142,
"Triggers": [
],
"Execution Time": 0.044
}
]
[
{
"Plan": {
"Node Type": "Limit",
"Startup Cost": 12.01,
"Total Cost": 23.32,
"Plan Rows": 10,
"Plan Width": 45,
"Actual Startup Time": 0.012,
"Actual Total Time": 0.012,
"Actual Rows": 0,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Outer",
"Scan Direction": "Forward",
"Index Name": "workflows_project_id_updated_at_branch_index",
"Relation Name": "workflows",
"Alias": "workflows",
"Startup Cost": 0.70,
"Total Cost": 9329.98,
"Plan Rows": 8247,
"Plan Width": 45,
"Actual Startup Time": 0.010,
"Actual Total Time": 0.011,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "(project_analytics_id = '9dac6e93-26ed-4d23-8e54-f6c27d9d874e'::uuid)",
"Rows Removed by Index Recheck": 0
}
]
},
"Planning Time": 0.072,
"Triggers": [
],
"Execution Time": 0.025
}
]
[
{
"Plan": {
"Node Type": "Limit",
"Startup Cost": 25.61,
"Total Cost": 50.53,
"Plan Rows": 10,
"Plan Width": 45,
"Actual Startup Time": 0.024,
"Actual Total Time": 0.024,
"Actual Rows": 0,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Outer",
"Scan Direction": "Forward",
"Index Name": "workflows_vcs_url_branch_updated_at_no_project_index",
"Relation Name": "workflows",
"Alias": "workflows",
"Startup Cost": 0.70,
"Total Cost": 474.07,
"Plan Rows": 190,
"Plan Width": 45,
"Actual Startup Time": 0.023,
"Actual Total Time": 0.023,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "(((vcs_url)::text = 'https://github.invalid/circleci/circle'::text) AND ((branch)::text = 'master'::text) AND ((project_analytics_id IS NULL) = true))",
"Rows Removed by Index Recheck": 0,
"Filter": "(project_analytics_id IS NULL)",
"Rows Removed by Filter": 0
}
]
},
"Planning Time": 0.158,
"Triggers": [
],
"Execution Time": 0.038
}
]
[
{
"Plan": {
"Node Type": "Limit",
"Startup Cost": 12.61,
"Total Cost": 24.53,
"Plan Rows": 10,
"Plan Width": 45,
"Actual Startup Time": 0.010,
"Actual Total Time": 0.010,
"Actual Rows": 0,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Outer",
"Scan Direction": "Forward",
"Index Name": "workflows_project_id_updated_at_branch_index",
"Relation Name": "workflows",
"Alias": "workflows",
"Startup Cost": 0.70,
"Total Cost": 2856.02,
"Plan Rows": 2396,
"Plan Width": 45,
"Actual Startup Time": 0.008,
"Actual Total Time": 0.008,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((project_analytics_id = '9dac6e93-26ed-4d23-8e54-f6c27d9d874e'::uuid) AND ((branch)::text = 'master'::text))",
"Rows Removed by Index Recheck": 0
}
]
},
"Planning Time": 0.096,
"Triggers": [
],
"Execution Time": 0.024
}
]
[
{
"Plan": {
"Node Type": "Aggregate",
"Strategy": "Plain",
"Startup Cost": 330.51,
"Total Cost": 330.52,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.021,
"Actual Total Time": 0.021,
"Actual Rows": 1,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Index Only Scan",
"Parent Relationship": "Outer",
"Scan Direction": "Forward",
"Index Name": "workflows_project_id",
"Relation Name": "workflows",
"Alias": "workflows",
"Startup Cost": 0.57,
"Total Cost": 309.89,
"Plan Rows": 8247,
"Plan Width": 0,
"Actual Startup Time": 0.018,
"Actual Total Time": 0.019,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "(project_analytics_id = '9dac6e93-26ed-4d23-8e54-f6c27d9d874e'::uuid)",
"Rows Removed by Index Recheck": 0,
"Heap Fetches": 1
}
]
},
"Planning Time": 0.056,
"Triggers": [
],
"Execution Time": 0.039
}
]
[
{
"Plan": {
"Node Type": "Aggregate",
"Strategy": "Plain",
"Startup Cost": 263.82,
"Total Cost": 263.83,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.011,
"Actual Total Time": 0.011,
"Actual Rows": 1,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Index Only Scan",
"Parent Relationship": "Outer",
"Scan Direction": "Forward",
"Index Name": "workflows_project_id_updated_at_branch_index",
"Relation Name": "workflows",
"Alias": "workflows",
"Startup Cost": 0.70,
"Total Cost": 257.83,
"Plan Rows": 2396,
"Plan Width": 0,
"Actual Startup Time": 0.007,
"Actual Total Time": 0.007,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((project_analytics_id = '9dac6e93-26ed-4d23-8e54-f6c27d9d874e'::uuid) AND (branch = 'master'::text))",
"Rows Removed by Index Recheck": 0,
"Heap Fetches": 1
}
]
},
"Planning Time": 0.076,
"Triggers": [
],
"Execution Time": 0.031
}
]
[
{
"Plan": {
"Node Type": "Limit",
"Startup Cost": 0.70,
"Total Cost": 1.84,
"Plan Rows": 1,
"Plan Width": 45,
"Actual Startup Time": 0.026,
"Actual Total Time": 0.026,
"Actual Rows": 1,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Outer",
"Scan Direction": "Forward",
"Index Name": "workflows_vcs_url_branch_name_created_at_index",
"Relation Name": "workflows",
"Alias": "wf",
"Startup Cost": 0.70,
"Total Cost": 153.27,
"Plan Rows": 133,
"Plan Width": 45,
"Actual Startup Time": 0.025,
"Actual Total Time": 0.025,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "(((vcs_url)::text = 'https://github.invalid/circleci/circle'::text) AND ((branch)::text = 'master'::text) AND ((name)::text = 'build'::text))",
"Rows Removed by Index Recheck": 0
}
]
},
"Planning Time": 0.154,
"Triggers": [
],
"Execution Time": 0.042
}
]
[
{
"Plan": {
"Node Type": "Index Scan",
"Scan Direction": "Forward",
"Index Name": "workflows_pkey",
"Relation Name": "workflows",
"Alias": "workflows",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 119,
"Actual Startup Time": 0.016,
"Actual Total Time": 0.017,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((id)::text = 'b003e3b1-1845-45e1-bb6d-4e1c6c675a51'::text)",
"Rows Removed by Index Recheck": 0
},
"Planning Time": 0.087,
"Triggers": [
],
"Execution Time": 0.029
}
]
[
{
"Plan": {
"Node Type": "Index Scan",
"Scan Direction": "Forward",
"Index Name": "workflows_pkey",
"Relation Name": "workflows",
"Alias": "workflows",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 45,
"Actual Startup Time": 0.016,
"Actual Total Time": 0.017,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((id)::text = 'b003e3b1-1845-45e1-bb6d-4e1c6c675a51'::text)",
"Rows Removed by Index Recheck": 0,
"Filter": "(created_at > (now() - '1 day'::interval))",
"Rows Removed by Filter": 0
},
"Planning Time": 0.097,
"Triggers": [
],
"Execution Time": 0.028
}
]
[
{
"Plan": {
"Node Type": "Nested Loop",
"Join Type": "Inner",
"Startup Cost": 2.81,
"Total Cost": 44250.72,
"Plan Rows": 305,
"Plan Width": 168,
"Actual Startup Time": 0.074,
"Actual Total Time": 0.078,
"Actual Rows": 1,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Join Type": "Inner",
"Startup Cost": 2.11,
"Total Cost": 43363.44,
"Plan Rows": 305,
"Plan Width": 197,
"Actual Startup Time": 0.059,
"Actual Total Time": 0.061,
"Actual Rows": 1,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Join Type": "Inner",
"Startup Cost": 1.41,
"Total Cost": 41991.78,
"Plan Rows": 472,
"Plan Width": 135,
"Actual Startup Time": 0.045,
"Actual Total Time": 0.046,
"Actual Rows": 1,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Outer",
"Scan Direction": "Forward",
"Index Name": "workflows_updated_at",
"Relation Name": "workflows",
"Alias": "workflows",
"Startup Cost": 0.58,
"Total Cost": 22.90,
"Plan Rows": 102,
"Plan Width": 98,
"Actual Startup Time": 0.027,
"Actual Total Time": 0.027,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((updated_at >= (now() - '00:01:00'::interval)) AND (updated_at <= now()))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Only Scan",
"Parent Relationship": "Inner",
"Scan Direction": "Forward",
"Index Name": "workflow_jobs_workflow_id_job_id_index",
"Relation Name": "workflow_jobs",
"Alias": "wj",
"Startup Cost": 0.83,
"Total Cost": 333.50,
"Plan Rows": 7796,
"Plan Width": 74,
"Actual Startup Time": 0.014,
"Actual Total Time": 0.014,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "(workflow_id = (workflows.id)::text)",
"Rows Removed by Index Recheck": 0,
"Heap Fetches": 1
}
]
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Inner",
"Scan Direction": "Forward",
"Index Name": "build_jobs_job_id_index",
"Relation Name": "build_jobs",
"Alias": "b",
"Startup Cost": 0.70,
"Total Cost": 2.90,
"Plan Rows": 1,
"Plan Width": 62,
"Actual Startup Time": 0.012,
"Actual Total Time": 0.013,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((job_id)::text = (wj.job_id)::text)",
"Rows Removed by Index Recheck": 0
}
]
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Inner",
"Scan Direction": "Forward",
"Index Name": "jobs_pkey",
"Relation Name": "jobs",
"Alias": "j",
"Startup Cost": 0.70,
"Total Cost": 2.90,
"Plan Rows": 1,
"Plan Width": 45,
"Actual Startup Time": 0.012,
"Actual Total Time": 0.013,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((job_id)::text = (b.job_id)::text)",
"Rows Removed by Index Recheck": 0
}
]
},
"Planning Time": 1.014,
"Triggers": [
],
"Execution Time": 0.132
}
]
[
{
"Plan": {
"Node Type": "Nested Loop",
"Join Type": "Inner",
"Startup Cost": 2.81,
"Total Cost": 43366.36,
"Plan Rows": 1,
"Plan Width": 143,
"Actual Startup Time": 0.050,
"Actual Total Time": 0.050,
"Actual Rows": 0,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Join Type": "Left",
"Startup Cost": 2.11,
"Total Cost": 43363.44,
"Plan Rows": 1,
"Plan Width": 135,
"Actual Startup Time": 0.050,
"Actual Total Time": 0.050,
"Actual Rows": 0,
"Actual Loops": 1,
"Filter": "(b.build_id IS NULL)",
"Rows Removed by Filter": 1,
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Join Type": "Inner",
"Startup Cost": 1.41,
"Total Cost": 41991.78,
"Plan Rows": 472,
"Plan Width": 135,
"Actual Startup Time": 0.033,
"Actual Total Time": 0.035,
"Actual Rows": 1,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Outer",
"Scan Direction": "Forward",
"Index Name": "workflows_updated_at",
"Relation Name": "workflows",
"Alias": "workflows",
"Startup Cost": 0.58,
"Total Cost": 22.90,
"Plan Rows": 102,
"Plan Width": 98,
"Actual Startup Time": 0.015,
"Actual Total Time": 0.016,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((updated_at >= (now() - '00:01:00'::interval)) AND (updated_at <= now()))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Only Scan",
"Parent Relationship": "Inner",
"Scan Direction": "Forward",
"Index Name": "workflow_jobs_workflow_id_job_id_index",
"Relation Name": "workflow_jobs",
"Alias": "wj",
"Startup Cost": 0.83,
"Total Cost": 333.50,
"Plan Rows": 7796,
"Plan Width": 74,
"Actual Startup Time": 0.014,
"Actual Total Time": 0.014,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "(workflow_id = (workflows.id)::text)",
"Rows Removed by Index Recheck": 0,
"Heap Fetches": 1
}
]
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Inner",
"Scan Direction": "Forward",
"Index Name": "build_jobs_job_id_index",
"Relation Name": "build_jobs",
"Alias": "b",
"Startup Cost": 0.70,
"Total Cost": 2.90,
"Plan Rows": 1,
"Plan Width": 62,
"Actual Startup Time": 0.012,
"Actual Total Time": 0.012,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((job_id)::text = (wj.job_id)::text)",
"Rows Removed by Index Recheck": 0
}
]
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Inner",
"Scan Direction": "Forward",
"Index Name": "jobs_pkey",
"Relation Name": "jobs",
"Alias": "j",
"Startup Cost": 0.70,
"Total Cost": 2.90,
"Plan Rows": 1,
"Plan Width": 45,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Index Cond": "((job_id)::text = (wj.job_id)::text)",
"Rows Removed by Index Recheck": 0,
"Filter": "(((status)::text = 'running'::text) AND ((type)::text = 'build'::text))",
"Rows Removed by Filter": 0
}
]
},
"Planning Time": 0.837,
"Triggers": [
],
"Execution Time": 0.105
}
]
[
{
"Plan": {
"Node Type": "Index Scan",
"Scan Direction": "Forward",
"Index Name": "job_approved_events_job_id_key",
"Relation Name": "job_approved_events",
"Alias": "job_approved_events",
"Startup Cost": 0.56,
"Total Cost": 2.78,
"Plan Rows": 1,
"Plan Width": 69,
"Actual Startup Time": 0.013,
"Actual Total Time": 0.014,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((job_id)::text = '76d2ff9a-d245-4ce8-a05e-a901656bc2a8'::text)",
"Rows Removed by Index Recheck": 0
},
"Planning Time": 0.085,
"Triggers": [
],
"Execution Time": 0.026
}
]
[
{
"Plan": {
"Node Type": "Index Scan",
"Scan Direction": "Forward",
"Index Name": "job_ended_events_job_id_key",
"Relation Name": "job_ended_events",
"Alias": "job_ended_events",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 69,
"Actual Startup Time": 0.017,
"Actual Total Time": 0.017,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((job_id)::text = '76d2ff9a-d245-4ce8-a05e-a901656bc2a8'::text)",
"Rows Removed by Index Recheck": 0,
"Filter": "((outcome)::text = 'canceled'::text)",
"Rows Removed by Filter": 1
},
"Planning Time": 0.972,
"Triggers": [
],
"Execution Time": 0.033
}
]
[
{
"Plan": {
"Node Type": "Index Scan",
"Scan Direction": "Forward",
"Index Name": "job_satisfied_events_job_id_key",
"Relation Name": "job_satisfied_events",
"Alias": "job_satisfied_events",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 16,
"Actual Startup Time": 0.015,
"Actual Total Time": 0.016,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((job_id)::text = '76d2ff9a-d245-4ce8-a05e-a901656bc2a8'::text)",
"Rows Removed by Index Recheck": 0
},
"Planning Time": 0.810,
"Triggers": [
],
"Execution Time": 0.026
}
]
[
{
"Plan": {
"Node Type": "Index Scan",
"Scan Direction": "Forward",
"Index Name": "workflow_created_events_workflow_id_key",
"Relation Name": "workflow_created_events",
"Alias": "workflow_created_events",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 85,
"Actual Startup Time": 0.015,
"Actual Total Time": 0.016,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((workflow_id)::text = 'b003e3b1-1845-45e1-bb6d-4e1c6c675a51'::text)",
"Rows Removed by Index Recheck": 0
},
"Planning Time": 0.209,
"Triggers": [
],
"Execution Time": 0.028
}
]
[
{
"Plan": {
"Node Type": "Index Scan",
"Scan Direction": "Forward",
"Index Name": "workflow_errored_events_workflow_id_key",
"Relation Name": "workflow_errored_events",
"Alias": "workflow_errored_events",
"Startup Cost": 0.42,
"Total Cost": 2.64,
"Plan Rows": 1,
"Plan Width": 69,
"Actual Startup Time": 0.011,
"Actual Total Time": 0.012,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((workflow_id)::text = 'b003e3b1-1845-45e1-bb6d-4e1c6c675a51'::text)",
"Rows Removed by Index Recheck": 0
},
"Planning Time": 0.081,
"Triggers": [
],
"Execution Time": 0.022
}
]
[
{
"Plan": {
"Node Type": "Index Scan",
"Scan Direction": "Forward",
"Index Name": "workflow_canceling_events_workflow_id_key",
"Relation Name": "workflow_canceling_events",
"Alias": "workflow_canceling_events",
"Startup Cost": 0.56,
"Total Cost": 2.78,
"Plan Rows": 1,
"Plan Width": 85,
"Actual Startup Time": 0.012,
"Actual Total Time": 0.013,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((workflow_id)::text = 'b003e3b1-1845-45e1-bb6d-4e1c6c675a51'::text)",
"Rows Removed by Index Recheck": 0
},
"Planning Time": 0.183,
"Triggers": [
],
"Execution Time": 0.024
}
]
[
{
"Plan": {
"Node Type": "Index Scan",
"Scan Direction": "Forward",
"Index Name": "active_workflows_by_project_branch_build_number",
"Relation Name": "auto_cancel_data",
"Alias": "auto_cancel_data",
"Startup Cost": 0.56,
"Total Cost": 2.78,
"Plan Rows": 1,
"Plan Width": 37,
"Actual Startup Time": 0.009,
"Actual Total Time": 0.009,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((project_analytics_id = '9dac6e93-26ed-4d23-8e54-f6c27d9d874e'::uuid) AND ((branch)::text = 'master'::text) AND (build_number < 1) AND (created_at > (now() - '48:00:00'::interval)))",
"Rows Removed by Index Recheck": 0
},
"Planning Time": 0.120,
"Triggers": [
],
"Execution Time": 0.030
}
]
[
{
"Plan": {
"Node Type": "Index Scan",
"Scan Direction": "Forward",
"Index Name": "workflows_project_id_updated_at_branch_index",
"Relation Name": "workflows",
"Alias": "workflows",
"Startup Cost": 0.70,
"Total Cost": 9350.60,
"Plan Rows": 8246,
"Plan Width": 45,
"Actual Startup Time": 0.009,
"Actual Total Time": 0.009,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "(project_analytics_id = '9dac6e93-26ed-4d23-8e54-f6c27d9d874e'::uuid)",
"Rows Removed by Index Recheck": 0,
"Filter": "((vcs_url)::text <> 'https://github.invalid/circleci/circle'::text)",
"Rows Removed by Filter": 1
},
"Planning Time": 0.129,
"Triggers": [
],
"Execution Time": 0.025
}
]
[
{
"Plan": {
"Node Type": "Index Scan",
"Scan Direction": "Forward",
"Index Name": "workflows_pkey",
"Relation Name": "workflows",
"Alias": "workflows",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 273,
"Actual Startup Time": 0.014,
"Actual Total Time": 0.015,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "((id)::text = 'b003e3b1-1845-45e1-bb6d-4e1c6c675a51'::text)",
"Rows Removed by Index Recheck": 0
},
"Planning Time": 0.071,
"Triggers": [
],
"Execution Time": 0.029
}
]
[
{
"Plan": {
"Node Type": "Limit",
"Startup Cost": 4174.81,
"Total Cost": 4174.84,
"Plan Rows": 10,
"Plan Width": 45,
"Actual Startup Time": 0.026,
"Actual Total Time": 0.026,
"Actual Rows": 0,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Sort",
"Parent Relationship": "Outer",
"Startup Cost": 4174.79,
"Total Cost": 4183.80,
"Plan Rows": 3607,
"Plan Width": 45,
"Actual Startup Time": 0.024,
"Actual Total Time": 0.025,
"Actual Rows": 1,
"Actual Loops": 1,
"Sort Key": ["created_at DESC", "id DESC"],
"Sort Method": "quicksort",
"Sort Space Used": 25,
"Sort Space Type": "Memory",
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Outer",
"Scan Direction": "Forward",
"Index Name": "workflows_build_id_and_id_index",
"Relation Name": "workflows",
"Alias": "workflows",
"Startup Cost": 0.70,
"Total Cost": 4078.80,
"Plan Rows": 3607,
"Plan Width": 45,
"Actual Startup Time": 0.006,
"Actual Total Time": 0.007,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "(build_id = '91d14a66-4883-49e1-9dce-5e22bb381a47'::uuid)",
"Rows Removed by Index Recheck": 0
}
]
}
]
},
"Planning Time": 0.076,
"Triggers": [
],
"Execution Time": 0.040
}
]
[
{
"Plan": {
"Node Type": "Nested Loop",
"Join Type": "Inner",
"Startup Cost": 4097.41,
"Total Cost": 4099.66,
"Plan Rows": 1,
"Plan Width": 58,
"Actual Startup Time": 0.019,
"Actual Total Time": 0.021,
"Actual Rows": 1,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Aggregate",
"Strategy": "Hashed",
"Parent Relationship": "Outer",
"Startup Cost": 4096.84,
"Total Cost": 4096.85,
"Plan Rows": 1,
"Plan Width": 21,
"Actual Startup Time": 0.010,
"Actual Total Time": 0.010,
"Actual Rows": 1,
"Actual Loops": 1,
"Group Key": ["workflows_1.name"],
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Outer",
"Scan Direction": "Forward",
"Index Name": "workflows_build_id_and_id_index",
"Relation Name": "workflows",
"Alias": "workflows_1",
"Startup Cost": 0.70,
"Total Cost": 4078.80,
"Plan Rows": 3607,
"Plan Width": 21,
"Actual Startup Time": 0.006,
"Actual Total Time": 0.007,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "(build_id = '91d14a66-4883-49e1-9dce-5e22bb381a47'::uuid)",
"Rows Removed by Index Recheck": 0
}
]
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Inner",
"Scan Direction": "Forward",
"Index Name": "workflows_created_at_index",
"Relation Name": "workflows",
"Alias": "workflows",
"Startup Cost": 0.57,
"Total Cost": 2.80,
"Plan Rows": 1,
"Plan Width": 58,
"Actual Startup Time": 0.007,
"Actual Total Time": 0.008,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "(created_at = (max(workflows_1.created_at)))",
"Rows Removed by Index Recheck": 0,
"Filter": "((build_id = '91d14a66-4883-49e1-9dce-5e22bb381a47'::uuid) AND ((workflows_1.name)::text = (name)::text))",
"Rows Removed by Filter": 0
}
]
},
"Planning Time": 0.232,
"Triggers": [
],
"Execution Time": 0.069
}
]
[
{
"Plan": {
"Node Type": "Result",
"Startup Cost": 0.00,
"Total Cost": 0.26,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 5.631,
"Actual Total Time": 5.632,
"Actual Rows": 1,
"Actual Loops": 1
},
"Planning Time": 0.008,
"Triggers": [
],
"Execution Time": 5.640
}
]
[
{
"Plan": {
"Node Type": "Result",
"Startup Cost": 0.00,
"Total Cost": 0.26,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 3.141,
"Actual Total Time": 3.142,
"Actual Rows": 1,
"Actual Loops": 1
},
"Planning Time": 0.006,
"Triggers": [
],
"Execution Time": 3.148
}
]
[
{
"Plan": {
"Node Type": "Index Scan",
"Scan Direction": "Forward",
"Index Name": "workflows_pkey",
"Relation Name": "workflows",
"Alias": "workflows",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 129,
"Actual Startup Time": 0.016,
"Actual Total Time": 0.016,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((id)::text = 'b003e3b1-1845-45e1-bb6d-4e1c6c675a51'::text)",
"Rows Removed by Index Recheck": 0
},
"Planning Time": 0.049,
"Triggers": [
],
"Execution Time": 0.029
}
]
[
{
"Plan": {
"Node Type": "ModifyTable",
"Operation": "Delete",
"Relation Name": "auto_cancel_data",
"Alias": "auto_cancel_data",
"Startup Cost": 0.43,
"Total Cost": 10384.93,
"Plan Rows": 11632,
"Plan Width": 6,
"Actual Startup Time": 7.778,
"Actual Total Time": 7.778,
"Actual Rows": 0,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Scan Direction": "Forward",
"Index Name": "auto_cancel_data_by_date",
"Relation Name": "auto_cancel_data",
"Alias": "auto_cancel_data",
"Startup Cost": 0.43,
"Total Cost": 10384.93,
"Plan Rows": 11632,
"Plan Width": 6,
"Actual Startup Time": 0.349,
"Actual Total Time": 4.660,
"Actual Rows": 2730,
"Actual Loops": 1,
"Index Cond": "(created_at < (now() - '14 days'::interval))",
"Rows Removed by Index Recheck": 0
}
]
},
"Planning Time": 1.274,
"Triggers": [
],
"Execution Time": 7.794
}
]
[
{
"Plan": {
"Node Type": "ModifyTable",
"Operation": "Delete",
"Relation Name": "unsatisfieds",
"Alias": "unsatisfieds",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 6,
"Actual Startup Time": 0.024,
"Actual Total Time": 0.024,
"Actual Rows": 0,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Scan Direction": "Forward",
"Index Name": "unsatisfieds_pkey",
"Relation Name": "unsatisfieds",
"Alias": "unsatisfieds",
"Startup Cost": 0.70,
"Total Cost": 2.92,
"Plan Rows": 1,
"Plan Width": 6,
"Actual Startup Time": 0.017,
"Actual Total Time": 0.018,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "(((job_id)::text = '98f42947-9557-47e8-b304-5e9f6f23713b'::text) AND ((unsatisfied)::text = '76d2ff9a-d245-4ce8-a05e-a901656bc2a8'::text))",
"Rows Removed by Index Recheck": 0
}
]
},
"Planning Time": 0.082,
"Triggers": [
],
"Execution Time": 0.041
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment