#!/usr/bin/env bash
set -euo pipefail

docker exec docker-db_postgres-1 psql -U postgres -d dify -c "
SELECT id,
       conversation_id,
       status,
       answer IS NOT NULL AS has_answer,
       left(query, 80) AS q,
       left(error, 180) AS err,
       created_at,
       updated_at
FROM messages
ORDER BY created_at DESC
LIMIT 8;
"