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        804233201376169930 pg_cron launcher
  1428 10rdsadmin    2025-10-09 16:28:05.073701-03   ActivityLogicalLauncherMain     logical replication launcher
1665815312documents23688 16402postgrescfe-job-download-documentos-recorrentes10.0.24.253 273312025-12-10 22:09:07.647271-03 2025-12-10 22:16:18.737734-032025-12-10 22:16:18.737803-03ClientClientReadidle    client backend
5postgres16007 3333668727rdsproxyadmin 10.0.24.253 652932025-12-10 21:34:00.06404-03 2025-12-10 22:16:17.928921-032025-12-10 22:16:17.92901-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
5postgres16008 3333668727rdsproxyadmin 10.0.20.251 600132025-12-10 21:34:00.295323-03 2025-12-10 22:16:18.034886-032025-12-10 22:16:18.034971-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
5postgres16009 3333668727rdsproxyadmin 10.0.24.138 171832025-12-10 21:34:00.458535-03 2025-12-10 22:16:18.285149-032025-12-10 22:16:18.285243-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
1665815312documents24745 16402postgreslambda-go-revizia-metrics10.0.20.251 442032025-12-10 22:16:05.63812-03 2025-12-10 22:16:06.837203-032025-12-10 22:16:06.842966-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
5postgres14650 3333668727rdsproxyadmin 10.0.24.81 33552025-12-10 19:28:00.461567-03 2025-12-10 22:16:18.296897-032025-12-10 22:16:18.296961-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
1665815312documents17338 16402postgrescfe-job-download-documentos-recorrentes10.0.24.185 454872025-12-10 21:39:04.507959-03 2025-12-10 22:16:12.369463-032025-12-10 22:16:12.369667-03ClientClientReadidle    client backend
5postgres16012 3333668727rdsproxyadmin 10.0.24.185 191992025-12-10 21:34:00.742069-03 2025-12-10 22:16:18.08532-032025-12-10 22:16:18.085381-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
5postgres16013 3333668727rdsproxyadmin 10.0.24.71 257472025-12-10 21:34:00.772865-03 2025-12-10 22:16:18.40797-032025-12-10 22:16:18.408055-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
3333716331revizia23822 16402postgresnfe-lambda-aws10.0.20.251 640412025-12-10 22:10:00.272635-03 2025-12-10 22:16:15.721591-032025-12-10 22:16:15.721637-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
1665815312documents23981 16402postgrescfe-job-download-documentos10.0.20.84 429232025-12-10 22:11:04.616208-03 2025-12-10 22:16:18.618974-032025-12-10 22:16:18.619056-03ClientClientReadidle    client backend
3333716331revizia24034 16402postgresrvz-sintegra-job10.0.20.251 464792025-12-10 22:11:26.381331-03 2025-12-10 22:15:40.682515-032025-12-10 22:15:40.682614-03ClientClientReadidle    client backend
16450fiscal24576 16402postgreseconet-scrapper10.0.24.138 190892025-12-10 22:15:03.397638-03 2025-12-10 22:15:03.418092-032025-12-10 22:15:03.418109-03ClientClientReadidle  4808936042342407727SET application_name = 'econet-scrapper'client backend
3333716331revizia23060 16402postgresnfe-lambda-aws10.0.24.81 645472025-12-10 22:05:17.294572-03 2025-12-10 22:14:41.819126-032025-12-10 22:14:41.819178-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
16450fiscal24621 16402postgreseconet-scrapper10.0.20.251 246532025-12-10 22:15:20.860947-03 2025-12-10 22:15:20.879622-032025-12-10 22:15:20.879629-03ClientClientReadidle  4808936042342407727SET application_name = 'econet-scrapper'client backend
5postgres16014 3333668727rdsproxyadmin 10.0.20.84 243012025-12-10 21:34:00.959236-03 2025-12-10 22:16:18.01855-032025-12-10 22:16:18.018634-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
5postgres16015 3333668727rdsproxyadmin 10.0.20.46 563412025-12-10 21:34:00.968397-03 2025-12-10 22:16:18.092966-032025-12-10 22:16:18.093042-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
1665815312documents24433 16402postgreslambda-go-revizia-metrics10.0.24.185 572632025-12-10 22:14:05.637479-03 2025-12-10 22:14:08.664044-032025-12-10 22:14:08.669906-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
1665815312documents23195 16402postgresintegracao-fluxo-pagamento-worker10.0.20.46 334592025-12-10 22:06:05.59553-032025-12-10 22:16:18.888858-032025-12-10 22:16:18.908215-032025-12-10 22:16:18.909641-03ClientClientReadidle in transaction 1036011070-3066162310059956733select gzip, type, key from document where key = $1 and type = $2 and data -> 'procEventoNFe' -> 'retEvento' -> 'infEvento' ->> 'tpEvento' in ($3, $4)client backend
1665815312documents22805 16402postgrescfe-job-download-documentos10.0.20.251 385692025-12-10 22:04:07.073059-03 2025-12-10 22:15:02.230244-032025-12-10 22:15:02.231682-03ClientClientReadidle    client backend
1665815312documents24582 16402postgreslambda-go-revizia-metrics10.0.20.84 170112025-12-10 22:15:05.657915-03 2025-12-10 22:15:06.747942-032025-12-10 22:15:06.753661-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
16450fiscal22369 16402postgresfiscal-intelligence-core-job10.0.24.253 169792025-12-10 22:02:05.050537-032025-12-10 22:16:18.809663-032025-12-10 22:16:18.810132-032025-12-10 22:16:18.810133-03IODataFileReadactive 1036011070-7244585083917778096select * from cnpj_consolidation cc where cc.cnpj = $1client backend
1665815312documents23125 16402postgresmensageria-api10.0.20.84 597712025-12-10 22:05:42.794916-03 2025-12-10 22:16:08.90414-032025-12-10 22:16:08.905219-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents23384 16402postgrescfe-job-download-documentos10.0.24.253 155112025-12-10 22:07:13.701682-03 2025-12-10 22:15:49.863205-032025-12-10 22:15:49.863245-03ClientClientReadidle    client backend
16450fiscal24747 16402postgreslambda-go-revizia-metrics10.0.24.185 358592025-12-10 22:16:05.821779-03 2025-12-10 22:16:06.681358-032025-12-10 22:16:06.68575-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
3333716331revizia24748 16402postgreslambda-go-revizia-metrics10.0.20.84 443752025-12-10 22:16:05.999643-03 2025-12-10 22:16:06.924001-032025-12-10 22:16:07.709721-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
16450fiscal24434 16402postgreslambda-go-revizia-metrics10.0.20.251 385152025-12-10 22:14:05.758387-03 2025-12-10 22:15:34.634928-032025-12-10 22:15:34.637155-03ClientClientReadidle  -6710500507105320500INSERT INTO fila_cons_analises (hash_id, cnpj, fila, mensagem, data_criacao) VALUES ($1, $2, $3, $4, $5)client backend
3333716331revizia24583 16402postgreslambda-go-revizia-metrics10.0.24.71 378052025-12-10 22:15:05.937469-03 2025-12-10 22:15:06.833033-032025-12-10 22:15:07.611487-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
3333716331revizia24435 16402postgreslambda-go-revizia-metrics10.0.20.46 540272025-12-10 22:14:05.918739-03 2025-12-10 22:14:08.744895-032025-12-10 22:14:09.525834-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
1665815312documents24770 16402postgrescte-lambda-aws10.0.20.251 550852025-12-10 22:16:12.184838-03 2025-12-10 22:16:12.85864-032025-12-10 22:16:12.860776-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents24122 16402postgrescfe-job-download-documentos10.0.24.138 211672025-12-10 22:12:01.734016-03 2025-12-10 22:14:01.221419-032025-12-10 22:14:01.224577-03ClientClientReadidle    client backend
1665815312documents12892 16402postgrescfe-job-download-documentos10.0.20.46 239712025-12-10 21:23:07.07324-03 2025-12-10 22:16:17.69915-032025-12-10 22:16:17.699318-03ClientClientReadidle    client backend
16450fiscal24455 16402postgreseconet-scrapper10.0.24.253 231072025-12-10 22:14:12.244664-03 2025-12-10 22:14:12.27381-032025-12-10 22:14:12.273827-03ClientClientReadidle  4808936042342407727SET application_name = 'econet-scrapper'client backend
3333716331revizia24456 16402postgresnfe-lambda-aws10.0.20.84 192052025-12-10 22:14:12.801337-03 2025-12-10 22:14:12.819397-032025-12-10 22:14:12.819458-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
1665815312documents24635 16402postgresdocument-api10.0.20.84 471032025-12-10 22:15:25.039167-03 2025-12-10 22:15:40.98312-032025-12-10 22:15:40.983331-03ClientClientReadidle    client backend
1665815312documents22278 16402postgrescfe-job-download-documentos10.0.24.185 180392025-12-10 22:01:32.072652-03 2025-12-10 22:16:17.206034-032025-12-10 22:16:17.206175-03ClientClientReadidle    client backend
1665815312documents24127 16402postgresnfe-lambda-aws10.0.20.84 533172025-12-10 22:12:03.557172-03 2025-12-10 22:16:05.387336-032025-12-10 22:16:05.389609-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents24126 16402postgresnfe-lambda-aws10.0.20.251 513952025-12-10 22:12:03.28058-03 2025-12-10 22:15:46.447221-032025-12-10 22:15:46.449758-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents23521 16402postgresmensageria-api10.0.24.138 625652025-12-10 22:08:06.127198-03 2025-12-10 22:16:14.150477-032025-12-10 22:16:14.150538-03ClientClientReadidle    client backend
16450fiscal24298 16402postgreslambda-go-revizia-metrics10.0.20.84 619032025-12-10 22:13:05.83826-03 2025-12-10 22:15:43.667544-032025-12-10 22:15:43.668429-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
1665815312documents24627 16402postgresmensageria-api10.0.24.185 348532025-12-10 22:15:23.264288-03 2025-12-10 22:15:47.389498-032025-12-10 22:15:47.390853-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents21278 16402postgresnfe-lambda-aws10.0.24.81 166452025-12-10 21:57:02.665105-03 2025-12-10 22:14:42.688844-032025-12-10 22:14:42.691173-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents22396 16402postgresmensageria-api10.0.20.84 588052025-12-10 22:02:10.974025-03 2025-12-10 22:16:11.6557-032025-12-10 22:16:11.65682-03ClientClientReadidle  3694949039461716331COMMITclient backend
16450fiscal24642 16402postgreseconet-scrapper10.0.24.185 521952025-12-10 22:15:28.850494-03 2025-12-10 22:15:28.866068-032025-12-10 22:15:28.866083-03ClientClientReadidle  4808936042342407727SET application_name = 'econet-scrapper'client backend
16450fiscal24467 16402postgreseconet-scrapper10.0.24.71 172672025-12-10 22:14:19.298288-03 2025-12-10 22:14:19.314883-032025-12-10 22:14:19.314891-03ClientClientReadidle  4808936042342407727SET application_name = 'econet-scrapper'client backend
1665815312documents24461 16402postgrescfe-job-download-documentos-recorrentes10.0.24.71 239172025-12-10 22:14:14.816826-03 2025-12-10 22:16:17.647518-032025-12-10 22:16:17.647564-03ClientClientReadidle    client backend
1665815312documents24778 16402postgrescte-lambda-aws10.0.20.84 500932025-12-10 22:16:16.123184-03 2025-12-10 22:16:16.46738-032025-12-10 22:16:16.469454-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents24782 16402postgrescte-lambda-aws10.0.24.71 71132025-12-10 22:16:18.565988-03 2025-12-10 22:16:18.82294-032025-12-10 22:16:18.824087-03ClientClientReadidle  3694949039461716331COMMITclient backend
3333716331revizia24637 16402postgrescore-api10.0.24.185 78952025-12-10 22:15:27.20794-03 2025-12-10 22:15:46.297846-032025-12-10 22:15:46.297881-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents21577 16402postgresnfe-lambda-aws10.0.24.185 257392025-12-10 21:58:50.847161-03 2025-12-10 22:16:15.761515-032025-12-10 22:16:15.763923-03ClientClientReadidle  3694949039461716331COMMITclient backend
16384rdsadmin16273 10rdsadminPostgreSQL JDBC Driver  -12025-11-26 22:31:10.413433-03 2025-12-10 22:16:07.010427-032025-12-10 22:16:07.010449-03ClientClientReadidle  3326913007740874862SELECT value FROM rds_heartbeat2client backend
1665815312documents24468 16402postgrescfe-job-download-documentos10.0.24.253 621712025-12-10 22:14:19.864356-03 2025-12-10 22:16:18.86323-032025-12-10 22:16:18.863275-03ClientClientReadidle    client backend
1665815312documents18074 16402postgrescfe-job-download-documentos-recorrentes10.0.24.138 349392025-12-10 21:42:12.75945-03 2025-12-10 22:15:13.64687-032025-12-10 22:15:13.647072-03ClientClientReadidle    client backend
16450fiscal23563 16402postgresfiscal-intelligence-sped-job10.0.24.138 96312025-12-10 22:08:24.34843-03 2025-12-10 22:14:13.180297-032025-12-10 22:14:13.180349-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
16450fiscal19509 16402postgresprocessador-linhas-sped-job10.0.20.84 323312025-12-10 21:48:33.819035-03 2025-12-10 22:14:55.248894-032025-12-10 22:14:55.248965-03ClientClientReadidle  -4199849316459484872DISCARD ALL;client backend
16450fiscal24129 16402postgrespostgres_fdw127.0.0.1 206522025-12-10 22:12:03.620117-03 2025-12-10 22:16:09.753311-032025-12-10 22:16:09.753328-03ClientClientReadidle  -4518006279650829961ABORT TRANSACTIONclient backend
16451cloudworks21958 16402postgres    2025-12-10 22:00:00.040306-032025-12-10 22:16:14.015502-032025-12-10 22:00:00.041678-032025-12-10 22:00:00.041678-03TimeoutPgSleepactive10360707171036011070-8048468118488788623CALL af2.atualizaestatisticas(
0,
50000000,
5000000,
99999999999,
0,
99999999999,
0,
'',
5,
300,
0,
''
)		pg_cron
1665815312documents19527 16402postgrescfe-job-download-documentos-recorrentes10.0.20.46 314652025-12-10 21:48:39.540601-03 2025-12-10 22:16:18.646436-032025-12-10 22:16:18.646508-03ClientClientReadidle    client backend
1665815312documents22863 16402postgrescfe-job-queue-api10.0.20.84 355392025-12-10 22:04:23.705781-03 2025-12-10 22:16:14.152798-032025-12-10 22:16:14.152871-03ClientClientReadidle    client backend
1665815312documents23408 16402postgrescfe-job-download-documentos10.0.20.251 185992025-12-10 22:07:26.182962-03 2025-12-10 22:16:18.571408-032025-12-10 22:16:18.571492-03ClientClientReadidle    client backend
3333716331revizia24638 16402postgrescore-api10.0.20.46 402632025-12-10 22:15:27.212287-03 2025-12-10 22:16:09.761009-032025-12-10 22:16:09.761118-03ClientClientReadidle    client backend
1665815312documents24653 16402postgresmensageria-api10.0.24.185 432652025-12-10 22:15:34.076021-03 2025-12-10 22:15:50.093944-032025-12-10 22:15:50.09514-03ClientClientReadidle  3694949039461716331COMMITclient backend
3333716331revizia24657 16402postgrescore-api10.0.24.138 397592025-12-10 22:15:34.183357-03 2025-12-10 22:15:46.286544-032025-12-10 22:15:46.286604-03ClientClientReadidle  3694949039461716331COMMITclient backend
16450fiscal24072 16402postgresprocessador-linhas-sped-api10.0.24.71 237552025-12-10 22:11:42.628224-03 2025-12-10 22:16:14.151063-032025-12-10 22:16:14.151137-03ClientClientReadidle    client backend
1665815312documents23578 16402postgresnfe-lambda-aws10.0.24.253 209552025-12-10 22:08:33.99685-03 2025-12-10 22:16:16.899997-032025-12-10 22:16:16.902964-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents13020 16402postgrescfe-job-download-documentos-recorrentes10.0.24.81 441612025-12-10 21:23:32.373283-03 2025-12-10 22:16:18.582633-032025-12-10 22:16:18.582714-03ClientClientReadidle    client backend
16450fiscal24659 16402postgreslambda-go-revizia-metrics10.0.24.138 27812025-12-10 22:15:35.734861-03 2025-12-10 22:15:35.753186-032025-12-10 22:15:35.755036-03ClientClientReadidle  -6710500507105320500INSERT INTO fila_cons_analises (hash_id, cnpj, fila, mensagem, data_criacao) VALUES ($1, $2, $3, $4, $5)client backend
3333716331revizia24511 16402postgrescertificado-api10.0.24.253 178452025-12-10 22:14:40.650649-03 2025-12-10 22:16:09.371905-032025-12-10 22:16:09.371931-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
1665815312documents21833 16402postgrescfe-job-download-documentos10.0.24.71 598992025-12-10 21:59:38.653156-03 2025-12-10 22:16:18.843335-032025-12-10 22:16:18.843341-03ClientClientReadidle    client backend
1665815312documents24171 16402postgrescfe-job-download-documentos-recorrentes10.0.20.84 107932025-12-10 22:12:16.865048-03 2025-12-10 22:16:17.880656-032025-12-10 22:16:17.880726-03ClientClientReadidle    client backend
1665815312documents23579 16402postgresnfe-lambda-aws10.0.24.138 155332025-12-10 22:08:34.144601-03 2025-12-10 22:16:17.218525-032025-12-10 22:16:17.220854-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents24677 16402postgresmensageria-api10.0.20.46 259312025-12-10 22:15:39.200104-03 2025-12-10 22:15:50.095482-032025-12-10 22:15:50.09675-03ClientClientReadidle  3694949039461716331COMMITclient backend
3333716331revizia24666 16402postgrescore-api10.0.24.253 191652025-12-10 22:15:38.01718-03 2025-12-10 22:15:49.006497-032025-12-10 22:15:49.006539-03ClientClientReadidle  3694949039461716331COMMITclient backend
3333716331revizia24668 16402postgrescore-api10.0.20.84 250372025-12-10 22:15:38.028391-03 2025-12-10 22:15:49.006939-032025-12-10 22:15:49.007135-03ClientClientReadidle  3694949039461716331COMMITclient backend
3333716331revizia24163 16402postgrescore-api10.0.24.71 374292025-12-10 22:12:15.109117-03 2025-12-10 22:15:48.980697-032025-12-10 22:15:48.980725-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents22903 16402postgrescfe-job-download-documentos10.0.20.84 207332025-12-10 22:04:33.073553-03 2025-12-10 22:16:18.07196-032025-12-10 22:16:18.072041-03ClientClientReadidle    client backend
3333716331revizia23720 16402postgresmensageria-api10.0.20.84 36732025-12-10 22:09:23.743621-03 2025-12-10 22:16:14.155769-032025-12-10 22:16:14.155811-03ClientClientReadidle    client backend
1665815312documents21602 16402postgresmensageria-api10.0.20.251 102312025-12-10 21:58:55.416791-03 2025-12-10 22:16:10.647256-032025-12-10 22:16:10.647262-03ClientClientReadidle  3694949039461716331COMMITclient backend
3333716331revizia24667 16402postgrescore-api10.0.24.138 373892025-12-10 22:15:38.031524-03 2025-12-10 22:15:46.257713-032025-12-10 22:15:46.257759-03ClientClientReadidle  3694949039461716331COMMITclient backend
3333716331revizia24669 16402postgrescore-api10.0.20.46 62832025-12-10 22:15:38.041522-03 2025-12-10 22:16:18.124121-032025-12-10 22:16:18.12419-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
1665815312documents24335 16402postgresdocument-api10.0.24.71 529552025-12-10 22:13:22.570784-03 2025-12-10 22:15:13.77248-032025-12-10 22:15:13.772522-03ClientClientReadidle    client backend
16450fiscal24673 16402postgreseconet-scrapper10.0.20.46 65792025-12-10 22:15:38.673701-03 2025-12-10 22:15:38.69291-032025-12-10 22:15:38.692919-03ClientClientReadidle  4808936042342407727SET application_name = 'econet-scrapper'client backend
1665815312documents22414 16402postgresmensageria-api10.0.24.253 637772025-12-10 22:02:18.749131-03 2025-12-10 22:16:08.905826-032025-12-10 22:16:08.907091-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents19565 16402postgresmensageria-api10.0.24.81 290372025-12-10 21:48:49.853485-03 2025-12-10 22:15:39.489101-032025-12-10 22:15:39.489187-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents21969 16402postgresdownload-document-api10.0.24.81 400552025-12-10 22:00:00.764996-032025-12-10 22:16:09.547936-032025-12-10 22:16:09.552644-032025-12-10 22:16:09.552659-03ClientClientReadidle in transaction 1036011070-8328895792785131048select configurac0_.id as id1_36_, configurac0_.ativa as ativa2_36_, configurac0_.descricao as descrica3_36_, configurac0_.grupo as grupo4_36_, configurac0_.habilitar_taxa_selic as habilita5_36_, configurac0_.nome_atributo_consolidacao as nome_atr6_36_, configurac0_.nome_fila as nome_fil7_36_, configurac0_.origem_contribuicoes as origem_c8_36_, configurac0_.origem_ecd as origem_e9_36_, configurac0_.origem_ecf as origem_10_36_, configurac0_.origem_esocial as origem_11_36_, configurac0_.origem_icms_ipi as origem_12_36_, configurac0_.origem_xml as origem_13_36_, configurac0_.tipo_consolidacao as tipo_co14_36_, configurac0_.tipo_imposto as tipo_im15_36_, configurac0_.tipo_tese as tipo_te16_36_, configurac0_.versao_consolidacao as versao_17_36_, configurac0_.vigencia_final as vigenci18_36_, configurac0_.vigencia_inicial as vigenci19_36_ from configuracao_consolidacao configurac0_ where configurac0_.tipo_consolidacao=$1client backend
16450fiscal24777 16402postgreseconet-scrapper10.0.20.46 234072025-12-10 22:16:14.673545-03 2025-12-10 22:16:14.693237-032025-12-10 22:16:14.693259-03ClientClientReadidle  4808936042342407727SET application_name = 'econet-scrapper'client backend
1665815312documents24780 16402postgresdocument-api10.0.20.46 312652025-12-10 22:16:16.888143-032025-12-10 22:16:18.911797-032025-12-10 22:16:18.912969-032025-12-10 22:16:18.91297-03  active 1036011070-6815546958608512757select * from pg_stat_activityclient backend
16450fiscal24167 16402postgresfiscal-intelligence-sped-job10.0.24.81 550832025-12-10 22:12:16.565378-03 2025-12-10 22:14:24.148789-032025-12-10 22:14:24.148847-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
3333716331revizia24179 16402postgresnfe-lambda-aws10.0.24.185 196252025-12-10 22:12:20.71617-03 2025-12-10 22:14:42.640026-032025-12-10 22:14:42.640067-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
16450fiscal24170 16402postgresfiscal-intelligence-sped-job10.0.24.253 398112025-12-10 22:12:16.795988-03 2025-12-10 22:16:14.581152-032025-12-10 22:16:14.581214-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents24175 16402postgrescfe-job-download-documentos10.0.24.81 544892025-12-10 22:12:19.326957-03 2025-12-10 22:16:18.325878-032025-12-10 22:16:18.325967-03ClientClientReadidle    client backend
16450fiscal24482 16402postgresfiscal-intelligence-sped-job10.0.20.251 123212025-12-10 22:14:24.425851-03 2025-12-10 22:14:24.678197-032025-12-10 22:14:24.678259-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
3333716331revizia24718 16402postgresrvz-sintegra-job10.0.24.185 354892025-12-10 22:15:56.533402-03 2025-12-10 22:16:10.698619-032025-12-10 22:16:10.698725-03ClientClientReadidle    client backend
1665815312documents9025 16402postgrescfe-job-download-documentos10.0.24.138 309472025-12-10 21:09:35.018315-03 2025-12-10 22:16:18.699803-032025-12-10 22:16:18.699896-03ClientClientReadidle    client backend
1665815312documents24176 16402postgresintegracao-fluxo-pagamento-worker10.0.24.185 259152025-12-10 22:12:19.444588-03 2025-12-10 22:16:17.630354-032025-12-10 22:16:17.630394-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
16450fiscal27649 16402postgresfiscal-intelligence-core-job10.0.20.251 638132025-12-10 20:19:28.339279-032025-12-10 20:19:28.613069-032025-12-10 21:49:00.603067-032025-12-10 21:49:00.60307-03ExtensionExtensionactive10360110701036011070-1015899014351333281 SELECT * FROM ( SELECT CASE WHEN substring(item.produto -> 'prod' ->> 'cfop', 1, 1) IN ('1', '2', '3') THEN 'DEVOLUCAO' WHEN substring(item.produto -> 'prod' ->> 'cfop', 1, 1) IN ('5', '6', '7') THEN 'VENDA' ELSE 'DESCONHECIDO' END AS tipoOperacao, d.imported_at, d.type, TO_CHAR(d.data_emissao, 'YYYY-MM') AS periodo, item.produto -> 'prod' ->> 'cfop' AS cfop, CAST(taxa_selic_acumulada(TO_CHAR(d.data_emissao, 'YYYY-MM')) AS numeric) AS taxaSelicAcumulada, CAST(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' AS numeric) AS valorBaseCalculoPis, CAST(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' AS numeric) AS valorPis, CAST(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vbc' AS numeric) AS valorBaseCalculoCofins, CAST(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' AS numeric) AS valorCofins, d.key, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS number, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'serie' AS serie, d.data -> 'nfe' -> 'infNFe' -> 'dest' ->> 'cnpj' AS cnpjDestinatario, ds.status AS situacao, item.produto -> 'prod' ->> 'cprod' AS codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, CAST(item.produto -> 'prod' ->> 'vprod' AS numeric) AS valorProduto, CAST(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'ppis' AS numeric) AS aliquotaPis, CAST(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'pcofins' AS numeric) AS aliquotaCofins, ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric)) + (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric)))) as novaBaseCalculo, (cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric)) + (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric)))) as valorDiferencaBasePis, (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric)) + (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric)))) as valorDiferencaBaseCofins, (((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric)) + (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric)))) * ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'ppis' as numeric)) / 100)) as valorPisAposExclusao, (((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric)) + (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric)))) * ((cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'pcofins' as numeric)) / 100)) as valorCofinsAposExclusao, (((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric))) - (((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric)) + (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric)))) * ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'ppis' as numeric)) / 100))) as valorDiferencaPis, (((cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric))) - (((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric)) + (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric)))) * ((cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'pcofins' as numeric)) / 100))) as valorDiferencaCofins, cast((((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric))) - (((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric)) + (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric)))) * ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'ppis' as numeric)) / 100))) * (taxa_selic_acumulada(TO_CHAR(d.data_emissao, 'YYYY-MM')) / 100) + (((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric))) - (((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric)) + (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric)))) * ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'ppis' as numeric)) / 100))) as numeric) as valorCorrigidoPis, cast((((cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric))) - (((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric)) + (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric)))) * ((cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'pcofins' as numeric)) / 100))) * (taxa_selic_acumulada(TO_CHAR(d.data_emissao, 'YYYY-MM')) / 100) + (((cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric))) - (((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric)) + (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric)))) * ((cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'pcofins' as numeric)) / 100))) as numeric) as valorCorrigidoCofins FROM documents_document d INNER JOIN documents_document_status ds ON d.key = ds.key AND d.cnpj_issuer = ds.cnpj_issuer AND d.protocol = ds.protocol AND d.nsu = ds.nsu AND d.type = ds.type, jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE ds.status = '1' AND d.cnpj_issuer = $1 AND d.type IN ('NFE_4_0', 'NFE_3_1') AND item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'cst' = '01' AND item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'cst' = '01' AND d.data_emissao BETWEEN CAST($2 AS timestamptz) and CAST($3 AS timestamptz) UNION ALL SELECT CASE WHEN substring(item.produto -> 'prod' ->> 'cfop', 1, 1) IN ('1', '2', '3') THEN 'DEVOLUCAO' WHEN substring(item.produto -> 'prod' ->> 'cfop', 1, 1) IN ('5', '6', '7') THEN 'VENDA' ELSE 'DESCONHECIDO' END AS tipoOperacao, d.imported_at, d.type, TO_CHAR(d.data_emissao, 'YYYY-MM-DD') AS periodo, item.produto -> 'prod' ->> 'cfop' AS cfop, CAST(taxa_selic_acumulada(TO_CHAR(d.data_emissao, 'YYYY-MM')) AS numeric) AS taxaSelicAcumulada, CAST(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' AS numeric) AS valorBaseCalculoPis, CAST(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' AS numeric) AS valorPis, CAST(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vbc' AS numeric) AS valorBaseCalculoCofins, CAST(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' AS numeric) AS valorCofins, d.key, d.info ->> 'nCFe' AS number, d.info ->> 'serieSAT' AS serie, d.info ->> 'addresseeCnpj' AS cnpjDestinatario, ds.status AS situacao, item.produto -> 'prod' ->> 'cprod' AS codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, CAST(item.produto -> 'prod' ->> 'vprod' AS numeric) AS valorProduto, CASE WHEN d.data -> 'infCFe' -> 'ide' ->> 'cuf' = '35' THEN CAST(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'ppis' AS numeric) * 100 ELSE CAST(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'ppis' AS numeric) END AS aliquotaPis, CASE WHEN d.data -> 'infCFe' -> 'ide' ->> 'cuf' = '35' THEN CAST(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'pcofins' AS numeric) * 100 ELSE CAST(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'pcofins' AS numeric) END AS aliquotaCofins, ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric)) + (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric)))) as novaBaseCalculo, (cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric)) + (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric)))) as valorDiferencaBasePis, (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric)) + (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric)))) as valorDiferencaBaseCofins, ((((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric)) + (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric)))) * (case when d.data -> 'infCFe' -> 'ide' ->> 'cuf' = '35' then (cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'ppis' as numeric)) * 100 else (cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'ppis' as numeric)) end)) / 100) as valorPisAposExclusao, ((((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric)) + (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric)))) * (case when d.data -> 'infCFe' -> 'ide' ->> 'cuf' = '35' then (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'pcofins' as numeric)) * 100 else (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'pcofins' as numeric)) end)) / 100) as valorCofinsAposExclusao, (((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric))) - ((((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric)) + (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric)))) * (case when d.data -> 'infCFe' -> 'ide' ->> 'cuf' = '35' then (cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'ppis' as numeric)) * 100 else (cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'ppis' as numeric)) end)) / 100)) as valorDiferencaPis, (((cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric))) - ((((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric)) + (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric)))) * (case when d.data -> 'infCFe' -> 'ide' ->> 'cuf' = '35' then (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'pcofins' as numeric)) * 100 else (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'pcofins' as numeric)) end)) / 100)) as valorDiferencaCofins, cast((((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric))) - ((((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric)) + (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric)))) * (case when d.data -> 'infCFe' -> 'ide' ->> 'cuf' = '35' then (cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'ppis' as numeric)) * 100 else (cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'ppis' as numeric)) end)) / 100)) * (taxa_selic_acumulada(TO_CHAR(d.data_emissao, 'YYYY-MM')) / 100) + (((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric))) - ((((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric)) + (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric)))) * (case when d.data -> 'infCFe' -> 'ide' ->> 'cuf' = '35' then (cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'ppis' as numeric)) * 100 else (cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'ppis' as numeric)) end)) / 100)) as numeric) valorCorrigidoPis, cast((((cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric))) - ((((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric)) + (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric)))) * (case when d.data -> 'infCFe' -> 'ide' ->> 'cuf' = '35' then (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'pcofins' as numeric)) * 100 else (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'pcofins' as numeric)) end)) / 100)) * (taxa_selic_acumulada(TO_CHAR(d.data_emissao, 'YYYY-MM')) / 100) + (((cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric))) - ((((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vbc' as numeric)) - ((cast(item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric)) + (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric)))) * (case when d.data -> 'infCFe' -> 'ide' ->> 'cuf' = '35' then (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'pcofins' as numeric)) * 100 else (cast(item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'pcofins' as numeric)) end)) / 100)) as numeric) as valorCorrigidoCofins FROM documents_document d INNER JOIN documents_document_status ds ON d.key = ds.key AND d.cnpj_issuer = ds.cnpj_issuer AND d.protocol = ds.protocol AND d.nsu = ds.nsu AND d.type = ds.type, jsonb_array_elements(d.data -> 'infCFe' -> 'det') WITH ORDINALITY item(produto) WHERE ds.status = '1' AND d.cnpj_issuer = $4 AND d.type IN ('CFE_0_6', 'CFE_00_6', 'CFE_0_7', 'CFE_00_7', 'CFE_0_8', 'CFE_0_9', 'CFE_0_10') AND item.produto -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'cst' = '01' AND item.produto -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'cst' = '01' AND d.data_emissao BETWEEN CAST($5 AS timestamptz) and CAST($6 AS timestamptz) ) resultado ORDER BY resultado.periodo, resultado.imported_at limit $7 offset $8client backend
5postgres18331 16402postgrespgAdmin 4 - DB:postgres10.0.28.38 516682025-12-10 17:14:19.442783-03 2025-12-10 17:14:39.028522-032025-12-10 17:14:39.028728-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
16450fiscal23424 16402postgresesocial-totalizador-fgts-empregador-importar-from-sqs10.0.20.251 62112025-12-10 22:07:35.981103-03 2025-12-10 22:16:11.37033-032025-12-10 22:16:11.370347-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents24690 16402postgresnfe-lambda-aws10.0.20.251 84852025-12-10 22:15:46.409673-03 2025-12-10 22:16:17.039301-032025-12-10 22:16:17.042105-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents23636 16402postgresmensageria-api10.0.24.253 232192025-12-10 22:08:53.212388-03 2025-12-10 22:16:11.87505-032025-12-10 22:16:11.875056-03ClientClientReadidle  3694949039461716331COMMITclient backend
16451cloudworks6358 16402postgres    2025-12-10 21:00:00.004024-032025-12-10 22:16:13.50414-032025-12-10 21:00:00.005133-032025-12-10 21:00:00.005133-03TimeoutPgSleepactive103607071310360110709207317994208447636CALL af2.atualizaestatisticas(
0,
5000000,
50000,
99999999999,
0,
99999999999,
0,
'',
5,
300,
0,
''
)		pg_cron
3333716331revizia23446 16402postgresesocial-totalizador-fgts-empregador-importar-from-sqs10.0.24.138 157712025-12-10 22:07:43.348728-03 2025-12-10 22:16:11.196745-032025-12-10 22:16:11.19678-03ClientClientReadidle    client backend
3333716331revizia24344 16402postgresrvz-sintegra-job10.0.20.84 235292025-12-10 22:13:26.487144-03 2025-12-10 22:14:10.632255-032025-12-10 22:14:10.63233-03ClientClientReadidle    client backend
1665815312documents21222 16402postgresnfe-lambda-aws10.0.20.46 289192025-12-10 21:56:45.308837-03 2025-12-10 22:16:05.743862-032025-12-10 22:16:05.745229-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents23447 16402postgresesocial-totalizador-fgts-empregador-importar-from-sqs10.0.20.84 221872025-12-10 22:07:43.348998-03 2025-12-10 22:16:11.197354-032025-12-10 22:16:11.197482-03ClientClientReadidle    client backend
1665815312documents27653 16402postgrespostgres_fdw127.0.0.1 227502025-12-10 20:19:28.84038-032025-12-10 20:19:28.846886-032025-12-10 22:16:18.913024-032025-12-10 22:16:18.913024-03  active 10360110355607492908728616596FETCH 100 FROM c12client backend
3333716331revizia24345 16402postgresrvz-sintegra-job10.0.20.46 577672025-12-10 22:13:26.501667-03 2025-12-10 22:15:27.00493-032025-12-10 22:15:27.005066-03ClientClientReadidle    client backend
16450fiscal22082 16402postgreslambda-go-revizia-metrics10.0.20.46 469912025-12-10 22:00:32.566421-03 2025-12-10 22:16:09.568787-032025-12-10 22:16:09.570367-03ClientClientReadidle  2584226270632227960DELETE FROM fila_cons_analises WHERE hash_id = $1client backend
1665815312documents24707 16402postgresdocument-api10.0.24.253 72552025-12-10 22:15:52.175898-03 2025-12-10 22:16:17.726594-032025-12-10 22:16:17.726654-03ClientClientReadidle    client backend
16450fiscal24201 16402postgresfiscal-intelligence-api10.0.20.46 550872025-12-10 22:12:29.083266-032025-12-10 22:16:09.770168-032025-12-10 22:16:09.778112-032025-12-10 22:16:09.778113-03IODataFileReadactive 1036011070-6371721927676092321 SELECT periodo, codigo, nome, codigoNcm, descricaoUnidadeMedida, quantidade, valor FROM ( SELECT periodo, codigo, nome, codigoNcm, descricaoUnidadeMedida, SUM(quantidade) as quantidade, SUM(valor) as valor, ROW_NUMBER() over ( partition by periodo order by periodo, SUM(valor) desc ) as rank FROM ( SELECT periodo, codigo, nome, codigoNcm, descricaoUnidadeMedida, quantidade, valor, indicador_entrada_terceiro FROM ( SELECT bk.period as periodo , bklC170.json_line ->> 'cod_item' as codigo , CASE WHEN (bklC170.json_line ->> 'descr_compl' IS NOT NULL AND bklC170.json_line ->> 'descr_compl' <> '') THEN bklC170.json_line ->> 'descr_compl' ELSE bkl0200.json_line ->> 'descricao_item' END nome , bkl0200.json_line ->> 'codigo_ncm' as codigoNcm , bkl0190.json_line ->> 'descricao_unidade_medida' as descricaoUnidadeMedida , CAST(bklC170.json_line ->> 'qtd' AS NUMERIC) as quantidade , CAST(bklC170.json_line ->> 'vl_item' AS NUMERIC) as valor , ( SELECT count(*) FROM book_keeping_line bklC100 WHERE bklC100.cnpj_raiz = SUBSTRING($1, 1, 8) AND bklC100.identifier = 'C100' AND bklC100.json_line ->> 'indicador_operacao' = 'ENTRADA' AND bklC100.json_line ->> 'indicador_emitente' = 'TERCEIROS' AND bklC100.id = bklC170.parent_line_id ) as indicador_entrada_terceiro FROM book_keeping bk INNER JOIN book_keeping_line bklC170 ON bk.id = bklC170.book_keeping_id LEFT OUTER JOIN book_keeping_line bkl0200 ON bk.id = bkl0200.book_keeping_id LEFT OUTER JOIN book_keeping_line bkl0190 ON bk.id = bkl0190.book_keeping_id WHERE bklC170.cnpj_raiz = SUBSTRING($2, 1, 8) AND bkl0200.cnpj_raiz = SUBSTRING($3, 1, 8) AND bkl0190.cnpj_raiz = SUBSTRING($4, 1, 8) AND bk.id IN ($5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61) AND bklC170.identifier = 'C170' AND bkl0200.identifier = '0200' AND bkl0190.identifier = '0190' AND bklC170.json_line ->> 'cod_item' = bkl0200.json_line ->> 'codigo_item' AND bkl0190.json_line ->> 'unidade_medida' = bkl0200.json_line ->> 'unidade_medida' AND bklC170.json_line ->> 'cfop' IN ( '1101','1102','1111','1113','1116','1117','1118','1120','1121','1122','1126','1251','1252','1253','1254','1255','1256','1257','1401','1403','1406','1407','1551','1556','1651','1652','1653','1949','1151','1152','1153','1154','1408','1409','1552','1557', '2101','2102','2111','2113','2116','2117','2118','2120','2121','2122','2126','2151','2152','2153','2154','2251','2252','2253','2254','2255','2256','2257','2401','2403','2406','2407','2408','2409','2551','2556','2651','2652','2653','2949', '3100','3101','3102','3126','3127','3251','3551','3556','3651','3652','3653','3949' ) ) indicador WHERE indicador_entrada_terceiro > 0 ) indicador GROUP BY periodo, codigo, nome, codigoNcm, descricaoUnidadeMedida ORDER BY periodo, valor DESC ) produtos WHERE rank <= $62 client backend
3333716331revizia24197 16402postgrescore-api10.0.24.71 427012025-12-10 22:12:27.371553-03 2025-12-10 22:15:49.006229-032025-12-10 22:15:49.006259-03ClientClientReadidle  3694949039461716331COMMITclient backend
3333716331revizia23459 16402postgrescertificado-api10.0.20.46 552172025-12-10 22:07:47.255094-03 2025-12-10 22:16:10.698847-032025-12-10 22:16:10.698958-03ClientClientReadidle    client backend
1665815312documents10241 16402postgrescfe-job-download-documentos-recorrentes10.0.20.251 84472025-12-10 21:13:55.739502-03 2025-12-10 22:14:49.745988-032025-12-10 22:14:49.746106-03ClientClientReadidle    client backend
16384rdsadmin16592 10rdsadmin   -12025-11-26 22:31:58.583641-03 2025-12-10 22:16:17.997305-032025-12-10 22:16:17.997353-03ClientClientReadidle  3694949039461716331COMMITclient backend
16450fiscal24206 16402postgresfiscal-intelligence-sped-job10.0.24.138 396412025-12-10 22:12:31.971876-03 2025-12-10 22:14:16.019681-032025-12-10 22:14:16.019689-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
1665815312documents23180 16402postgresdownload-document-api10.0.24.185 444432025-12-10 22:06:00.012879-03 2025-12-10 22:16:06.537227-032025-12-10 22:16:06.539061-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents24228 16402postgresecac-situacao-fiscal-api10.0.20.251 332272025-12-10 22:12:40.586761-03 2025-12-10 22:14:40.650271-032025-12-10 22:14:40.650318-03ClientClientReadidle    client backend
1665815312documents18245 16402postgrescfe-job-download-documentos-recorrentes10.0.24.71 285372025-12-10 21:42:57.647941-03 2025-12-10 22:14:14.815582-032025-12-10 22:14:14.815784-03ClientClientReadidle    client backend
16450fiscal24486 16402postgresfiscal-intelligence-sped-job10.0.24.71 398252025-12-10 22:14:28.317153-03 2025-12-10 22:16:18.853988-032025-12-10 22:16:18.853998-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
1665815312documents24514 16402postgresnfe-lambda-aws10.0.24.253 359752025-12-10 22:14:42.233792-03 2025-12-10 22:14:42.365957-032025-12-10 22:14:42.368221-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents24373 16402postgresnfe-lambda-aws10.0.24.71 52032025-12-10 22:13:40.148116-03 2025-12-10 22:16:06.523245-032025-12-10 22:16:06.524605-03ClientClientReadidle  3694949039461716331COMMITclient backend
16450fiscal23759 16402postgresfiscal-intelligence-api10.0.24.81 247352025-12-10 22:09:38.322363-03 2025-12-10 22:16:11.784886-032025-12-10 22:16:11.784983-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
16451cloudworks20445 16402postgres    2025-12-10 20:00:00.006342-032025-12-10 22:16:18.126483-032025-12-10 20:00:00.008028-032025-12-10 20:00:00.008029-03TimeoutPgSleepactive103607073210360110706950012875221666630CALL af2.atualizaestatisticas(
0,
50000,
0,
99999999999,
0,
99999999999,
0,
'',
5,
300,
0,
''
)		pg_cron
1665815312documents23799 16402postgrescfe-job-download-documentos10.0.24.71 483572025-12-10 22:09:53.845092-03 2025-12-10 22:16:18.843128-032025-12-10 22:16:18.843163-03ClientClientReadidle    client backend
1665815312documents23764 16402postgresdownload-document-api10.0.24.185 346012025-12-10 22:09:41.45244-03 2025-12-10 22:16:16.621189-032025-12-10 22:16:16.621254-03ClientClientReadidle   ROLLBACKclient backend
16450fiscal24556 16402postgresprocessador-linhas-sped-job10.0.20.84 149872025-12-10 22:14:55.246309-032025-12-10 22:16:14.051262-032025-12-10 22:16:18.910348-032025-12-10 22:16:18.910409-03ClientClientReadidle in transaction10360707181036011070-4716436261144713742select nextval ('sequence_book_keeping_line')client backend
16450fiscal24520 16402postgreslambda-go-revizia-metrics10.0.24.253 558292025-12-10 22:14:43.65516-03 2025-12-10 22:14:43.671767-032025-12-10 22:14:43.673882-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
3333716331revizia24541 16402postgresgo-document-webhook-load10.0.20.46 118632025-12-10 22:14:50.789372-03 2025-12-10 22:14:50.809725-032025-12-10 22:14:50.812205-03ClientClientReadidle  7742482276470755058select distinct e.cnpj
from document_webhook dw
inner join conta c on c.id = dw.conta_id
inner join conta_empresa ce on ce.conta_id = c.id
inner join empresa e on e.id = ce.empresa_id
where c.deleted = false
and dw.deleted = false
and e.deleted = false
and c.status in ('ATIVO', 'TRIAL')		client backend
1665815312documents24557 16402postgresecac-situacao-fiscal-api10.0.24.81 425132025-12-10 22:14:56.519208-03 2025-12-10 22:16:10.700064-032025-12-10 22:16:10.700171-03ClientClientReadidle    client backend
16451cloudworks12889 16402postgres    2025-12-10 19:15:00.001944-032025-12-10 22:16:16.869101-032025-12-10 19:15:00.003032-032025-12-10 19:15:00.003032-03TimeoutPgSleepactive10360707281036011070-4197140451429859788CALL af2.manutencaovacuum(
0, --,
'SIMPLE', -- SIMPLE/FULL,
'', --,
99999999999999999, --,
0, --,
99999999999999999, --,
0, --,
99999999999999999, --,
0, --,
99999999999999999, --,
0, --,
'', --,
3, -- SEGUNDOS,
500, -- MINUTOS,
0, --,
'bloatsizekb DESC' -- ex: 'linhas DESC'
)
pg_cron
5postgres18395 16402postgrespgAdmin 4 - CONN:25502410.0.28.38 388522025-12-10 17:14:49.252683-03 2025-12-10 17:18:38.930181-032025-12-10 17:18:38.930214-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
  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