VM
Size: a a a
VM
DP
VM
DP
VM
select count(1) = 0 from metadata where uuid = 'b940d071-d781-46f0-82b6-62b3f3934f2c'
[
{
"Plan": {
"Node Type": "Aggregate",
"Strategy": "Plain",
"Partial Mode": "Simple",
"Parallel Aware": false,
"Startup Cost": 8.45,
"Total Cost": 8.46,
"Plan Rows": 1,
"Plan Width": 1,
"Actual Startup Time": 0.053,
"Actual Total Time": 0.054,
"Actual Rows": 1,
"Actual Loops": 1,
"Output": [
"(count(1) = 0)"
],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 4,
"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,
"Plans": [
{
"Node Type": "Index Only Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "metadata_uuid",
"Relation Name": "metadata",
"Schema": "public",
"Alias": "metadata",
"Startup Cost": 0.43,
"Total Cost": 8.45,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.044,
"Actual Total Time": 0.045,
"Actual Rows": 1,
"Actual Loops": 1,
"Output": [
"uuid"
],
"Index Cond": "(metadata.uuid = 'b940d071-d781-46f0-82b6-62b3f3934f2c'::uuid)",
"Rows Removed by Index Recheck": 0,
"Heap Fetches": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 4,
"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
}
]
},
"Planning Time": 0.129,
"Triggers": [],
"Execution Time": 0.089
}
]
DP
DP
а
VM
VM
select count(1) = 0 from metadata where uuid = 'b940d071-d781-46f0-82b6-62b3f3934f2c' and requested_at < now() + interval '1 minute'
[
{
"Plan": {
"Node Type": "Aggregate",
"Strategy": "Plain",
"Partial Mode": "Simple",
"Parallel Aware": false,
"Startup Cost": 8.46,
"Total Cost": 8.47,
"Plan Rows": 1,
"Plan Width": 1,
"Actual Startup Time": 0.1,
"Actual Total Time": 0.101,
"Actual Rows": 1,
"Actual Loops": 1,
"Output": [
"(count(1) = 0)"
],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 4,
"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,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "metadata_uuid",
"Relation Name": "metadata",
"Schema": "public",
"Alias": "metadata",
"Startup Cost": 0.43,
"Total Cost": 8.46,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.092,
"Actual Total Time": 0.093,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "(metadata.uuid = 'b940d071-d781-46f0-82b6-62b3f3934f2c'::uuid)",
"Rows Removed by Index Recheck": 0,
"Filter": "(metadata.requested_at < (now() + '00:01:00'::interval))",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 4,
"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
}
]
},
"Planning Time": 0.27,
"Triggers": [],
"Execution Time": 0.15
}
]
DP
VM
select count(1) = 0 from metadata where uuid = 'b940d071-d781-46f0-82b6-62b3f3934f2c'
[
{
"Plan": {
"Node Type": "Aggregate",
"Strategy": "Plain",
"Partial Mode": "Simple",
"Parallel Aware": false,
"Startup Cost": 8.45,
"Total Cost": 8.46,
"Plan Rows": 1,
"Plan Width": 1,
"Actual Startup Time": 0.053,
"Actual Total Time": 0.054,
"Actual Rows": 1,
"Actual Loops": 1,
"Output": [
"(count(1) = 0)"
],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 4,
"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,
"Plans": [
{
"Node Type": "Index Only Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "metadata_uuid",
"Relation Name": "metadata",
"Schema": "public",
"Alias": "metadata",
"Startup Cost": 0.43,
"Total Cost": 8.45,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.044,
"Actual Total Time": 0.045,
"Actual Rows": 1,
"Actual Loops": 1,
"Output": [
"uuid"
],
"Index Cond": "(metadata.uuid = 'b940d071-d781-46f0-82b6-62b3f3934f2c'::uuid)",
"Rows Removed by Index Recheck": 0,
"Heap Fetches": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 4,
"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
}
]
},
"Planning Time": 0.129,
"Triggers": [],
"Execution Time": 0.089
}
]
DP
select count(1) = 0 from metadata where uuid = 'b940d071-d781-46f0-82b6-62b3f3934f2c' and requested_at < now() + interval '1 minute'
[
{
"Plan": {
"Node Type": "Aggregate",
"Strategy": "Plain",
"Partial Mode": "Simple",
"Parallel Aware": false,
"Startup Cost": 8.46,
"Total Cost": 8.47,
"Plan Rows": 1,
"Plan Width": 1,
"Actual Startup Time": 0.1,
"Actual Total Time": 0.101,
"Actual Rows": 1,
"Actual Loops": 1,
"Output": [
"(count(1) = 0)"
],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 4,
"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,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "metadata_uuid",
"Relation Name": "metadata",
"Schema": "public",
"Alias": "metadata",
"Startup Cost": 0.43,
"Total Cost": 8.46,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0.092,
"Actual Total Time": 0.093,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "(metadata.uuid = 'b940d071-d781-46f0-82b6-62b3f3934f2c'::uuid)",
"Rows Removed by Index Recheck": 0,
"Filter": "(metadata.requested_at < (now() + '00:01:00'::interval))",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 4,
"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
}
]
},
"Planning Time": 0.27,
"Triggers": [],
"Execution Time": 0.15
}
]
VM
DP
VM
DP
VM