2020-06-27T00:01:27  *** lurchi__ is now known as lurchi_
2020-06-27T00:39:23  *** lurchi_ is now known as lurchi__
2020-06-27T02:12:32  *** lurchi_ is now known as lurchi__
2020-06-27T02:40:17  *** lurchi__ is now known as lurchi_
2020-06-27T03:58:57  *** lurchi_ is now known as lurchi__
2020-06-27T04:43:13  -heroes-bot- PROBLEM: PSQL locks on mirrordb2.infra.opensuse.org - POSTGRES_LOCKS CRITICAL: DB postgres total locks: 272 * total waiting locks: 132 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb2.infra.opensuse.org&service=PSQL%20locks
2020-06-27T04:45:24  -heroes-bot- PROBLEM: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS CRITICAL: DB postgres total waiting locks: 4 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks
2020-06-27T04:53:12  -heroes-bot- RECOVERY: PSQL locks on mirrordb2.infra.opensuse.org - POSTGRES_LOCKS OK: DB postgres total=3 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb2.infra.opensuse.org&service=PSQL%20locks
2020-06-27T04:55:24  -heroes-bot- RECOVERY: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS OK: DB postgres total=20 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks
2020-06-27T12:33:24  -heroes-bot- PROBLEM: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS CRITICAL: DB postgres total locks: 60 * total waiting locks: 1 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks
2020-06-27T12:53:24  -heroes-bot- RECOVERY: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS OK: DB postgres total=46 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks
2020-06-27T13:29:24  -heroes-bot- PROBLEM: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS CRITICAL: DB postgres total locks: 50 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks
2020-06-27T15:54:24  *** lurchi_ is now known as lurchi__
2020-06-27T16:27:27  *** lurchi__ is now known as lurchi_
2020-06-27T18:09:41  <cboltz> lcp: I finally had some time to look at the slow query from matrix
2020-06-27T18:10:11  <cboltz> but I'm not sure if I'll be very helpful because the "explain" output from postgres is completely different from what I know from mysql
2020-06-27T18:11:33  <cboltz> one thing I noticed is that there's a big number of rows in the subqueries, especially
2020-06-27T18:11:35  <cboltz> Seq Scan on state_groups_state  (cost=0.00..33847.99 rows=1180299 width=89)
2020-06-27T18:12:46  <cboltz> it might also be better if that would read "Index Scan"
2020-06-27T18:37:45  *** lurchi_ is now known as lurchi__
2020-06-27T21:56:19  *** lurchi__ is now known as lurchi_
2020-06-27T22:13:43  *** lurchi_ is now known as lurchi__
2020-06-27T23:33:33  *** lurchi__ is now known as lurchi_