Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://gitlab.com/postgres-ai/database-lab/-/merge_requests/969 below:

Draft: feat: run Joe Bot commands on existing clones (joe#190) (!969) · Merge requests · Postgres AI

• move pgexplain and significant utilites to DBLab
• cut off Joe dependencies
• fill the visualization/summarization result fields
• continuously provide results of explain execution to external storage
• design plan storage and API on the Platform
• authorize with the Platform
• store results to the Platform

joe#190

POST /explain

{
    "clone_id":"d15ak4gn9i6s73963msg",
    "command": "explain",
    "query": "select 1"
}

Response

{
    "id": "0197869a-ead7-7204-89dd-41f55b55359d",
    "status": "initial",
    "plan_text": "",
    "plan_json": "",
    "plan_execution_text": " Result  (cost=0.00..0.01 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)\n   I/O Timings: read=0.000 write=0.000\n",
    "plan_execution_json": "[\n  {\n    \"Plan\": {\n      \"Node Type\": \"Result\",\n      \"Parallel Aware\": false,\n      \"Async Capable\": false,\n      \"Startup Cost\": 0.00,\n      \"Total Cost\": 0.01,\n      \"Plan Rows\": 1,\n      \"Plan Width\": 4,\n      \"Actual Startup Time\": 0.001,\n      \"Actual Total Time\": 0.001,\n      \"Actual Rows\": 1,\n      \"Actual Loops\": 1,\n      \"Output\": [\"1\"],\n      \"Shared Hit Blocks\": 0,\n      \"Shared Read Blocks\": 0,\n      \"Shared Dirtied Blocks\": 0,\n      \"Shared Written Blocks\": 0,\n      \"Local Hit Blocks\": 0,\n      \"Local Read Blocks\": 0,\n      \"Local Dirtied Blocks\": 0,\n      \"Local Written Blocks\": 0,\n      \"Temp Read Blocks\": 0,\n      \"Temp Written Blocks\": 0,\n      \"I/O Read Time\": 0.000,\n      \"I/O Write Time\": 0.000\n    },\n    \"Planning\": {\n      \"Shared Hit Blocks\": 0,\n      \"Shared Read Blocks\": 0,\n      \"Shared Dirtied Blocks\": 0,\n      \"Shared Written Blocks\": 0,\n      \"Local Hit Blocks\": 0,\n      \"Local Read Blocks\": 0,\n      \"Local Dirtied Blocks\": 0,\n      \"Local Written Blocks\": 0,\n      \"Temp Read Blocks\": 0,\n      \"Temp Written Blocks\": 0,\n      \"I/O Read Time\": 0.000,\n      \"I/O Write Time\": 0.000\n    },\n    \"Planning Time\": 0.006,\n    \"Triggers\": [\n    ],\n    \"Execution Time\": 0.021\n  }\n]\n",
    "recommendations": "",
    "stats": "\nTime: 0.027 ms\n  - planning: 0.006 ms\n  - execution: 0.021 ms\n    - I/O read: 0.000 ms\n    - I/O write: 0.000 ms\n\nShared buffers:\n  - hits: 0 from the buffer pool\n  - reads: 0 from the OS file cache, including disk I/O\n  - dirtied: 0\n  - writes: 0\n",
    "query_locks": "  # | RELKIND | RELNAMESPACE |   RELNAME   |  BELONGS TO RELATION   | LOCKTYPE |      MODE       | GRANTED | FASTPATH  \n----+---------+--------------+-------------+------------------------+----------+-----------------+---------+-----------\n  1 | v       | pg_catalog   | pg_settings | pg_catalog.pg_settings | relation | AccessShareLock | true    | true      \n",
    "plan_link": ""
}

GET /explain-results

Query params:

• "explain_id": "0197869a-ead7-7204-89dd-41f55b55359d"

Response

{
    "id": "0197869a-ead7-7204-89dd-41f55b55359d",
    "status": "ok",
    "plan_text": "",
    "plan_json": "",
    "plan_execution_text": " Result  (cost=0.00..0.01 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)\n   I/O Timings: read=0.000 write=0.000\n",
    "plan_execution_json": "[\n  {\n    \"Plan\": {\n      \"Node Type\": \"Result\",\n      \"Parallel Aware\": false,\n      \"Async Capable\": false,\n      \"Startup Cost\": 0.00,\n      \"Total Cost\": 0.01,\n      \"Plan Rows\": 1,\n      \"Plan Width\": 4,\n      \"Actual Startup Time\": 0.001,\n      \"Actual Total Time\": 0.001,\n      \"Actual Rows\": 1,\n      \"Actual Loops\": 1,\n      \"Output\": [\"1\"],\n      \"Shared Hit Blocks\": 0,\n      \"Shared Read Blocks\": 0,\n      \"Shared Dirtied Blocks\": 0,\n      \"Shared Written Blocks\": 0,\n      \"Local Hit Blocks\": 0,\n      \"Local Read Blocks\": 0,\n      \"Local Dirtied Blocks\": 0,\n      \"Local Written Blocks\": 0,\n      \"Temp Read Blocks\": 0,\n      \"Temp Written Blocks\": 0,\n      \"I/O Read Time\": 0.000,\n      \"I/O Write Time\": 0.000\n    },\n    \"Planning\": {\n      \"Shared Hit Blocks\": 0,\n      \"Shared Read Blocks\": 0,\n      \"Shared Dirtied Blocks\": 0,\n      \"Shared Written Blocks\": 0,\n      \"Local Hit Blocks\": 0,\n      \"Local Read Blocks\": 0,\n      \"Local Dirtied Blocks\": 0,\n      \"Local Written Blocks\": 0,\n      \"Temp Read Blocks\": 0,\n      \"Temp Written Blocks\": 0,\n      \"I/O Read Time\": 0.000,\n      \"I/O Write Time\": 0.000\n    },\n    \"Planning Time\": 0.006,\n    \"Triggers\": [\n    ],\n    \"Execution Time\": 0.021\n  }\n]\n",
    "recommendations": "",
    "stats": "\nTime: 0.027 ms\n  - planning: 0.006 ms\n  - execution: 0.021 ms\n    - I/O read: 0.000 ms\n    - I/O write: 0.000 ms\n\nShared buffers:\n  - hits: 0 from the buffer pool\n  - reads: 0 from the OS file cache, including disk I/O\n  - dirtied: 0\n  - writes: 0\n",
    "query_locks": "  # | RELKIND | RELNAMESPACE |   RELNAME   |  BELONGS TO RELATION   | LOCKTYPE |      MODE       | GRANTED | FASTPATH  \n----+---------+--------------+-------------+------------------------+----------+-----------------+---------+-----------\n  1 | v       | pg_catalog   | pg_settings | pg_catalog.pg_settings | relation | AccessShareLock | true    | true      \n",
    "plan_link": ""
}

• MR description has been reviewed
• MR changes are functionally tested
• MR does NOT have API/CLI changes OR there are API/CLI changes and they have been reviewed & DOCS ARE ADJUSTED (reference doc, etc)
• MR does NOT have UI changes OR there are UI changes and they have been reviewed & UX IS REVIEWED

Closes #190

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4