3 ms·

Getting 20% CPU utilization on 300 tran/s is crazy.

• latchkey 4y ago
  I can't tell if this is good or bad. =) Most of my queries are super simple and most of the load is an update statement on a primary key column.
  • duskwuff 4y ago
    To be more explicit: 20% CPU utilization for that workload is shockingly high.
    • latchkey 4y ago
      Interesting, doesn't seem high to me given that this is the backend to GCP functions which are a sustained ~25 rps, but maybe I'm missing an index or something. It is mostly update writes though, so maybe that is part of it. #1 query is: `insert into on conflict do update` (based on id column). 57 writes/s 281 trans/s ~12-15 connections 547 megs used