Chat
User reported cloudflare timeout
Container exited, and another one eventually restarted
Bridge call
Horizon Client 01 product pages not responding
DWH reconcilliation job failed overnight so Viv restarted it during office hours (~9am)
New Relic is showing the commits are taking excessive amounts of time
Is replication a problem?
Are Database/table sizes look ok?
➜ ~ psql -h hcukazlpbids02.uk.harpercollins.org -U bids3 -W bids3_hcp
Password for user bids3:
psql (10.18 (Ubuntu 10.18-1.pgdg20.04+1), server 10.17 (Debian 10.17-1.pgdg100+1))
Type "help" for help.
bids3_hcp=> \l+
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges | Size | Tablespace | Description
-------------------+-------------+----------+------------+------------+-------------------+---------+------------+--------------------------------------------
bids3_aa | aa | UTF8 | en_US.utf8 | en_US.utf8 | | 15 MB | pg_default |
bids3_amberley | amberley | UTF8 | en_US.utf8 | en_US.utf8 | | 15 MB | pg_default |
bids3_hc360 | 360 | UTF8 | en_US.utf8 | en_US.utf8 | | 34 MB | pg_default |
bids3_hcnonpub | hcnonpub | UTF8 | en_US.utf8 | en_US.utf8 | | 15 MB | pg_default |
bids3_hcp | bids3 | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/bids3 +| 248 MB | pg_default |
| | | | | bids3=CTc/bids3 | | |
...
bids3_hcp_tmp | bids3 | UTF8 | en_US.utf8 | en_US.utf8 | | 15 MB | pg_default default template for new databases
| | | | | seadev=CTc/seadev | | |
bids3_hcp=> \d+
public | user_list_userlist | table | bids3 | 432 kB |
public | user_list_userlist_id_seq | sequence | bids3 | 8192 bytes |
public | user_list_userlist_item | table | bids3 | 22 MB |