gistfile1.txt

steamcharts=# \d game_players
            Table "public.game_players"
 Column |           Type           |   Modifiers
--------+--------------------------+---------------
 appid  | integer                  |
 time   | timestamp with time zone | default now()
 count  | integer                  |
Indexes:
    "game_players_appid_idx" btree (appid)
    "game_players_time_idx" btree ("time")
Triggers:
    update_daily AFTER INSERT ON game_players FOR EACH ROW EXECUTE PROCEDURE update_daily()
    update_monthly AFTER INSERT ON game_players FOR EACH ROW EXECUTE PROCEDURE update_monthly()

steamcharts=# \dt+
                               List of relations
 Schema |         Name         | Type  |    Owner    |    Size    | Description
--------+----------------------+-------+-------------+------------+-------------
 public | game_players         | table | steamcharts | 2149 MB    |
 public | game_players_daily   | table | steamcharts | 13 MB      |
 public | game_players_monthly | table | steamcharts | 8192 bytes |
 public | games                | table | steamcharts | 1424 kB    |
(4 rows)