{ "type": "excalidraw", "version": 2, "source": "https://excalidraw.com", "elements": [ { "id": "r246060724", "type": "rectangle", "x": 190, "y": 74, "width": 372, "height": 182, "angle": 0, "strokeColor": "#dddddd", "backgroundColor": "#fafafa", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 3 }, "seed": 1443448775, "versionNonce": 1438724535, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false }, { "id": "t1227032773", "type": "text", "x": 202, "y": 80, "width": 297.0, "height": 15.0, "angle": 0, "strokeColor": "#888888", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 719589144, "versionNonce": 281440411, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "postgres \u2014 one binary, many backend processes", "fontSize": 12, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "postgres \u2014 one binary, many backend processes", "lineHeight": 1.25, "baseline": 12 }, { "id": "r462669877", "type": "rectangle", "x": 34, "y": 132, "width": 120, "height": 56, "angle": 0, "strokeColor": "#2f6db5", "backgroundColor": "#eef4fb", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 3 }, "seed": 1771964559, "versionNonce": 1340889240, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false }, { "id": "t1741396218", "type": "text", "x": 44, "y": 140, "width": 53.900000000000006, "height": 17.5, "angle": 0, "strokeColor": "#111111", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1678491281, "versionNonce": 666302575, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "clients", "fontSize": 14, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "clients", "lineHeight": 1.25, "baseline": 14 }, { "id": "t794751455", "type": "text", "x": 44, "y": 160, "width": 40, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1966323640, "versionNonce": 1208451089, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "SQL", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "SQL", "lineHeight": 1.25, "baseline": 11 }, { "id": "r1032214971", "type": "rectangle", "x": 210, "y": 116, "width": 150, "height": 40, "angle": 0, "strokeColor": "#111111", "backgroundColor": "#ffffff", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 3 }, "seed": 1698580407, "versionNonce": 1356051844, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false }, { "id": "t1177590282", "type": "text", "x": 220, "y": 124, "width": 115.50000000000001, "height": 17.5, "angle": 0, "strokeColor": "#111111", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1164457083, "versionNonce": 97685204, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "backend (pid A)", "fontSize": 14, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "backend (pid A)", "lineHeight": 1.25, "baseline": 14 }, { "id": "r733669187", "type": "rectangle", "x": 210, "y": 164, "width": 150, "height": 40, "angle": 0, "strokeColor": "#111111", "backgroundColor": "#ffffff", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 3 }, "seed": 1601664200, "versionNonce": 1026987583, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false }, { "id": "t999557167", "type": "text", "x": 220, "y": 172, "width": 115.50000000000001, "height": 17.5, "angle": 0, "strokeColor": "#111111", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1346541299, "versionNonce": 1512237897, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "backend (pid B)", "fontSize": 14, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "backend (pid B)", "lineHeight": 1.25, "baseline": 14 }, { "id": "r1856056139", "type": "rectangle", "x": 374, "y": 110, "width": 172, "height": 48, "angle": 0, "strokeColor": "#e8870c", "backgroundColor": "#fff8ef", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 3 }, "seed": 196718958, "versionNonce": 578495004, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false }, { "id": "t1669298848", "type": "text", "x": 384, "y": 118, "width": 46.2, "height": 17.5, "angle": 0, "strokeColor": "#111111", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1674497244, "versionNonce": 897187568, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "uprobe", "fontSize": 14, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "uprobe", "lineHeight": 1.25, "baseline": 14 }, { "id": "t1956751673", "type": "text", "x": 384, "y": 138, "width": 102.85000000000001, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1039301301, "versionNonce": 964583124, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "exec_simple_query", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "exec_simple_query", "lineHeight": 1.25, "baseline": 11 }, { "id": "r476141979", "type": "rectangle", "x": 374, "y": 170, "width": 172, "height": 48, "angle": 0, "strokeColor": "#e8870c", "backgroundColor": "#fff8ef", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 3 }, "seed": 227941371, "versionNonce": 495533217, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false }, { "id": "t1627968319", "type": "text", "x": 384, "y": 178, "width": 46.2, "height": 17.5, "angle": 0, "strokeColor": "#111111", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1050322681, "versionNonce": 1416533785, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "uprobe", "fontSize": 14, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "uprobe", "lineHeight": 1.25, "baseline": 14 }, { "id": "t1388601323", "type": "text", "x": 384, "y": 198, "width": 127.05000000000001, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 54994171, "versionNonce": 1764138998, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "ProcSleep (lock wait)", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "ProcSleep (lock wait)", "lineHeight": 1.25, "baseline": 11 }, { "id": "r571542771", "type": "rectangle", "x": 600, "y": 96, "width": 250, "height": 50, "angle": 0, "strokeColor": "#999999", "backgroundColor": "#ffffff", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 3 }, "seed": 1244142366, "versionNonce": 1736849051, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false }, { "id": "t1183750518", "type": "text", "x": 610, "y": 104, "width": 184.8, "height": 17.5, "angle": 0, "strokeColor": "#111111", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 359149946, "versionNonce": 608784977, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "query latency + SQL text", "fontSize": 14, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "query latency + SQL text", "lineHeight": 1.25, "baseline": 14 }, { "id": "t378511005", "type": "text", "x": 610, "y": 124, "width": 121.00000000000001, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1815770774, "versionNonce": 1274141850, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "keyed by backend pid", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "keyed by backend pid", "lineHeight": 1.25, "baseline": 11 }, { "id": "r1112176179", "type": "rectangle", "x": 600, "y": 176, "width": 250, "height": 50, "angle": 0, "strokeColor": "#999999", "backgroundColor": "#ffffff", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 3 }, "seed": 297218007, "versionNonce": 362167921, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false }, { "id": "t709876411", "type": "text", "x": 610, "y": 184, "width": 161.70000000000002, "height": 17.5, "angle": 0, "strokeColor": "#111111", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 335404919, "versionNonce": 1985064904, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "time waiting on locks", "fontSize": 14, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "time waiting on locks", "lineHeight": 1.25, "baseline": 14 }, { "id": "t1793248960", "type": "text", "x": 610, "y": 204, "width": 54.45, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 172745454, "versionNonce": 784985065, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "\u2192 Grafana", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "\u2192 Grafana", "lineHeight": 1.25, "baseline": 11 }, { "id": "a1405446246", "type": "arrow", "x": 154, "y": 160, "width": 36, "height": 0, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 883989445, "versionNonce": 1123699638, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 36, 0 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "t94528764", "type": "text", "x": 172.0, "y": 146.0, "width": 42.35, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 809590793, "versionNonce": 1407751757, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "queries", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "queries", "lineHeight": 1.25, "baseline": 11 }, { "id": "a1709984975", "type": "arrow", "x": 546, "y": 134, "width": 54, "height": 14, "angle": 0, "strokeColor": "#b8650a", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 173942858, "versionNonce": 83590027, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 54, -14 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "t1875830730", "type": "text", "x": 573.0, "y": 113.0, "width": 90.75000000000001, "height": 13.75, "angle": 0, "strokeColor": "#b8650a", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 998216491, "versionNonce": 1095864218, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "duration + text", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "duration + text", "lineHeight": 1.25, "baseline": 11 }, { "id": "a1777206202", "type": "arrow", "x": 546, "y": 194, "width": 54, "height": 6, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 1581254108, "versionNonce": 88057567, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 54, 6 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "t436076374", "type": "text", "x": 573.0, "y": 183.0, "width": 54.45, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1054407630, "versionNonce": 254153815, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "wait time", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "wait time", "lineHeight": 1.25, "baseline": 11 }, { "id": "t1063061553", "type": "text", "x": 440, "y": 20, "width": 508.20000000000005, "height": 13.75, "angle": 0, "strokeColor": "#b8650a", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1115967789, "versionNonce": 1649304060, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "see inside the database: per-query latency (with SQL) and time lost waiting on locks", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "see inside the database: per-query latency (with SQL) and time lost waiting on locks", "lineHeight": 1.25, "baseline": 11 }, { "id": "t1707066559", "type": "text", "x": 440, "y": 274, "width": 562.6500000000001, "height": 13.75, "angle": 0, "strokeColor": "#888888", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1867997940, "versionNonce": 1066308191, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "one uprobe on the postgres binary covers every backend; the backend pid separates connections", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "one uprobe on the postgres binary covers every backend; the backend pid separates connections", "lineHeight": 1.25, "baseline": 11 } ], "appState": { "viewBackgroundColor": "#ffffff", "gridSize": null }, "files": {} }