Return Return       Update Update       PDF PDF     

Database : Statistics of activity Database : Statistics of activity
datid
oid(10)		datname
name(2147483647)		pid
int4(11)		leader_pid
int4(11)		usesysid
oid(10)		usename
name(2147483647)		application_name
text(2147483647)		client_addr
inet(2147483647)		client_hostname
text(2147483647)		client_port
int4(11)		backend_start
timestamptz(35)		xact_start
timestamptz(35)		query_start
timestamptz(35)		state_change
timestamptz(35)		wait_event_type
text(2147483647)		wait_event
text(2147483647)		state
text(2147483647)		backend_xid
xid(2147483647)		backend_xmin
xid(2147483647)		query_id
int8(20)		query
text(2147483647)		backend_type
text(2147483647)
5postgres1427 10rdsadminpg_cron scheduler   2025-10-09 16:28:05.073515-03   ExtensionExtension   804233201376169930 pg_cron launcher
  1428 10rdsadmin    2025-10-09 16:28:05.073701-03   ActivityLogicalLauncherMain     logical replication launcher
3333716331revizia2065 16402postgrescore-api-job10.0.24.185 255372025-12-09 07:06:00.041521-03 2025-12-09 07:06:00.512939-032025-12-09 07:06:00.512972-03ClientClientReadidle  3694949039461716331COMMITclient backend
5postgres20669 3333668727rdsproxyadmin 10.0.24.185 576532025-12-09 05:26:00.121135-03 2025-12-09 07:07:29.568559-032025-12-09 07:07:29.568624-03ClientClientReadidle  2731926746234896378SELECT current_setting('transaction_read_only') AS transaction_read_only, current_setting('max_connections') AS max_connections, EXTRACT(EPOCH FROM now() - pg_postmaster_start_time()) AS uptime;client backend
5postgres20670 3333668727rdsproxyadmin 10.0.24.138 597032025-12-09 05:26:00.212713-03 2025-12-09 07:07:28.876782-032025-12-09 07:07:28.876855-03ClientClientReadidle  2731926746234896378SELECT current_setting('transaction_read_only') AS transaction_read_only, current_setting('max_connections') AS max_connections, EXTRACT(EPOCH FROM now() - pg_postmaster_start_time()) AS uptime;client backend
5postgres20671 3333668727rdsproxyadmin 10.0.24.253 160272025-12-09 05:26:00.350406-03 2025-12-09 07:07:29.054158-032025-12-09 07:07:29.054236-03ClientClientReadidle  2731926746234896378SELECT current_setting('transaction_read_only') AS transaction_read_only, current_setting('max_connections') AS max_connections, EXTRACT(EPOCH FROM now() - pg_postmaster_start_time()) AS uptime;client backend
3333716331revizia768 16402postgrescore-api10.0.24.71 530872025-12-09 07:00:00.018456-03 2025-12-09 07:07:27.543933-032025-12-09 07:07:27.543986-03ClientClientReadidle   COMMITclient backend
5postgres20672 3333668727rdsproxyadmin 10.0.20.251 521372025-12-09 05:26:00.509236-03 2025-12-09 07:07:28.983952-032025-12-09 07:07:28.984035-03ClientClientReadidle  2731926746234896378SELECT current_setting('transaction_read_only') AS transaction_read_only, current_setting('max_connections') AS max_connections, EXTRACT(EPOCH FROM now() - pg_postmaster_start_time()) AS uptime;client backend
5postgres20674 3333668727rdsproxyadmin 10.0.20.84 118132025-12-09 05:26:00.887763-03 2025-12-09 07:07:29.237272-032025-12-09 07:07:29.237321-03ClientClientReadidle  2731926746234896378SELECT current_setting('transaction_read_only') AS transaction_read_only, current_setting('max_connections') AS max_connections, EXTRACT(EPOCH FROM now() - pg_postmaster_start_time()) AS uptime;client backend
1665815312documents32747 16402postgresdownload-document-api10.0.24.253 287972025-12-09 06:56:00.017635-03 2025-12-09 07:06:50.257329-032025-12-09 07:06:50.258277-03ClientClientReadidle  3694949039461716331COMMITclient backend
5postgres32180 3333668727rdsproxyadmin 10.0.24.81 569692025-12-09 03:20:00.563654-03 2025-12-09 07:07:29.532424-032025-12-09 07:07:29.532493-03ClientClientReadidle  2731926746234896378SELECT current_setting('transaction_read_only') AS transaction_read_only, current_setting('max_connections') AS max_connections, EXTRACT(EPOCH FROM now() - pg_postmaster_start_time()) AS uptime;client backend
16450fiscal2068 16402postgresfiscal-intelligence-api10.0.20.251 590192025-12-09 07:06:00.261657-03 2025-12-09 07:06:00.507117-032025-12-09 07:06:00.507135-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
5postgres20675 3333668727rdsproxyadmin 10.0.20.46 357832025-12-09 05:26:00.948308-03 2025-12-09 07:07:29.444501-032025-12-09 07:07:29.444587-03ClientClientReadidle  2731926746234896378SELECT current_setting('transaction_read_only') AS transaction_read_only, current_setting('max_connections') AS max_connections, EXTRACT(EPOCH FROM now() - pg_postmaster_start_time()) AS uptime;client backend
1665815312documents624 16402postgresnfe-lambda-aws10.0.24.185 522312025-12-09 06:59:00.01312-03 2025-12-09 07:07:26.887037-032025-12-09 07:07:26.889624-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents25054 16402postgrescfe-job-download-documentos-recorrentes10.0.24.138 460192025-12-09 05:59:03.97968-03 2025-12-09 07:07:25.234387-032025-12-09 07:07:25.234663-03ClientClientReadidle    client backend
5postgres20676 3333668727rdsproxyadmin 10.0.24.71 463012025-12-09 05:26:00.95202-03 2025-12-09 07:07:29.002473-032025-12-09 07:07:29.00254-03ClientClientReadidle  2731926746234896378SELECT current_setting('transaction_read_only') AS transaction_read_only, current_setting('max_connections') AS max_connections, EXTRACT(EPOCH FROM now() - pg_postmaster_start_time()) AS uptime;client backend
3333716331revizia2074 16402postgresrvz-sintegra-job10.0.24.253 653632025-12-09 07:06:02.113317-03 2025-12-09 07:06:07.816766-032025-12-09 07:06:07.816807-03ClientClientReadidle    client backend
3333716331revizia2078 16402postgreslambda-go-revizia-metrics10.0.24.81 127792025-12-09 07:06:05.971385-03 2025-12-09 07:06:06.870737-032025-12-09 07:06:07.638798-03ClientClientReadidle  957357389483338053
select e.cnpj as CNpj,
(dsc is null) as NovaEmpresa,
dsc.data_inicio as DataInicio,
dsc.data_fim as DataFim
from certificado c
left join lateral (select ce2.id,
ce2.certificado_id,
ce2.empresa_id,
ce2.created_at
from conta_empresa ce2
left join empresa e2 on (ce2.empresa_id = e2.id)
where ce2.certificado_id = c.id
and ce2.empresa_id = (select e3.id
from empresa e3
inner join conta_empresa ce3 on e3.id = ce3.empresa_id
inner join certificado c3 on ce3.certificado_id = c3.id
where substring(e3.cnpj,1,8) = substring(e2.cnpj,1,8)
and c3.data_expiracao > NOW()
and e3.tipo_empresa = 'MATRIZ'
limit 1)
and c.data_expiracao > NOW()
and e2.tipo_empresa = 'MATRIZ'
order by created_at desc
limit 1) ce on (true)
left join empresa e on (ce.empresa_id = e.id)
left join download_sped_controle_empresa dsc on (dsc.conta_empresa_id = ce.id)
where ce.id is not null
and e.tipo_empresa = 'MATRIZ'
order by (dsc is null), dsc.data_inicio, ce.created_at desc		client backend
1665815312documents27017 16402postgrescfe-job-download-documentos-recorrentes10.0.24.185 273672025-12-09 06:14:02.736667-03 2025-12-09 07:07:27.643696-032025-12-09 07:07:27.643743-03ClientClientReadidle    client backend
1665815312documents2092 16402postgresdocument-worker10.0.24.81 254712025-12-09 07:06:08.581638-03 2025-12-09 07:06:08.772228-032025-12-09 07:06:08.773149-03ClientClientReadidle  3694949039461716331COMMITclient backend
3333716331revizia1772 16402postgrescore-api10.0.24.81 386952025-12-09 07:04:04.494732-03 2025-12-09 07:07:27.555783-032025-12-09 07:07:27.555843-03ClientClientReadidle  3694949039461716331COMMITclient backend
3333716331revizia1773 16402postgrescore-api10.0.24.253 196392025-12-09 07:04:04.505128-03 2025-12-09 07:07:28.811144-032025-12-09 07:07:28.81117-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents31584 16402postgrescfe-job-download-documentos-recorrentes10.0.24.81 562792025-12-09 06:48:02.817126-03 2025-12-09 07:05:57.73405-032025-12-09 07:05:57.734273-03ClientClientReadidle    client backend
1665815312documents1628 16402postgresnfe-lambda-aws10.0.20.251 353152025-12-09 07:03:07.949804-03 2025-12-09 07:07:26.265856-032025-12-09 07:07:26.268496-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents1917 16402postgresnfe-lambda-aws10.0.24.138 171532025-12-09 07:05:01.253374-03 2025-12-09 07:05:01.992302-032025-12-09 07:05:01.994804-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents1918 16402postgresnfe-lambda-aws10.0.24.138 132472025-12-09 07:05:01.261921-03 2025-12-09 07:07:11.11306-032025-12-09 07:07:11.115756-03ClientClientReadidle  3694949039461716331COMMITclient backend
3333716331revizia1921 16402postgresrvz-sintegra-job10.0.24.138 121072025-12-09 07:05:02.128909-03 2025-12-09 07:05:37.807848-032025-12-09 07:05:37.807966-03ClientClientReadidle    client backend
1665815312documents2178 16402postgresdownload-document-api10.0.24.138 167152025-12-09 07:07:00.020131-03 2025-12-09 07:07:29.567592-032025-12-09 07:07:29.567741-03ClientClientReadidle    client backend
1665815312documents2191 16402postgresrvz-esocial-importador10.0.24.185 428712025-12-09 07:07:05.056037-03 2025-12-09 07:07:05.095373-032025-12-09 07:07:05.096419-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents32211 16402postgresecac-situacao-fiscal-api10.0.20.251 511872025-12-09 06:52:31.529102-03 2025-12-09 07:07:07.862083-032025-12-09 07:07:07.862198-03ClientClientReadidle    client backend
16450fiscal2194 16402postgresrvz-esocial-importador10.0.24.253 206592025-12-09 07:07:05.100377-03 2025-12-09 07:07:08.947443-032025-12-09 07:07:08.947531-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents632 16402postgresnfe-lambda-aws10.0.24.138 576692025-12-09 06:59:00.415621-03 2025-12-09 07:05:03.063083-032025-12-09 07:05:03.065044-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents32498 16402postgrescfe-job-download-documentos-recorrentes10.0.20.46 125472025-12-09 06:54:09.645382-03 2025-12-09 07:07:29.579778-032025-12-09 07:07:29.57987-03ClientClientReadidle    client backend
3333716331revizia1774 16402postgrescore-api10.0.24.71 16492025-12-09 07:04:04.50611-03 2025-12-09 07:07:27.560556-032025-12-09 07:07:27.560591-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents1633 16402postgresnfe-lambda-aws10.0.24.138 355972025-12-09 07:03:08.479087-03 2025-12-09 07:05:01.295775-032025-12-09 07:05:01.29816-03ClientClientReadidle  3694949039461716331COMMITclient backend
16451cloudworks7651 16402postgrespgAdmin 4 - DB:cloudworks10.0.28.38 533262025-12-03 17:07:43.001398-03 2025-12-03 17:07:44.69647-032025-12-03 17:07:44.701295-03ClientClientReadidle  -3984013937811865237
SELECT
roles.oid as id, roles.rolname as name,
roles.rolsuper as is_superuser,
CASE WHEN roles.rolsuper THEN true ELSE roles.rolcreaterole END as
can_create_role,
CASE WHEN roles.rolsuper THEN true
ELSE roles.rolcreatedb END as can_create_db,
CASE WHEN 'pg_signal_backend'=ANY(ARRAY(WITH RECURSIVE cte AS (
SELECT pg_roles.oid,pg_roles.rolname FROM pg_roles
WHERE pg_roles.oid = roles.oid
UNION ALL
SELECT m.roleid,pgr.rolname FROM cte cte_1
JOIN pg_auth_members m ON m.member = cte_1.oid
JOIN pg_roles pgr ON pgr.oid = m.roleid)
SELECT rolname FROM cte)) THEN True
ELSE False END as can_signal_backend
FROM
pg_catalog.pg_roles as roles
WHERE
rolname = current_user		client backend
1665815312documents450 16402postgrescfe-job-download-documentos10.0.20.251 248712025-12-09 06:57:21.617548-03 2025-12-09 07:07:29.116206-032025-12-09 07:07:29.116247-03ClientClientReadidle    client backend
1665815312documents1634 16402postgresnfe-lambda-aws10.0.24.138 449232025-12-09 07:03:08.557545-03 2025-12-09 07:05:01.572937-032025-12-09 07:05:01.575123-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents2195 16402postgreslambda-go-revizia-metrics10.0.20.84 637892025-12-09 07:07:05.652734-03 2025-12-09 07:07:06.767671-032025-12-09 07:07:06.772502-03ClientClientReadidle  -8625620423702777529WITH status_lista AS (
SELECT unnest(ARRAY[
'PENDENTE',
'CONCLUIDO',
'EM_PROCESSAMENTO',
'COM_ERRO',
'COM_ERRO_PERMANENTE'
]) AS status
),
recorrente_lista AS (
SELECT unnest(ARRAY[true, false]) AS recorrente
),
combinacoes AS (
SELECT s.status, r.recorrente
FROM status_lista s
CROSS JOIN recorrente_lista r
),
contagens AS (
SELECT
status,
recorrente,
COUNT(*) AS qtd
FROM cfe_periodo_importacao_job
WHERE data_fim <= now() AT TIME ZONE 'America/Sao_Paulo'
AND status IS NOT NULL
AND status IN ('PENDENTE','CONCLUIDO','EM_PROCESSAMENTO','COM_ERRO','COM_ERRO_PERMANENTE')
GROUP BY status, recorrente
)
SELECT
COALESCE(ct.qtd, 0) AS "Qtd",
c.status AS "Status",
c.recorrente AS "Recorrente"
FROM combinacoes c
LEFT JOIN contagens ct
ON c.status = ct.status
AND c.recorrente = ct.recorrente
ORDER BY c.status, c.recorrente;
client backend
1665815312documents22415 16402postgrescfe-job-download-documentos10.0.24.138 369752025-12-09 05:39:18.697025-03 2025-12-09 07:07:28.840758-032025-12-09 07:07:28.840975-03ClientClientReadidle    client backend
3333716331revizia2097 16402postgresnfe-lambda-aws10.0.20.84 110812025-12-09 07:06:16.549786-03 2025-12-09 07:06:16.568462-032025-12-09 07:06:16.568499-03ClientClientReadidle  -6478377226548179738 SELECT cn.cnpj, cn.notificacao, cn.valor, cn.intervalo, e.email FROM configuracao_notificacao cn INNER JOIN configuracao_notificacao_email cne ON cn.id = cne.configuracao_notificacao_id INNER JOIN email e ON e.id = cne.email_id WHERE cn.notificacao = $1 AND cn.tipo_notificacao = 'EMAIL' AND cn.cnpj IN ($2) client backend
3333716331revizia32668 16402postgrescore-api10.0.24.138 198792025-12-09 06:55:18.863528-03 2025-12-09 07:07:28.811141-032025-12-09 07:07:28.811205-03ClientClientReadidle   COMMITclient backend
3333716331revizia2197 16402postgreslambda-go-revizia-metrics10.0.24.185 396632025-12-09 07:07:05.911298-03 2025-12-09 07:07:06.863816-032025-12-09 07:07:07.636583-03ClientClientReadidle  957357389483338053
select e.cnpj as CNpj,
(dsc is null) as NovaEmpresa,
dsc.data_inicio as DataInicio,
dsc.data_fim as DataFim
from certificado c
left join lateral (select ce2.id,
ce2.certificado_id,
ce2.empresa_id,
ce2.created_at
from conta_empresa ce2
left join empresa e2 on (ce2.empresa_id = e2.id)
where ce2.certificado_id = c.id
and ce2.empresa_id = (select e3.id
from empresa e3
inner join conta_empresa ce3 on e3.id = ce3.empresa_id
inner join certificado c3 on ce3.certificado_id = c3.id
where substring(e3.cnpj,1,8) = substring(e2.cnpj,1,8)
and c3.data_expiracao > NOW()
and e3.tipo_empresa = 'MATRIZ'
limit 1)
and c.data_expiracao > NOW()
and e2.tipo_empresa = 'MATRIZ'
order by created_at desc
limit 1) ce on (true)
left join empresa e on (ce.empresa_id = e.id)
left join download_sped_controle_empresa dsc on (dsc.conta_empresa_id = ce.id)
where ce.id is not null
and e.tipo_empresa = 'MATRIZ'
order by (dsc is null), dsc.data_inicio, ce.created_at desc		client backend
1665815312documents1780 16402postgresmensageria-api10.0.24.185 502772025-12-09 07:04:05.666557-03 2025-12-09 07:07:21.859017-032025-12-09 07:07:21.859029-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents772 16402postgresdownload-document-api10.0.24.138 202072025-12-09 07:00:00.425434-03 2025-12-09 07:07:00.033811-032025-12-09 07:07:00.033842-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
16450fiscal7583 16402postgrespgAdmin 4 - DB:fiscal10.0.28.38 490502025-12-03 17:07:06.770267-03 2025-12-09 07:07:14.379488-032025-12-09 07:07:14.383528-03ClientClientReadidle  -6488867169811202377/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
(SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 16450)) AS "Total",
(SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 16450)) AS "Active",
(SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 16450)) AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 16450)) AS "Transactions",
(SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 16450)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 16450)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
(SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 16450)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 16450)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 16450)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
(SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 16450)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 16450)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
(SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 16450)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 16450)) AS "Hits"
) t
client backend
16450fiscal2213 16402postgresrvz-esocial-importador10.0.24.253 332532025-12-09 07:07:08.795994-03 2025-12-09 07:07:08.927258-032025-12-09 07:07:08.927267-03ClientClientReadidle   ROLLBACKclient backend
5postgres7877 16402postgrespgAdmin 4 - CONN:453790010.0.28.38 564722025-12-03 17:09:08.27267-03 2025-12-08 19:13:11.720996-032025-12-08 19:13:11.72103-03ClientClientReadidle  -3200963977824915130SELECT oid, pg_catalog.format_type(oid, NULL) AS typname FROM pg_catalog.pg_type WHERE oid = ANY($1) ORDER BY oid;client backend
1665815312documents1924 16402postgresnfe-lambda-aws10.0.24.71 188412025-12-09 07:05:02.547079-03 2025-12-09 07:07:28.074247-032025-12-09 07:07:28.07691-03ClientClientReadidle  3694949039461716331COMMITclient backend
16450fiscal2216 16402postgreseconet-scrapper10.0.24.81 385512025-12-09 07:07:09.286567-03 2025-12-09 07:07:09.302571-032025-12-09 07:07:09.30258-03ClientClientReadidle  4808936042342407727SET application_name = 'econet-scrapper'client backend
1665815312documents32216 16402postgresmensageria-api10.0.24.253 265472025-12-09 06:52:33.199687-03 2025-12-09 07:06:16.995434-032025-12-09 07:06:16.99548-03ClientClientReadidle    client backend
3333716331revizia2111 16402postgresdctfweb-importador-from-sqs10.0.24.253 84352025-12-09 07:06:24.714237-03 2025-12-09 07:06:24.728211-032025-12-09 07:06:24.728224-03ClientClientReadidle    client backend
16384rdsadmin16273 10rdsadminPostgreSQL JDBC Driver  -12025-11-26 22:31:10.413433-03 2025-12-09 07:07:22.010012-032025-12-09 07:07:22.010024-03ClientClientReadidle  3326913007740874862SELECT value FROM rds_heartbeat2client backend
16450fiscal2110 16402postgresdctfweb-importador-from-sqs10.0.20.251 352512025-12-09 07:06:24.713946-03 2025-12-09 07:06:24.730251-032025-12-09 07:06:24.730378-03ClientClientReadidle    client backend
3333716331revizia7606 16402postgrespgAdmin 4 - DB:revizia10.0.28.38 559702025-12-03 17:07:19.220611-03 2025-12-08 15:10:33.401084-032025-12-08 15:10:33.401422-03ClientClientReadidle  7591777486578982143/*pga4dash*/
SELECT
gid,
database,
owner,
transaction,
pg_catalog.to_char(prepared, 'YYYY-MM-DD HH24:MI:SS TZ') AS prepared
FROM
pg_catalog.pg_prepared_xacts
WHERE
database = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 3333716331)ORDER BY
gid, database, owner		client backend
16450fiscal2217 16402postgreseconet-scrapper10.0.20.46 590812025-12-09 07:07:11.055331-03 2025-12-09 07:07:11.075491-032025-12-09 07:07:11.075501-03ClientClientReadidle  4808936042342407727SET application_name = 'econet-scrapper'client backend
1665815312documents1925 16402postgresnfe-lambda-aws10.0.24.71 532632025-12-09 07:05:02.748023-03 2025-12-09 07:05:02.948476-032025-12-09 07:05:02.951206-03ClientClientReadidle  3694949039461716331COMMITclient backend
16450fiscal1782 16402postgreslambda-go-revizia-metrics10.0.24.81 619592025-12-09 07:04:05.870957-03 2025-12-09 07:06:06.596801-032025-12-09 07:06:06.600789-03ClientClientReadidle  -6488867169811202377
WITH numeracoes AS (
SELECT
COUNT(CASE WHEN nu.utilizado = 'SIM' THEN 1 END) AS qtd_numeracao_utilizada,
COUNT(CASE WHEN nu.utilizado = 'NAO' THEN 1 END) AS qtd_numeracao_disponivel
FROM numeracao_utilizada nu
JOIN controle_numeracao cn ON nu.controle_numeracao_id = cn.id
WHERE cn.id = (SELECT MAX(id) FROM controle_numeracao)
),
notas_emitidas AS (
SELECT
to_char(data_rps, 'YYYY-MM') AS periodo,
COUNT(1) AS quantidade_notas_emitidas
FROM dados_emissao_nfse
WHERE serie_rps = '01SN'
GROUP BY to_char(data_rps, 'YYYY-MM')
ORDER BY to_char(data_rps, 'YYYY-MM') DESC
LIMIT 1
)
SELECT
n.qtd_numeracao_utilizada QtdUtilizada,
n.qtd_numeracao_disponivel QtdDisponivel,
ne.periodo Periodo,
ne.quantidade_notas_emitidas QtdNotasEmitidas
FROM numeracoes n
CROSS JOIN notas_emitidas ne		client backend
1665815312documents637 16402postgrescfe-job-download-documentos10.0.24.185 535412025-12-09 06:59:02.07003-03 2025-12-09 07:05:02.209995-032025-12-09 07:05:02.210022-03ClientClientReadidle    client backend
1665815312documents2220 16402postgresmensageria-api10.0.24.185 234532025-12-09 07:07:13.365589-03 2025-12-09 07:07:28.644321-032025-12-09 07:07:28.645601-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents22645 16402postgrespgAdmin 4 - CONN:959789210.0.28.38 483562025-12-08 13:38:23.534647-03 2025-12-08 14:26:01.015244-032025-12-08 14:26:01.015279-03ClientClientReadidle  -3200963977824915130SELECT oid, pg_catalog.format_type(oid, NULL) AS typname FROM pg_catalog.pg_type WHERE oid = ANY($1) ORDER BY oid;client backend
1665815312documents2112 16402postgresdctfweb-importador-from-sqs10.0.24.253 628492025-12-09 07:06:24.715475-03 2025-12-09 07:06:24.729399-032025-12-09 07:06:24.729498-03ClientClientReadidle    client backend
16450fiscal482 16402postgresfiscal-intelligence-sped-job10.0.24.138 242832025-12-09 06:57:45.262553-03 2025-12-09 07:05:35.652491-032025-12-09 07:05:35.652553-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
1665815312documents2113 16402postgrescfe-job-download-documentos-recorrentes10.0.20.46 480192025-12-09 07:06:24.879209-03 2025-12-09 07:07:25.877726-032025-12-09 07:07:25.877797-03ClientClientReadidle    client backend
1665815312documents31792 16402postgrescfe-job-download-documentos10.0.24.71 480572025-12-09 06:49:21.617088-03 2025-12-09 07:06:04.568018-032025-12-09 07:06:04.568258-03ClientClientReadidle    client backend
1665815312documents640 16402postgresnfe-lambda-aws10.0.20.251 37692025-12-09 06:59:02.305172-03 2025-12-09 07:05:04.82529-032025-12-09 07:05:04.828012-03ClientClientReadidle  3694949039461716331COMMITclient backend
3333716331revizia2119 16402postgresmensageria-api10.0.20.251 221652025-12-09 07:06:29.579959-03 2025-12-09 07:07:29.582452-032025-12-09 07:07:29.582693-03ClientClientReadidle    client backend
1665815312documents1926 16402postgresnfe-lambda-aws10.0.20.84 173292025-12-09 07:05:02.838416-03 2025-12-09 07:05:03.931528-032025-12-09 07:05:03.934258-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents31895 16402postgrescfe-job-download-documentos-recorrentes10.0.24.71 403132025-12-09 06:50:01.913403-03 2025-12-09 07:07:27.734451-032025-12-09 07:07:27.734529-03ClientClientReadidle    client backend
16450fiscal1927 16402postgresfiscal-intelligence-sped-analises-job10.0.24.185 186792025-12-09 07:05:04.148386-03 2025-12-09 07:07:24.295796-032025-12-09 07:07:24.295808-03ClientClientReadidle  3694949039461716331COMMITclient backend
3333716331revizia2122 16402postgresrvz-sintegra-job10.0.24.81 202652025-12-09 07:06:32.110465-03 2025-12-09 07:07:07.863218-032025-12-09 07:07:07.863577-03ClientClientReadidle    client backend
5postgres7629 16402postgrespgAdmin 4 - DB:postgres10.0.28.38 504662025-12-03 17:07:31.078511-03 2025-12-08 19:13:18.870724-032025-12-08 19:13:18.871001-03ClientClientReadidle  5361310776981672498SELECT CASE
WHEN (SELECT count(extname) FROM pg_catalog.pg_extension WHERE extname='bdr') > 0
THEN 'pgd'
WHEN (SELECT COUNT(*) FROM pg_replication_slots) > 0
THEN 'log'
ELSE NULL
END as type;		client backend
1665815312documents1934 16402postgresdocument-api10.0.24.185 92712025-12-09 07:05:04.59151-032025-12-09 07:07:29.658545-032025-12-09 07:07:29.662502-032025-12-09 07:07:29.662502-03  active 1033481731-6815546958608512757select * from pg_stat_activityclient backend
16450fiscal2130 16402postgresrps-barueri-emissao-api10.0.24.71 428572025-12-09 07:06:36.815548-03 2025-12-09 07:06:50.442606-032025-12-09 07:06:50.442633-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents641 16402postgresnfe-lambda-aws10.0.24.253 547692025-12-09 06:59:02.369517-03 2025-12-09 07:07:16.751528-032025-12-09 07:07:16.754219-03ClientClientReadidle  3694949039461716331COMMITclient backend
3333716331revizia1935 16402postgresnfe-lambda-aws10.0.24.138 601512025-12-09 07:05:05.229529-03 2025-12-09 07:05:44.845883-032025-12-09 07:05:44.845932-03ClientClientReadidle  -7654691353143170484 SELECT cn.cnpj, cn.notificacao, cn.valor, cn.intervalo, e.email FROM configuracao_notificacao cn INNER JOIN configuracao_notificacao_email cne ON cn.id = cne.configuracao_notificacao_id INNER JOIN email e ON e.id = cne.email_id WHERE cn.notificacao = $1 AND cn.tipo_notificacao = 'EMAIL' AND cn.cnpj IN ($2,$3) client backend
1665815312documents545 16402postgrescfe-job-download-documentos-recorrentes10.0.20.251 210612025-12-09 06:58:12.649753-03 2025-12-09 07:07:29.643298-032025-12-09 07:07:29.643639-03ClientClientReadidle    client backend
1665815312documents2137 16402postgresintegracao-fluxo-pagamento-worker10.0.20.251 559792025-12-09 07:06:38.851262-032025-12-09 07:07:29.654975-032025-12-09 07:07:29.660369-032025-12-09 07:07:29.660625-03ClientClientReadidle in transaction 1033481731-3623911024636025028select integracao0_.id as id1_2_0_, integracao0_.ativo as ativo2_2_0_, integracao0_.cnpj as cnpj3_2_0_, integracao0_.formato_documento as formato_4_2_0_, integracao0_.id_tipo_documento_remoto as id_tipo_5_2_0_, integracao0_.id_workflow as id_workf6_2_0_, integracao0_.senha as senha7_2_0_, integracao0_.tipo_documento as tipo_doc8_2_0_, integracao0_.usuario as usuario9_2_0_ from integ_flx_pag integracao0_ where integracao0_.id=$1client backend
16450fiscal2141 16402postgreseconet-scrapper10.0.20.84 378052025-12-09 07:06:42.627646-03 2025-12-09 07:06:42.647197-032025-12-09 07:06:42.647232-03ClientClientReadidle  4808936042342407727SET application_name = 'econet-scrapper'client backend
16450fiscal2143 16402postgreslambda-go-revizia-metrics10.0.24.138 195712025-12-09 07:06:43.659528-03 2025-12-09 07:07:06.637189-032025-12-09 07:07:06.641534-03ClientClientReadidle  -6488867169811202377
WITH numeracoes AS (
SELECT
COUNT(CASE WHEN nu.utilizado = 'SIM' THEN 1 END) AS qtd_numeracao_utilizada,
COUNT(CASE WHEN nu.utilizado = 'NAO' THEN 1 END) AS qtd_numeracao_disponivel
FROM numeracao_utilizada nu
JOIN controle_numeracao cn ON nu.controle_numeracao_id = cn.id
WHERE cn.id = (SELECT MAX(id) FROM controle_numeracao)
),
notas_emitidas AS (
SELECT
to_char(data_rps, 'YYYY-MM') AS periodo,
COUNT(1) AS quantidade_notas_emitidas
FROM dados_emissao_nfse
WHERE serie_rps = '01SN'
GROUP BY to_char(data_rps, 'YYYY-MM')
ORDER BY to_char(data_rps, 'YYYY-MM') DESC
LIMIT 1
)
SELECT
n.qtd_numeracao_utilizada QtdUtilizada,
n.qtd_numeracao_disponivel QtdDisponivel,
ne.periodo Periodo,
ne.quantidade_notas_emitidas QtdNotasEmitidas
FROM numeracoes n
CROSS JOIN notas_emitidas ne		client backend
1665815312documents32694 16402postgrescfe-job-download-documentos10.0.24.253 120092025-12-09 06:55:30.757999-03 2025-12-09 07:07:29.322822-032025-12-09 07:07:29.322861-03ClientClientReadidle    client backend
1665815312documents31623 16402postgrescfe-job-download-documentos-recorrentes10.0.20.84 585412025-12-09 06:48:15.994054-03 2025-12-09 07:07:29.366726-032025-12-09 07:07:29.366778-03ClientClientReadidle    client backend
1665815312documents2171 16402postgrescte-lambda-aws10.0.20.46 451572025-12-09 07:06:58.901133-03 2025-12-09 07:06:59.256015-032025-12-09 07:06:59.258194-03ClientClientReadidle  3694949039461716331COMMITclient backend
3333716331revizia643 16402postgresnfe-lambda-aws10.0.24.81 138112025-12-09 06:59:02.48549-03 2025-12-09 07:05:03.006649-032025-12-09 07:05:03.006691-03ClientClientReadidle  -5084201902893922806SELECT ce.conta_id FROM conta_empresa ce INNER JOIN empresa e ON ce.empresa_id = e.id INNER JOIN conta c on ce.conta_id = c.id WHERE e.cnpj IN ($1, $2) AND c.status = 'ATIVO' AND c.id <> 1 LIMIT 1client backend
1665815312documents1941 16402postgreslambda-go-revizia-metrics10.0.24.138 162792025-12-09 07:05:05.650921-03 2025-12-09 07:06:06.720961-032025-12-09 07:06:06.724655-03ClientClientReadidle  -8625620423702777529WITH status_lista AS (
SELECT unnest(ARRAY[
'PENDENTE',
'CONCLUIDO',
'EM_PROCESSAMENTO',
'COM_ERRO',
'COM_ERRO_PERMANENTE'
]) AS status
),
recorrente_lista AS (
SELECT unnest(ARRAY[true, false]) AS recorrente
),
combinacoes AS (
SELECT s.status, r.recorrente
FROM status_lista s
CROSS JOIN recorrente_lista r
),
contagens AS (
SELECT
status,
recorrente,
COUNT(*) AS qtd
FROM cfe_periodo_importacao_job
WHERE data_fim <= now() AT TIME ZONE 'America/Sao_Paulo'
AND status IS NOT NULL
AND status IN ('PENDENTE','CONCLUIDO','EM_PROCESSAMENTO','COM_ERRO','COM_ERRO_PERMANENTE')
GROUP BY status, recorrente
)
SELECT
COALESCE(ct.qtd, 0) AS "Qtd",
c.status AS "Status",
c.recorrente AS "Recorrente"
FROM combinacoes c
LEFT JOIN contagens ct
ON c.status = ct.status
AND c.recorrente = ct.recorrente
ORDER BY c.status, c.recorrente;
client backend
16450fiscal1826 16402postgresprocessador-linhas-sped-api10.0.24.253 614812025-12-09 07:04:24.09444-03 2025-12-09 07:07:29.578866-032025-12-09 07:07:29.578982-03ClientClientReadidle    client backend
1665815312documents2172 16402postgrescte-lambda-aws10.0.20.84 330292025-12-09 07:06:59.066225-03 2025-12-09 07:06:59.355839-032025-12-09 07:06:59.358286-03ClientClientReadidle  3694949039461716331COMMITclient backend
16450fiscal1942 16402postgreslambda-go-revizia-metrics10.0.20.251 434032025-12-09 07:05:05.7731-03 2025-12-09 07:05:13.300333-032025-12-09 07:05:13.368039-03ClientClientReadidle  8947452279668419970
select count(*), atr.code
From document_analysis da
inner join analysis_type_result atr on da.analysis_type_result_id = atr.id
where da.status = 'ERROR'
and periodo >= $1
group by atr.code
order by 1 desc
limit 100		client backend
3333716331revizia1943 16402postgreslambda-go-revizia-metrics10.0.24.253 64512025-12-09 07:05:05.912305-03 2025-12-09 07:05:06.841836-032025-12-09 07:05:07.610706-03ClientClientReadidle  957357389483338053
select e.cnpj as CNpj,
(dsc is null) as NovaEmpresa,
dsc.data_inicio as DataInicio,
dsc.data_fim as DataFim
from certificado c
left join lateral (select ce2.id,
ce2.certificado_id,
ce2.empresa_id,
ce2.created_at
from conta_empresa ce2
left join empresa e2 on (ce2.empresa_id = e2.id)
where ce2.certificado_id = c.id
and ce2.empresa_id = (select e3.id
from empresa e3
inner join conta_empresa ce3 on e3.id = ce3.empresa_id
inner join certificado c3 on ce3.certificado_id = c3.id
where substring(e3.cnpj,1,8) = substring(e2.cnpj,1,8)
and c3.data_expiracao > NOW()
and e3.tipo_empresa = 'MATRIZ'
limit 1)
and c.data_expiracao > NOW()
and e2.tipo_empresa = 'MATRIZ'
order by created_at desc
limit 1) ce on (true)
left join empresa e on (ce.empresa_id = e.id)
left join download_sped_controle_empresa dsc on (dsc.conta_empresa_id = ce.id)
where ce.id is not null
and e.tipo_empresa = 'MATRIZ'
order by (dsc is null), dsc.data_inicio, ce.created_at desc		client backend
1665815312documents2173 16402postgrescte-lambda-aws10.0.24.138 36412025-12-09 07:06:59.180772-03 2025-12-09 07:07:01.323259-032025-12-09 07:07:01.326161-03ClientClientReadidle  3694949039461716331COMMITclient backend
3333716331revizia22737 16402postgrespgAdmin 4 - CONN:251417610.0.28.38 515422025-12-08 13:38:53.651434-03 2025-12-08 14:14:50.783467-032025-12-08 14:14:50.784145-03ClientClientReadidle  -3200963977824915130SELECT oid, pg_catalog.format_type(oid, NULL) AS typname FROM pg_catalog.pg_type WHERE oid = ANY($1) ORDER BY oid;client backend
1665815312documents31313 16402postgrescfe-job-download-documentos10.0.24.185 153092025-12-09 06:45:40.569617-03 2025-12-09 07:07:28.616431-032025-12-09 07:07:28.61665-03ClientClientReadidle    client backend
3333716331revizia2222 16402postgrescore-api10.0.24.71 502912025-12-09 07:07:14.715543-03 2025-12-09 07:07:28.811398-032025-12-09 07:07:28.81156-03ClientClientReadidle  3694949039461716331COMMITclient backend
3333716331revizia2221 16402postgrescore-api10.0.24.185 557032025-12-09 07:07:14.713977-03 2025-12-09 07:07:27.545824-032025-12-09 07:07:27.545852-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents352 16402postgresmensageria-api10.0.24.185 186712025-12-09 06:56:20.546857-03 2025-12-09 07:07:28.642808-032025-12-09 07:07:28.643798-03ClientClientReadidle  3694949039461716331COMMITclient backend
16450fiscal2007 16402postgresfiscal-intelligence-sped-job10.0.24.138 339572025-12-09 07:05:25.559086-03 2025-12-09 07:05:37.274544-032025-12-09 07:05:37.274624-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
3333716331revizia2223 16402postgrescore-api10.0.20.46 301072025-12-09 07:07:14.745784-03 2025-12-09 07:07:29.568486-032025-12-09 07:07:29.568573-03ClientClientReadidle    client backend
1665815312documents1841 16402postgresintegracao-fluxo-pagamento-worker10.0.20.84 488052025-12-09 07:04:32.141303-03 2025-12-09 07:06:35.219816-032025-12-09 07:06:35.219827-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
1665815312documents2224 16402postgresmensageria-api10.0.24.81 570552025-12-09 07:07:15.916961-03 2025-12-09 07:07:28.643374-032025-12-09 07:07:28.644657-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents2008 16402postgresdocument-api10.0.24.138 156272025-12-09 07:05:25.720994-03 2025-12-09 07:07:10.273895-032025-12-09 07:07:10.274021-03ClientClientReadidle    client backend
16450fiscal27110 16402postgresfiscal-intelligence-core-job10.0.20.251 455512025-12-09 06:14:59.704273-032025-12-09 07:03:07.165886-032025-12-09 07:03:07.170301-032025-12-09 07:03:07.170313-03ClientClientReadidle in transaction 1033480906-3645052014744462256SELECT bk.id FROM book_keeping bk WHERE bk.cnpj = $1 AND bk.period IN ($2) AND bk.type = $3 AND bk.status = 'READY' client backend
16450fiscal1955 16402postgresecac-darf-job-download-documentos10.0.24.253 590852025-12-09 07:05:08.212581-03 2025-12-09 07:06:07.061899-032025-12-09 07:06:07.061935-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
16450fiscal1846 16402postgresecac-darf-job-download-documentos10.0.20.84 82212025-12-09 07:04:34.245358-03 2025-12-09 07:05:08.296546-032025-12-09 07:05:08.296614-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
1665815312documents2225 16402postgresmensageria-api10.0.20.84 502532025-12-09 07:07:15.918447-03 2025-12-09 07:07:28.643253-032025-12-09 07:07:28.64466-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents1589 16402postgresnfe-lambda-aws10.0.20.46 486432025-12-09 07:02:54.11723-03 2025-12-09 07:05:02.230551-032025-12-09 07:05:02.233208-03ClientClientReadidle  3694949039461716331COMMITclient backend
16450fiscal1965 16402postgresecac-darf-job-download-documentos10.0.24.253 149412025-12-09 07:05:08.25176-03 2025-12-09 07:05:08.302163-032025-12-09 07:05:08.302184-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
1665815312documents667 16402postgresnfe-lambda-aws10.0.24.71 246452025-12-09 06:59:09.089922-03 2025-12-09 07:05:11.536681-032025-12-09 07:05:11.538914-03ClientClientReadidle  3694949039461716331COMMITclient backend
3333716331revizia2226 16402postgrescertificado-api10.0.24.253 443172025-12-09 07:07:15.922412-03 2025-12-09 07:07:15.945552-032025-12-09 07:07:15.945571-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
1665815312documents2229 16402postgrescfe-job-download-documentos10.0.20.84 116532025-12-09 07:07:17.205764-03 2025-12-09 07:07:29.190578-032025-12-09 07:07:29.190677-03ClientClientReadidle    client backend
1665815312documents31114 16402postgrescfe-job-download-documentos10.0.24.71 294952025-12-09 06:43:54.204107-03 2025-12-09 07:07:29.568177-032025-12-09 07:07:29.568225-03ClientClientReadidle    client backend
1665815312documents30990 16402postgrescfe-job-download-documentos10.0.24.81 54972025-12-09 06:42:38.617814-03 2025-12-09 07:07:29.567842-032025-12-09 07:07:29.568008-03ClientClientReadidle    client backend
1665815312documents1591 16402postgresnfe-lambda-aws10.0.20.84 601872025-12-09 07:02:54.380208-03 2025-12-09 07:07:09.906888-032025-12-09 07:07:09.90928-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents7679 16402postgrespgAdmin 4 - DB:documents10.0.28.38 463122025-12-03 17:07:54.892087-03 2025-12-08 14:30:31.62867-032025-12-08 14:30:31.628756-03ClientClientReadidle  -4639381243785674786SELECT pg_cancel_backend(29385);client backend
1665815312documents1592 16402postgresnfe-lambda-aws10.0.20.84 616912025-12-09 07:02:54.436487-03 2025-12-09 07:05:04.632735-032025-12-09 07:05:04.635323-03ClientClientReadidle  3694949039461716331COMMITclient backend
3333716331revizia1852 16402postgresnfe-lambda-aws10.0.20.46 422732025-12-09 07:04:35.019362-03 2025-12-09 07:06:50.088243-032025-12-09 07:06:50.088285-03ClientClientReadidle  -5084201902893922806SELECT ce.conta_id FROM conta_empresa ce INNER JOIN empresa e ON ce.empresa_id = e.id INNER JOIN conta c on ce.conta_id = c.id WHERE e.cnpj IN ($1, $2) AND c.status = 'ATIVO' AND c.id <> 1 LIMIT 1client backend
3333716331revizia1593 16402postgresnfe-lambda-aws10.0.24.71 343472025-12-09 07:02:54.617059-03 2025-12-09 07:06:31.788618-032025-12-09 07:06:31.788657-03ClientClientReadidle  -5084201902893922806SELECT ce.conta_id FROM conta_empresa ce INNER JOIN empresa e ON ce.empresa_id = e.id INNER JOIN conta c on ce.conta_id = c.id WHERE e.cnpj IN ($1, $2) AND c.status = 'ATIVO' AND c.id <> 1 LIMIT 1client backend
1665815312documents1675 16402postgrescfe-job-download-documentos10.0.20.84 489692025-12-09 07:03:31.188537-03 2025-12-09 07:07:27.203137-032025-12-09 07:07:27.203229-03ClientClientReadidle    client backend
1665815312documents2240 16402postgresmensageria-api10.0.24.71 344912025-12-09 07:07:28.63725-03 2025-12-09 07:07:29.576637-032025-12-09 07:07:29.576704-03ClientClientReadidle    client backend
16450fiscal2241 16402postgreseconet-scrapper10.0.24.185 472392025-12-09 07:07:28.866538-03 2025-12-09 07:07:28.884584-032025-12-09 07:07:28.884595-03ClientClientReadidle  4808936042342407727SET application_name = 'econet-scrapper'client backend
1665815312documents1678 16402postgrescfe-job-download-documentos-recorrentes10.0.24.253 19612025-12-09 07:03:32.57062-03 2025-12-09 07:07:16.366776-032025-12-09 07:07:16.366833-03ClientClientReadidle    client backend
16384rdsadmin16592 10rdsadmin   -12025-11-26 22:31:58.583641-03 2025-12-09 07:07:29.561446-032025-12-09 07:07:29.561499-03ClientClientReadidle  3694949039461716331COMMITclient backend
16450fiscal1967 16402postgresecac-darf-job-download-documentos10.0.24.253 227772025-12-09 07:05:08.252262-03 2025-12-09 07:05:08.303323-032025-12-09 07:05:08.303346-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
3333716331revizia1680 16402postgresdctfweb-importador-from-sqs10.0.24.185 188812025-12-09 07:03:34.091654-03 2025-12-09 07:07:06.6789-032025-12-09 07:07:06.678991-03ClientClientReadidle    client backend
1665815312documents1681 16402postgresdctfweb-importador-from-sqs10.0.24.81 468712025-12-09 07:03:34.09198-03 2025-12-09 07:07:06.679454-032025-12-09 07:07:06.679528-03ClientClientReadidle    client backend
16450fiscal1682 16402postgresdctfweb-importador-from-sqs10.0.24.253 69052025-12-09 07:03:34.092263-03 2025-12-09 07:07:09.27153-032025-12-09 07:07:09.271552-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents387 16402postgrescfe-job-download-documentos10.0.20.46 119772025-12-09 06:56:39.861871-03 2025-12-09 07:07:29.323134-032025-12-09 07:07:29.323382-03ClientClientReadidle    client backend
1665815312documents31454 16402postgrescfe-job-download-documentos10.0.24.253 59932025-12-09 06:46:53.657902-03 2025-12-09 07:06:33.696263-032025-12-09 07:06:33.696324-03ClientClientReadidle    client backend
16450fiscal1966 16402postgresecac-darf-job-download-documentos10.0.24.253 121072025-12-09 07:05:08.251989-03 2025-12-09 07:05:08.925511-032025-12-09 07:05:08.925525-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
3333716331revizia27166 16402postgrespgAdmin 4 - CONN:906562510.0.28.38 467302025-12-03 16:14:25.227091-03 2025-12-03 16:14:50.836718-032025-12-03 16:14:50.83677-03ClientClientReadidle  -4364344397713342668commit transaction;client backend
3333716331revizia398 16402postgrescertificado-api10.0.24.71 20352025-12-09 06:56:47.769329-03 2025-12-09 07:07:18.365464-032025-12-09 07:07:18.365515-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
1665815312documents31865 16402postgresnfe-lambda-aws10.0.24.81 413332025-12-09 06:49:52.971805-03 2025-12-09 07:07:29.247557-032025-12-09 07:07:29.250241-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents731 16402postgresmensageria-api10.0.24.185 456392025-12-09 06:59:49.945314-03 2025-12-09 07:07:15.91988-032025-12-09 07:07:15.920976-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents1700 16402postgresnfe-lambda-aws10.0.20.251 383132025-12-09 07:03:40.901539-03 2025-12-09 07:05:03.545827-032025-12-09 07:05:03.548331-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents1701 16402postgresnfe-lambda-aws10.0.24.81 34972025-12-09 07:03:41.155759-03 2025-12-09 07:05:05.125865-032025-12-09 07:05:05.128214-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents1702 16402postgresnfe-lambda-aws10.0.24.81 548432025-12-09 07:03:41.20824-03 2025-12-09 07:05:03.055706-032025-12-09 07:05:03.058549-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents1703 16402postgresnfe-lambda-aws10.0.24.71 298592025-12-09 07:03:41.918537-03 2025-12-09 07:05:03.157197-032025-12-09 07:05:03.158462-03ClientClientReadidle  3694949039461716331COMMITclient backend
3333716331revizia1704 16402postgresnfe-lambda-aws10.0.24.253 330772025-12-09 07:03:42.118443-03 2025-12-09 07:05:15.078732-032025-12-09 07:05:15.078778-03ClientClientReadidle  -6478377226548179738 SELECT cn.cnpj, cn.notificacao, cn.valor, cn.intervalo, e.email FROM configuracao_notificacao cn INNER JOIN configuracao_notificacao_email cne ON cn.id = cne.configuracao_notificacao_id INNER JOIN email e ON e.id = cne.email_id WHERE cn.notificacao = $1 AND cn.tipo_notificacao = 'EMAIL' AND cn.cnpj IN ($2) client backend
16450fiscal2022 16402postgresfiscal-intelligence-sped-job10.0.24.81 193652025-12-09 07:05:37.341075-03 2025-12-09 07:07:26.957177-032025-12-09 07:07:26.957186-03ClientClientReadidle  3694949039461716331COMMITclient backend
16450fiscal1964 16402postgresecac-darf-job-download-documentos10.0.24.71 575632025-12-09 07:05:08.25147-03 2025-12-09 07:07:17.348372-032025-12-09 07:07:17.348428-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents1708 16402postgresnfe-lambda-aws10.0.24.185 217672025-12-09 07:03:42.539416-03 2025-12-09 07:05:01.648572-032025-12-09 07:05:01.651045-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents859 16402postgresmensageria-api10.0.24.71 434432025-12-09 07:00:12.574258-03 2025-12-09 07:07:28.641782-032025-12-09 07:07:28.642886-03ClientClientReadidle  3694949039461716331COMMITclient backend
16450fiscal2029 16402postgresfiscal-intelligence-sped-job10.0.20.46 303332025-12-09 07:05:40.731743-03 2025-12-09 07:05:50.87244-032025-12-09 07:05:50.872502-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents792 16402postgresmensageria-api10.0.24.71 483952025-12-09 07:00:04.896841-03 2025-12-09 07:07:28.641981-032025-12-09 07:07:28.643813-03ClientClientReadidle  3694949039461716331COMMITclient backend
16450fiscal2032 16402postgreslambda-go-revizia-metrics10.0.20.84 322012025-12-09 07:05:43.676574-03 2025-12-09 07:05:43.699767-032025-12-09 07:05:43.701346-03ClientClientReadidle  -6488867169811202377
select id, type, file_name
from book_keeping
where status in ('READING','READING_WITH_PRIORITY')
order by created_at, updated_at		client backend
1665815312documents793 16402postgresmensageria-api10.0.20.251 595492025-12-09 07:00:04.906413-03 2025-12-09 07:07:28.644767-032025-12-09 07:07:28.646555-03ClientClientReadidle  3694949039461716331COMMITclient backend
16450fiscal1715 16402postgresfiscal-intelligence-sped-job10.0.24.71 135312025-12-09 07:03:44.374521-03 2025-12-09 07:05:35.582277-032025-12-09 07:05:35.582287-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
16450fiscal2056 16402postgresfiscal-intelligence-sped-job10.0.24.253 175492025-12-09 07:05:55.600584-03 2025-12-09 07:07:29.659625-032025-12-09 07:07:29.65964-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
1665815312documents31880 16402postgresnfe-lambda-aws10.0.20.46 134632025-12-09 06:49:55.959758-03 2025-12-09 07:07:18.442546-032025-12-09 07:07:18.445281-03ClientClientReadidle  3694949039461716331COMMITclient backend
3333716331revizia1972 16402postgresgo-sped-api10.0.20.84 239732025-12-09 07:05:08.274844-03 2025-12-09 07:07:13.422962-032025-12-09 07:07:13.432391-03ClientClientReadidle  -5339885417602169050
select distinct e.cnpj
from empresa e
inner join conta_empresa ce on ce.empresa_id = e.id
inner join conta c on c.id = ce.conta_id
where substr(e.cnpj,1,8) = $1
and c.status in ('ATIVO', 'TRIAL')
and c.deleted = false
and e.deleted = false
and ce.deleted = false
client backend
1665815312documents30539 16402postgrescfe-job-download-documentos10.0.20.46 65952025-12-09 06:39:35.968837-03 2025-12-09 07:07:09.323214-032025-12-09 07:07:09.323263-03ClientClientReadidle    client backend
1665815312documents31952 16402postgrescfe-job-queue-api10.0.20.84 99912025-12-09 06:50:29.517327-03 2025-12-09 07:07:29.568222-032025-12-09 07:07:29.568242-03ClientClientReadidle    client backend
3333716331revizia1002 16402postgresmensageria-api10.0.20.84 558412025-12-09 07:00:29.557489-03 2025-12-09 07:06:20.62769-032025-12-09 07:06:20.627798-03ClientClientReadidle    client backend
1665815312documents1219 16402postgresintegracao-fluxo-pagamento-worker10.0.20.84 483712025-12-09 07:00:51.203903-032025-12-09 07:07:29.658699-032025-12-09 07:07:29.661676-032025-12-09 07:07:29.661693-03ClientClientReadidle in transaction 1033481731-3623911024636025028select integracao0_.id as id1_2_0_, integracao0_.ativo as ativo2_2_0_, integracao0_.cnpj as cnpj3_2_0_, integracao0_.formato_documento as formato_4_2_0_, integracao0_.id_tipo_documento_remoto as id_tipo_5_2_0_, integracao0_.id_workflow as id_workf6_2_0_, integracao0_.senha as senha7_2_0_, integracao0_.tipo_documento as tipo_doc8_2_0_, integracao0_.usuario as usuario9_2_0_ from integ_flx_pag integracao0_ where integracao0_.id=$1client backend
16450fiscal1375 16402postgresecac-darf-job-download-documentos10.0.24.71 565392025-12-09 07:01:06.980625-03 2025-12-09 07:05:08.254848-032025-12-09 07:05:08.254922-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
16450fiscal1200 16402postgresecac-darf-job-download-documentos10.0.24.138 277752025-12-09 07:00:49.371099-03 2025-12-09 07:05:08.872832-032025-12-09 07:05:08.872875-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
16450fiscal1458 16402postgresfiscal-intelligence-sped-job10.0.20.251 622112025-12-09 07:01:42.419632-03 2025-12-09 07:05:40.741641-032025-12-09 07:05:40.741655-03ClientClientReadidle  3694949039461716331COMMITclient backend
5postgres1429 16402postgrespgAdmin 4 - CONN:218762910.0.28.38 342922025-12-08 15:10:47.849807-03 2025-12-08 15:10:56.852028-032025-12-08 15:10:56.854831-03ClientClientReadidle  7216056754469621365grant readonly to grafanaclient backend
  1338       2025-10-09 16:28:03.411906-03   ActivityBgWriterMain     background writer
  1426       2025-10-09 16:28:05.073321-03   ActivityArchiverMain     archiver
  1337       2025-10-09 16:28:03.411735-03   TimeoutCheckpointWriteDelay     checkpointer
  1425       2025-10-09 16:28:05.073164-03   ActivityWalWriterMain     walwriter