SQL Commands Cheatsheet
Query | Description | Name of Technique / Function | Database |
SELECT pg_type.typname AS enumtype,
pg_enum.enumlabel AS enumlabel
FROM pg_type
JOIN pg_enum
ON pg_enum.enumtypid = pg_type.oid
where pg_type.typname like 'enum_%' | Search for enum and its available value | ㅤ | ㅤ |
WITH m AS (SELECT *
FROM managerships
WHERE managerships.employee_id = 1234
), m2 AS (SELECT *
FROM managerships
WHERE managerships.employee_id = 4321
)
SELECT "users".* FROM "users"
WHERE (
users.id IN (SELECT manager_id FROM m) OR
users.custom_id IN (SELECT manager_custom_id FROM m) OR
users.saml_id IN (SELECT manager_saml_id FROM m) OR
users.email IN (SELECT manager_email FROM m2)
); | An Example of Common Table Expression | Common Table Expression | ㅤ |
SELECT t.relname tablename, i.indexrelname, i.idx_scan, i.idx_tup_read, t.seq_scan table_seq_scan, 100* t.idx_scan / (t.idx_scan + t.seq_scan) IdxScanPercentage
FROM pg_stat_user_indexes i
JOIN pg_stat_user_tables t on i.relname = t.relname
where t.relname in ('orders','trades') | Index Usage Analysis | ㅤ | - Postgres |
Loading...