Pinned Loading

1. Useful PSQL queries Useful PSQL queries

   1

   -- Table Sizes

   2

   SELECT relname,

   3

          pg_size_pretty(pg_total_relation_size(relname::regclass))                                       AS full_size,

   4

          pg_size_pretty(pg_relation_size(relname::regclass))                                             AS table_size,

   5

          pg_size_pretty(pg_total_relation_size(relname::regclass) - pg_relation_size(relname::regclass)) AS TOAST size,

2. useful_mysql_queries.sql useful_mysql_queries.sql

   1

   -- search in all columns

   2

   SELECT `TABLE_NAME`, `COLUMN_NAME`

   3

   FROM `INFORMATION_SCHEMA`.`COLUMNS`

   4

   WHERE `TABLE_SCHEMA` = 'table_schema'

   5

     and `COLUMN_NAME` like '%test%';