Geo project repository query timing out

I'm not sure why it's not showing in Sentry, but the secondary isn't able to pick up any more projects due to a statement timeout:

2017-10-09_02:32:04.44641 sync sidekiq: : SELECT  "projects"."id" FROM "projects" LEFT OUTER JOIN
2017-10-09_02:32:04.44643 sync sidekiq: (VALUES (1098072, 't'),(2632605, 't'),(2091128, 't'),(3078685, 't'),(1439065, 't'),(2830391, 't'),(1969017, 't'),(971932, 't'),(886198, 't'),(3262002, '
t'),(2637235, 't'),(175378, 't'),(2078467, 't'),(1280616, 't'),(1805849, 't'),(157210, 't'),(2323629, 't'),(1487601, 't'),(673949, 't'),(2754957, 't'),(230733, 't'),(1065030, 't'),(1129471, 't
'),(404997, 't'),(316316, 't'),(1386209, 't'),(959467, 't'),(1569753, 't'),(358471, 't'),(2847428, 't'),(965042, 't'),(1525513, 't'),(1001463, 't'),(2358189, 't'),(2176126, 't'),(1594620, 't')
,(2652428, 't'),(2109750, 't'),(2965494, 't'),(1844303, 't'),(2876356, 't'),(2729186, 't'),(2765363, 't'),(2252513, 't'),(3220676, 't'),(2741003, 't'),(2979822, 't'),(2029942, 't'),(3129719, '
t'),(2759888, 't'),(1176048, 't'),(2720965, 't'),(132493, 't'),(3046326, 't'),(2929583, 't'),(1887920, 't'),(773779, 't'),(1773655, 't'),(682237, 't'),(1706368, 't'),(2097531, 't'),(1813380, '
t'),(1610597, 't'),(192177, 't'),(852732, 't'),(1616165, 't'),(1480633, 't'),(563609, 't'),(2204588, 't'),(1964112, 't'),(1280315, 't'),(2659920, 't'),(3157192, 't'),(1544963, 't'),(3065929, '
t'),(670861, 't'),(1622769, 't'),(1173553, 't'),(2355658, 't'),(1430503, 't'),(2161775, 't'),(1627110, 't'),(1318118, 't'),(1906724, 't'),(948941, 't'),(1777792, 't'),(2391830, 't'),(1916562, 
't'),(3053400, 't'),(1145107, 't'),(869603, 't'),(3061605, 't'),(2617459, 't'),(332543, 't'),(1125429, 't'),(116886, 't'),(538354, 't'),(830639, 't'),(1995099, 't'),(1780541, 't'),(402960, 't'
),(150265, 't'),(1817014, 't'),(2186808, 't'),(1268440, 't'),(1607372, 't'),(1626253, 't'),(2724239, 't'),(2024801, 't'),(1835173, 't'),(3028359, 't'),(128146, 't'),(2618604, 't'),(2669122, 't
'),(1326319, 't'),(2039700, 't'),(312283, 't'),(2918855, 't'),(1898028, 't'),(3312109, 't'),(1411132, 't'),(12642, 't'),(201244, 't'),(910367, 't'),(2069434, 't'),(1622781, 't'),(1882669, 't')
,(3276390, 't'),(541014, 't'),(2806557, 't'),(3016516, 't'),(2119883, 't'),(761510, 't'),(1229675, 't'),(2831464, 't'),(2271804, 't'),(1854897, 't'),(1928566, 't'),(1317706, 't'),(2049937, 't'
),(1572702, 't'),(1947228, 't'),(2841458, 't'),(1091240, 't'),(964837, 't'),(2077410, 't'),(2708100, 't'),(667023, 't'),(1165342, 't'),(824044, 't'),(2739173, 't'),(775283, 't'),(1250938, 't')

Can we get PostgreSQL FDW up and running ASAP?

Assignee Loading
Time tracking Loading