3 ms·
Despite using CTEs, I found the first query quite impenetrable. Could be because I don’t spend that much time reading non-trivial SQL queries. I’ve been mostly
by rednafi 1y ago
Despite using CTEs, I found the first query quite impenetrable. Could be because I don’t spend that much time reading non-trivial SQL queries.
I’ve been mostly using the `pg_stat_statements` table (the second technique) to find out whether my workload is read or write heavy, it’s plenty good in most situations.
- teej 1y agopg_ system tables aren’t built for direct consumption. You typically have to massage them quite a bit to measure whatever statistic you need.