| 2 Aug 2023 |
 das_j | We talked about that and I have no valuable input as my knowledge about that isn't too good | 18:10:27 |
 raitobezarius | here's the cost of a explain analyze select count(*) from builds; | 18:10:30 |
| raitobezarius | In reply to @janne.hess:helsinki-systems.de
We talked about that and I have no valuable input as my knowledge about that isn't too good we need to decide on the partition key | 18:10:38 |
| raitobezarius | either IDs or dates | 18:10:41 |
| raitobezarius | or whatever locally makes sense | 18:10:45 |
| raitobezarius | and we don't have to lock a choice, we can just try things | 18:10:53 |
 K900 (deprecated) | Wait what is it even doing, a full scan? | 18:11:22 |
| raitobezarius | but database design is indeed another separate concern from the web part, etc. | 18:11:24 |
| raitobezarius | In reply to @k900:conduit.0upti.me
Wait what is it even doing, a full scan? lol | 18:11:28 |
| raitobezarius | are you ready? | 18:11:29 |
| raitobezarius | Finalize Aggregate (cost=1666154.70..1666154.71 rows=1 width=8) (actual time=39057.027..39207.028 rows=1 loops=1)
-> Gather (cost=1666153.87..1666154.68 rows=8 width=8) (actual time=39047.839..39206.943 rows=9 loops=1)
Workers Planned: 8
Workers Launched: 8
-> Partial Aggregate (cost=1665153.87..1665153.88 rows=1 width=8) (actual time=38801.196..38801.202 rows=1 loops=9)
-> Parallel Index Only Scan using indexbuildsontimestamp on builds (cost=0.57..1596964.67 rows=27275678 width=0) (actual time=0.445..37043.934 rows=24248822 loops=9)
Heap Fetches: 0
| 18:11:37 |
| K900 (deprecated) | Cause like just truncate the sodding thing WHAT | 18:11:42 |
| raitobezarius | yes exactly my reaction | 18:11:51 |
| K900 (deprecated) | A 30 seconds index scan? | 18:11:56 |
| raitobezarius | parallel index scan sir | 18:12:05 |
| raitobezarius | with JIT and 8 workers | 18:12:10 |
| raitobezarius | on fucking 1M read IOPS NVMe | 18:12:17 |
| raitobezarius | just to be clear | 18:12:19 |
