Отладка данных в PostgreSQL — проверка состояния БД, поиск аномалий, анализ связей между таблицами.
query)SELECT column_name, data_type, is_nullable
FROM information_schema.columns
WHERE table_name = 'Todo';
SELECT id, title, status, "userId" FROM "Todo" WHERE description IS NULL OR description = '';
SELECT status, COUNT(*) as count FROM "Todo" GROUP BY status;
SELECT t.id, t.title, t."updatedAt", u.name as user_name
FROM "Todo" t JOIN "User" u ON t."userId" = u.id
WHERE t.status = 'PENDING' AND t."updatedAt" < NOW() - INTERVAL '7 days';
SELECT u.name, u.email, COUNT(t.id) as todo_count
FROM "User" u LEFT JOIN "Todo" t ON u.id = t."userId"
GROUP BY u.id, u.name, u.email;