Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [
- {
- "Execution Time": 901.468,
- "Planning Time": 0.805,
- "Plan": {
- "Node Type": "Limit",
- "Actual Total Time": 901.332,
- "Shared Hit Blocks": 12997,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Actual Total Time": 901.323,
- "Shared Hit Blocks": 12997,
- "Schema": "public",
- "Scan Direction": "Backward",
- "Shared Read Blocks": 0,
- "Relation Name": "RegentonManager_rainbarrelmeasurement",
- "Local Hit Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Temp Written Blocks": 0,
- "Plan Width": 33,
- "Total Cost": 78300.73,
- "Actual Startup Time": 901.323,
- "Filter": "(\"RegentonManager_rainbarrelmeasurement\".rainbarrel_id = 24)",
- "Alias": "RegentonManager_rainbarrelmeasurement",
- "Temp Read Blocks": 0,
- "Output": [
- "id",
- "measure_timestamp",
- "sensor_height",
- "rainbarrel_id",
- "water_height",
- "temperature",
- "valve_check"
- ],
- "Local Read Blocks": 0,
- "Index Name": "\"RegentonManager_regentonhistory_pkey\"",
- "Startup Cost": 0.43,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Written Blocks": 0,
- "Plan Rows": 25455,
- "Parallel Aware": false,
- "Actual Rows": 1,
- "Parent Relationship": "Outer",
- "Actual Loops": 1,
- "Rows Removed by Filter": 941654
- }
- ],
- "Shared Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Hit Blocks": 0,
- "Plan Width": 33,
- "Actual Loops": 1,
- "Actual Startup Time": 901.33,
- "Temp Read Blocks": 0,
- "Output": [
- "id",
- "measure_timestamp",
- "sensor_height",
- "rainbarrel_id",
- "water_height",
- "temperature",
- "valve_check"
- ],
- "Local Read Blocks": 0,
- "Startup Cost": 0.43,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Written Blocks": 0,
- "Plan Rows": 1,
- "Parallel Aware": false,
- "Actual Rows": 1,
- "Total Cost": 3.51
- },
- "Triggers": []
- }
- ]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement