Observability Logs

Query history and performance metrics

Queries used

data_query

Top intent

16657

Avg time (ms)

47,923

Tokens used

#	Question	Intent	Time (ms)	Rows	Tokens
1	qual a demografia dos pacientes disponvieis para analise?	data_query	23692	21	14230
SQL Generated `SELECT plano_saude, COUNT() AS total, ROUND(COUNT() * 100.0 / (SELECT COUNT(*) FROM pacientes), 1) AS percentual FROM pacientes GROUP BY plano_saude ORDER BY total DESC`
2	quais sao os status dos exames?	data_query	12062	3	16037
SQL Generated `SELECT status, COUNT() AS total, ROUND(COUNT() * 100.0 / (SELECT COUNT(*) FROM exames), 1) AS percentual FROM exames GROUP BY status ORDER BY total DESC`
3	Perfil completo do paciente 40	data_query	14216	8	17656
SQL Generated `patient_profile(paciente_id=40)`

qual a demografia dos pacientes disponvieis para analise?

data_query

23692 ms 21 rows 14230 tkns

View SQL

SELECT plano_saude, COUNT(*) AS total,
       ROUND(COUNT(*) * 100.0 / (SELECT COUNT(*) FROM pacientes), 1) AS percentual
FROM pacientes
GROUP BY plano_saude
ORDER BY total DESC

quais sao os status dos exames?

data_query

12062 ms 3 rows 16037 tkns

View SQL

SELECT status, COUNT(*) AS total,
       ROUND(COUNT(*) * 100.0 / (SELECT COUNT(*) FROM exames), 1) AS percentual
FROM exames
GROUP BY status
ORDER BY total DESC

Perfil completo do paciente 40

data_query

14216 ms 8 rows 17656 tkns

View SQL

patient_profile(paciente_id=40)