Total Size
586 MB
incl. indexes & TOAST
Table Data
72 MB
heap only
Indexes + TOAST
514 MB
88% of total
Estimated Rows
90,804
pg_class.reltuples
Block Type Breakdown
| Type | Count | Count% | Size | Size% |
|---|
| tool-call | 224,680 | 50.0% | 258 MB | 67.5% |
| reasoning | 69,191 | 15.4% | 78 MB | 20.4% |
| markdown | 98,051 | 21.8% | 34 MB | 8.9% |
| text | 44,323 | 9.9% | 8587 kB | 2.2% |
| input | 3,104 | 0.7% | 1122 kB | 0.3% |
| delegation | 1,122 | 0.2% | 1105 kB | 0.3% |
| task-ref | 2,404 | 0.5% | 958 kB | 0.2% |
| file | 4,306 | 1.0% | 668 kB | 0.2% |
| mention | 911 | 0.2% | 73 kB | 0.0% |
| device | 540 | 0.1% | 52 kB | 0.0% |
| skill | 177 | 0.0% | 7652 bytes | 0.0% |
| divider | 123 | 0.0% | 2337 bytes | 0.0% |
Tool Call Detail
| Tool | Calls | Size | % |
|---|
| bash | 122,948 | 161 MB | 64.5% |
| read_stdout | 33,235 | 19 MB | 7.6% |
| syncless | 10,240 | 17 MB | 6.7% |
| apply_patch | 3,549 | 15 MB | 6.0% |
| browser_tool_chrome_958639b15a8adc23 | 8,657 | 8191 kB | 3.2% |
| browser_tool_chrome_261f58654a3d7c2d | 6,612 | 6071 kB | 2.4% |
| browser_tool_edge_8725e2c0654d6a94c8 | 5,865 | 4797 kB | 1.9% |
| browser_tool_chrome_9100980a5163af59 | 3,602 | 4123 kB | 1.6% |
| browser_tool_chrome_34988b725be9ebda | 5,236 | 4071 kB | 1.6% |
| browser_tool_chrome_c314c88e17c529b4 | 3,239 | 2917 kB | 1.1% |
| ask_human | 1,725 | 2436 kB | 1.0% |
| copy_file | 2,491 | 1702 kB | 0.7% |
| read_media | 2,818 | 1560 kB | 0.6% |
| search_skills | 2,518 | 1536 kB | 0.6% |
| browser_tool_chrome_7055b011e186370e | 1,371 | 1277 kB | 0.5% |
Index Usage
| Index | Size | Scans | Rows Read |
|---|
| task_id_idx | 1512 kB | 8,865,391 | 164,607,248 |
| to_task_id_idx | 1504 kB | 8,802,711 | 163,587,194 |
| to_task_id_created_at_idx | 9552 kB | 2,982,195 | 37,607,809 |
| task_id_created_at_idx | 9584 kB | 2,933,304 | 36,980,732 |
| pkey | 7544 kB | 318,246 | 332,525 |
| cursor_id_key | 2168 kB | 93,691 | 167,719,633 |
| task_id_cursor_id_idx | 9584 kB | 645 | 65,324 |
| to_task_id_cursor_id_idx | 9552 kB | 639 | 65,208 |
| sender_id_created_at_idx | 11 MB | 505 | 42,586 |
| searchable_trgm_idx | 139 MB | 196 | 288,348 |
| sender_id_idx | 1216 kB | 33 | 25,745 |
| receiver_id_idx | 1224 kB | 14 | 4,525 |
| receiver_id_created_at_idx | 11 MB | 0 | 0 |
Table Ranking
| # | Table | Size |
|---|
| 1 | task_messages | 586 MB |
| 2 | pipeline_user_devices | 17 MB |
| 3 | tasks | 12 MB |
| 4 | pipelines | 12 MB |
| 5 | files | 9432 kB |
| 6 | reviews | 6728 kB |
| 7 | skill_entries | 6696 kB |
| 8 | devices | 5008 kB |
| 9 | pipeline_files | 4968 kB |
| 10 | skills | 3976 kB |