Blurbs ansible coffeescript django dvcs erlang es6 hg javascript json lua mercurial peewee postgresql python scope sql sqlalchemy yaml

CTE code postgresqlsql

WITH busytables AS (
  SELECT relname, (seq_scan + idx_scan) AS scans
  FROM pg_stat_user_tables
)
SELECT relname, scans
FROM busytables
WHERE scans > 100
ORDER BY scans DESC;