Advertisement
Guest User

Untitled

a guest
Apr 25th, 2017
276
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.32 KB | None | 0 0
  1. [
  2. {
  3. "Execution Time": 901.468,
  4. "Planning Time": 0.805,
  5. "Plan": {
  6. "Node Type": "Limit",
  7. "Actual Total Time": 901.332,
  8. "Shared Hit Blocks": 12997,
  9. "Plans": [
  10. {
  11. "Node Type": "Index Scan",
  12. "Actual Total Time": 901.323,
  13. "Shared Hit Blocks": 12997,
  14. "Schema": "public",
  15. "Scan Direction": "Backward",
  16. "Shared Read Blocks": 0,
  17. "Relation Name": "RegentonManager_rainbarrelmeasurement",
  18. "Local Hit Blocks": 0,
  19. "Local Dirtied Blocks": 0,
  20. "Temp Written Blocks": 0,
  21. "Plan Width": 33,
  22. "Total Cost": 78300.73,
  23. "Actual Startup Time": 901.323,
  24. "Filter": "(\"RegentonManager_rainbarrelmeasurement\".rainbarrel_id = 24)",
  25. "Alias": "RegentonManager_rainbarrelmeasurement",
  26. "Temp Read Blocks": 0,
  27. "Output": [
  28. "id",
  29. "measure_timestamp",
  30. "sensor_height",
  31. "rainbarrel_id",
  32. "water_height",
  33. "temperature",
  34. "valve_check"
  35. ],
  36. "Local Read Blocks": 0,
  37. "Index Name": "\"RegentonManager_regentonhistory_pkey\"",
  38. "Startup Cost": 0.43,
  39. "Shared Dirtied Blocks": 0,
  40. "Shared Written Blocks": 0,
  41. "Local Written Blocks": 0,
  42. "Plan Rows": 25455,
  43. "Parallel Aware": false,
  44. "Actual Rows": 1,
  45. "Parent Relationship": "Outer",
  46. "Actual Loops": 1,
  47. "Rows Removed by Filter": 941654
  48. }
  49. ],
  50. "Shared Read Blocks": 0,
  51. "Temp Written Blocks": 0,
  52. "Local Dirtied Blocks": 0,
  53. "Local Hit Blocks": 0,
  54. "Plan Width": 33,
  55. "Actual Loops": 1,
  56. "Actual Startup Time": 901.33,
  57. "Temp Read Blocks": 0,
  58. "Output": [
  59. "id",
  60. "measure_timestamp",
  61. "sensor_height",
  62. "rainbarrel_id",
  63. "water_height",
  64. "temperature",
  65. "valve_check"
  66. ],
  67. "Local Read Blocks": 0,
  68. "Startup Cost": 0.43,
  69. "Shared Dirtied Blocks": 0,
  70. "Shared Written Blocks": 0,
  71. "Local Written Blocks": 0,
  72. "Plan Rows": 1,
  73. "Parallel Aware": false,
  74. "Actual Rows": 1,
  75. "Total Cost": 3.51
  76. },
  77. "Triggers": []
  78. }
  79. ]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement