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)
5postgres896 10rdsadminpg_cron scheduler   2025-06-01 22:10:25.23949-03   ExtensionExtension   804233201376169930 pg_cron launcher
  897 10rdsadmin    2025-06-01 22:10:25.239681-03   ActivityLogicalLauncherMain     logical replication launcher
1665815312documents30587 16402postgresnfe-lambda-aws10.0.16.217 217912025-08-20 06:44:02.583724-03 2025-08-20 07:03:49.112672-032025-08-20 07:03:49.115646-03ClientClientReadidle   COMMITclient backend
5postgres28825 3333668727rdsproxyadmin 10.0.16.46 80832025-08-20 05:20:00.088931-03 2025-08-20 07:04:03.613862-032025-08-20 07:04:03.613938-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
5postgres28828 3333668727rdsproxyadmin 10.0.16.225 232232025-08-20 05:20:00.182059-03 2025-08-20 07:04:03.568188-032025-08-20 07:04:03.568262-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
5postgres28829 3333668727rdsproxyadmin 10.0.16.91 300952025-08-20 05:20:00.325848-03 2025-08-20 07:04:03.34848-032025-08-20 07:04:03.348574-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
1665815312documents2846 16402postgrescte-lambda-aws10.0.16.232 511012025-08-20 07:02:14.388891-03 2025-08-20 07:03:38.032242-032025-08-20 07:03:38.033472-03ClientClientReadidle   COMMITclient backend
5postgres28830 3333668727rdsproxyadmin 10.0.20.107 206352025-08-20 05:20:00.344789-03 2025-08-20 07:04:03.276983-032025-08-20 07:04:03.277065-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
5postgres21304 3333668727rdsproxyadmin 10.0.20.66 282452025-08-20 04:54:00.930344-03 2025-08-20 07:04:03.807318-032025-08-20 07:04:03.807404-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
1665815312documents2890 16402postgresnfe-lambda-aws10.0.20.107 323192025-08-20 07:02:21.085047-03 2025-08-20 07:03:15.814364-032025-08-20 07:03:15.81764-03ClientClientReadidle   COMMITclient backend
5postgres28831 3333668727rdsproxyadmin 10.0.16.217 148932025-08-20 05:20:00.356067-03 2025-08-20 07:04:03.514143-032025-08-20 07:04:03.514216-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
3333716331revizia2754 16402postgrescfe-importar-sqs10.0.16.55 305192025-08-20 07:02:02.97915-03 2025-08-20 07:04:03.282257-032025-08-20 07:04:03.282333-03ClientClientReadidle    client backend
5postgres28836 3333668727rdsproxyadmin 10.0.16.55 560092025-08-20 05:20:00.567165-03 2025-08-20 07:04:03.082036-032025-08-20 07:04:03.082122-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
5postgres28837 3333668727rdsproxyadmin 10.0.16.232 645812025-08-20 05:20:00.789194-03 2025-08-20 07:04:02.998117-032025-08-20 07:04:02.998205-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
1665815312documents30357 16402postgresdownload-document-api10.0.20.107 229892025-08-20 06:42:00.021576-03 2025-08-20 07:04:00.080692-032025-08-20 07:04:00.080756-03ClientClientReadidle   ROLLBACKclient backend
1665815312documents2981 16402postgrescfe-job-download-documentos10.0.16.46 259172025-08-20 07:03:02.230796-03 2025-08-20 07:03:02.273643-032025-08-20 07:03:02.273749-03ClientClientReadidle    client backend
1665815312documents2982 16402postgrescfe-job-download-documentos-recorrentes10.0.20.66 124392025-08-20 07:03:02.694032-03 2025-08-20 07:04:03.69196-032025-08-20 07:04:03.692044-03ClientClientReadidle    client backend
1665815312documents525 16402postgresintegracao-fluxo-pagamento-worker10.0.16.217 171332025-08-20 06:55:00.865445-03 2025-08-20 07:02:15.922378-032025-08-20 07:02:15.922459-03ClientClientReadidle   ROLLBACKclient backend
1665815312documents31579 16402postgresmensageria-api10.0.16.232 438392025-08-20 06:51:34.831604-03 2025-08-20 07:03:37.383933-032025-08-20 07:03:37.385081-03ClientClientReadidle   COMMITclient backend
1665815312documents2774 16402postgreslambda-go-revizia-metrics10.0.16.46 64772025-08-20 07:02:05.650616-03 2025-08-20 07:02:06.697359-032025-08-20 07:02:06.983808-03ClientClientReadidle  4519062602456696998select Count(*) as "Qtd", Status, recorrente as "Recorrente"
from cfe_periodo_importacao_job
where 1=1
and data_fim <= now()
and status in ('PENDENTE','CONCLUIDO','EM_PROCESSAMENTO','COM_ERRO','COM_ERRO_PERMANENTE') --COM_ERRO_PERMANENTE,SEM_CERTIFICADO
and status is not null
group by status, recorrente		client backend
1665815312documents1792 16402postgresreinf-importador-from-sqs10.0.16.91 633392025-08-20 07:00:00.854895-03 2025-08-20 07:02:08.000868-032025-08-20 07:02:08.000944-03ClientClientReadidle    client backend
1665815312documents3248 16402postgresdocument-api10.0.16.91 457632025-08-20 07:04:01.227357-03 2025-08-20 07:04:01.263417-032025-08-20 07:04:01.263505-03ClientClientReadidle    client backend
1665815312documents27493 16402postgrescfe-job-download-documentos10.0.16.232 587432025-08-20 06:27:10.589659-03 2025-08-20 07:03:52.810518-032025-08-20 07:03:52.81165-03ClientClientReadidle   COMMITclient backend
1665815312documents23040 16402postgrescfe-job-download-documentos-recorrentes10.0.16.55 383572025-08-20 06:15:04.290591-03 2025-08-20 07:03:59.577724-032025-08-20 07:03:59.57776-03ClientClientReadidle    client backend
16450fiscal1791 16402postgresreinf-importador-from-sqs10.0.16.91 642772025-08-20 07:00:00.854609-03 2025-08-20 07:02:08.277546-032025-08-20 07:02:08.278969-03ClientClientReadidle   COMMITclient backend
1665815312documents2985 16402postgrescfe-job-download-documentos10.0.16.217 569132025-08-20 07:03:04.835379-03 2025-08-20 07:03:04.877862-032025-08-20 07:03:04.879532-03ClientClientReadidle   COMMITclient backend
1665815312documents1553 16402postgresnfse-lambda-aws10.0.16.225 305492025-08-20 06:58:05.195101-03 2025-08-20 07:04:03.337895-032025-08-20 07:04:03.340702-03ClientClientReadidle   COMMITclient backend
1665815312documents2262 16402postgresecac-situacao-fiscal-api10.0.16.91 423492025-08-20 07:01:02.348834-03 2025-08-20 07:03:11.449945-032025-08-20 07:03:11.449953-03ClientClientReadidle    client backend
3333716331revizia2263 16402postgrescore-api10.0.16.217 269912025-08-20 07:01:02.449081-03 2025-08-20 07:03:59.959947-032025-08-20 07:03:59.960005-03ClientClientReadidle    client backend
1665815312documents1133 16402postgrescfe-importar-sqs10.0.16.232 104812025-08-20 06:56:08.408467-03 2025-08-20 07:02:16.881675-032025-08-20 07:02:16.883143-03ClientClientReadidle   COMMITclient backend
1665815312documents7397 16402postgrescfe-job-download-documentos-recorrentes10.0.16.46 533212025-08-20 05:55:05.326126-03 2025-08-20 07:03:09.730353-032025-08-20 07:03:09.730387-03ClientClientReadidle    client backend
1665815312documents2839 16402postgrescfe-importar-sqs10.0.20.107 472512025-08-20 07:02:13.081453-032025-08-20 07:04:03.044947-032025-08-20 07:04:03.737562-032025-08-20 07:04:03.737668-03ClientClientReadidle in transaction 791390008 select documentst0_.cnpj_issuer as cnpj_iss1_1_, documentst0_.type as type2_1_, documentst0_.key as key3_1_, documentst0_.nsu as nsu4_1_, documentst0_.protocol as protocol5_1_, documentst0_.available_at as availabl6_1_, documentst0_.canceled_at as canceled7_1_, documentst0_.cce_events as cce_even8_1_, documentst0_.cce_updated_at as cce_upda9_1_, documentst0_.created_at as created10_1_, documentst0_.created_by as created11_1_, documentst0_.manifestation as manifes12_1_, documentst0_.status as status13_1_, documentst0_.updated_at as updated14_1_, documentst0_.updated_by as updated15_1_ from public.document_status documentst0_ where documentst0_.key=$1 limit $2client backend
1665815312documents31176 16402postgresdownload-document-api10.0.16.225 192112025-08-20 06:49:00.031368-03 2025-08-20 07:04:00.072048-032025-08-20 07:04:00.072116-03ClientClientReadidle   ROLLBACKclient backend
5postgres18477 16402postgrespgAdmin 4 - DB:postgres10.0.28.38 489942025-08-14 23:15:09.263878-03 2025-08-14 23:15:56.206301-032025-08-14 23:15:56.206759-03ClientClientReadidle  -5131504417054470966/*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
ORDER BY
gid, database, owner		client backend
1665815312documents22053 16402postgresnfe-lambda-aws10.0.16.217 62052025-08-20 06:11:34.434425-03 2025-08-20 07:03:48.140595-032025-08-20 07:03:48.143208-03ClientClientReadidle   COMMITclient backend
1665815312documents2261 16402postgresnfe-lambda-aws10.0.16.91 528692025-08-20 07:01:01.953901-03 2025-08-20 07:04:03.501642-032025-08-20 07:04:03.50371-03ClientClientReadidle   COMMITclient backend
1665815312documents30872 16402postgresmensageria-api10.0.20.107 468792025-08-20 06:46:05.771044-03 2025-08-20 07:04:02.459445-032025-08-20 07:04:02.45952-03ClientClientReadidle    client backend
3333716331revizia1793 16402postgresreinf-importador-from-sqs10.0.16.55 328892025-08-20 07:00:00.893113-03 2025-08-20 07:02:08.001245-032025-08-20 07:02:08.00133-03ClientClientReadidle    client backend
1665815312documents2895 16402postgrescfe-job-queue-api10.0.16.55 160112025-08-20 07:02:23.558271-03 2025-08-20 07:03:53.707642-032025-08-20 07:03:53.707731-03ClientClientReadidle    client backend
1665815312documents620 16402postgrescfe-importar-sqs10.0.20.107 361312025-08-20 06:55:14.03571-032025-08-20 07:04:03.669099-032025-08-20 07:04:03.805341-032025-08-20 07:04:03.805368-03ClientClientReadidle in transaction 791390008 select documentst0_.cnpj_issuer as cnpj_iss1_1_, documentst0_.type as type2_1_, documentst0_.key as key3_1_, documentst0_.nsu as nsu4_1_, documentst0_.protocol as protocol5_1_, documentst0_.available_at as availabl6_1_, documentst0_.canceled_at as canceled7_1_, documentst0_.cce_events as cce_even8_1_, documentst0_.cce_updated_at as cce_upda9_1_, documentst0_.created_at as created10_1_, documentst0_.created_by as created11_1_, documentst0_.manifestation as manifes12_1_, documentst0_.status as status13_1_, documentst0_.updated_at as updated14_1_, documentst0_.updated_by as updated15_1_ from public.document_status documentst0_ where documentst0_.key=$1 limit $2client backend
3333716331revizia30915 16402postgresmensageria-api10.0.16.55 300832025-08-20 06:46:24.418147-03 2025-08-20 07:04:00.658663-032025-08-20 07:04:00.658669-03ClientClientReadidle    client backend
1665815312documents27736 16402postgresnfe-lambda-aws10.0.20.66 142872025-08-20 06:28:01.235906-03 2025-08-20 07:03:17.352121-032025-08-20 07:03:17.354333-03ClientClientReadidle   COMMITclient backend
16384rdsadmin2827 10rdsadminPostgreSQL JDBC Driver  -12025-08-06 22:36:26.318279-03 2025-08-20 07:04:03.502493-032025-08-20 07:04:03.502514-03ClientClientReadidle   SELECT pg_postmaster_start_time()client backend
3333716331revizia1557 16402postgreslambda-go-revizia-metrics10.0.20.66 630972025-08-20 06:58:05.893032-03 2025-08-20 07:02:07.062336-032025-08-20 07:02:20.376348-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
1665815312documents664 16402postgresnfse-lambda-aws10.0.20.107 77212025-08-20 06:55:19.403345-032025-08-20 07:04:03.702695-032025-08-20 07:04:03.746094-032025-08-20 07:04:03.75492-03ClientClientReadidle in transaction791977841 1837391871733709138update document set info = cast($1 as jsonb) where key = $2 and data_emissao = $3 client backend
3333716331revizia26937 16402postgrescore-api10.0.16.46 535792025-08-20 06:25:04.149996-03 2025-08-20 07:04:03.355365-032025-08-20 07:04:03.35645-03ClientClientReadidle   COMMITclient backend
1665815312documents31105 16402postgrescte-lambda-aws10.0.16.225 454372025-08-20 06:48:18.919616-03 2025-08-20 07:03:32.723211-032025-08-20 07:03:32.725552-03ClientClientReadidle   COMMITclient backend
1665815312documents2865 16402postgresintegracao-fluxo-pagamento-worker10.0.20.107 118952025-08-20 07:02:16.978209-03 2025-08-20 07:04:03.806512-032025-08-20 07:04:03.806574-03ClientClientReadidle   ROLLBACKclient backend
5postgres8914 16402postgrespgAdmin 4 - CONN:979965810.0.28.38 436582025-08-19 14:09:01.738165-03 2025-08-20 01:24:33.121803-032025-08-20 01:24:33.121873-03ClientClientReadidle   SELECT oid, pg_catalog.format_type(oid, NULL) AS typname FROM pg_catalog.pg_type WHERE oid = ANY($1) ORDER BY oid;client backend
3333716331revizia20292 16402postgres 10.0.28.38 433362025-08-19 22:25:37.452045-03 2025-08-20 07:03:33.526525-032025-08-20 07:03:33.526557-03ClientClientReadidle  7088996947831101750ROLLBACKclient backend
1665815312documents31617 16402postgrescfe-job-download-documentos10.0.20.66 429852025-08-20 06:51:42.492993-03 2025-08-20 07:02:38.603288-032025-08-20 07:02:38.603338-03ClientClientReadidle    client backend
1665815312documents3247 16402postgresdocument-api10.0.20.66 158012025-08-20 07:04:01.227093-03 2025-08-20 07:04:01.26529-032025-08-20 07:04:01.265298-03ClientClientReadidle    client backend
16384rdsadmin3019 10rdsadmin   -12025-08-06 22:37:26.899544-03 2025-08-20 07:04:03.086692-032025-08-20 07:04:03.086774-03ClientClientReadidle  3694949039461716331COMMITclient backend
1665815312documents2870 16402postgresnfe-lambda-aws10.0.16.55 97512025-08-20 07:02:17.704306-03 2025-08-20 07:03:38.779541-032025-08-20 07:03:38.782522-03ClientClientReadidle   COMMITclient backend
16450fiscal22396 3305731552dev_rafael_carvalhopgAdmin 4 - CONN:161606910.0.28.38 589722025-08-19 18:59:10.168301-03 2025-08-19 18:59:12.08893-032025-08-19 18:59:12.096196-03ClientClientReadidle  -6488867169811202377UPDATE public.document_analysis
SET status = 'ERROR'
WHERE status = 'PROCESSING'
AND updated_at < NOW() - INTERVAL '1 hour';
client backend
3333716331revizia2875 16402postgresgo-sped-api10.0.16.46 175652025-08-20 07:02:18.494647-03 2025-08-20 07:02:18.523813-032025-08-20 07:02:18.543078-03ClientClientReadidle   
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
1665815312documents31661 16402postgresnfe-lambda-aws10.0.20.107 268972025-08-20 06:51:46.486041-03 2025-08-20 07:03:15.785878-032025-08-20 07:03:15.788802-03ClientClientReadidle   COMMITclient backend
1665815312documents29955 16402postgrescfe-job-download-documentos10.0.16.91 34372025-08-20 06:38:29.485552-03 2025-08-20 07:03:43.57405-032025-08-20 07:03:43.575033-03ClientClientReadidle   COMMITclient backend
1665815312documents2970 16402postgrescfe-job-download-documentos-recorrentes10.0.16.46 242072025-08-20 07:02:59.731545-03 2025-08-20 07:03:59.730343-032025-08-20 07:03:59.730576-03ClientClientReadidle    client backend
1665815312documents2971 16402postgresdocument-api10.0.16.217 428652025-08-20 07:02:59.946901-03 2025-08-20 07:04:01.229195-032025-08-20 07:04:01.232291-03ClientClientReadidle    client backend
1665815312documents2987 16402postgreslambda-go-revizia-metrics10.0.16.232 401192025-08-20 07:03:05.630384-03 2025-08-20 07:03:06.616101-032025-08-20 07:03:06.906014-03ClientClientReadidle  4519062602456696998select Count(*) as "Qtd", Status, recorrente as "Recorrente"
from cfe_periodo_importacao_job
where 1=1
and data_fim <= now()
and status in ('PENDENTE','CONCLUIDO','EM_PROCESSAMENTO','COM_ERRO','COM_ERRO_PERMANENTE') --COM_ERRO_PERMANENTE,SEM_CERTIFICADO
and status is not null
group by status, recorrente		client backend
1665815312documents2373 16402postgresnfse-lambda-aws10.0.16.217 246112025-08-20 07:01:15.713849-032025-08-20 07:04:03.710804-032025-08-20 07:04:03.755212-032025-08-20 07:04:03.764057-03ClientClientReadidle in transaction791977842 1837391871733709138update document set info = cast($1 as jsonb) where key = $2 and data_emissao = $3 client backend
1665815312documents2896 16402postgrescfe-job-queue-api10.0.20.66 133132025-08-20 07:02:23.561036-03 2025-08-20 07:02:23.581678-032025-08-20 07:02:23.581742-03ClientClientReadidle    client backend
1665815312documents30959 16402postgresmensageria-api10.0.16.217 156472025-08-20 06:46:55.010904-032025-08-20 07:04:03.798454-032025-08-20 07:04:03.798701-032025-08-20 07:04:03.79872-03ClientClientReadidle in transaction 791390008 select solicitaca0_.id as id1_2_, solicitaca0_.cnpj as cnpj2_2_, solicitaca0_.codigo_status_resposta as codigo_s3_2_, solicitaca0_.data_fim_download as data_fim4_2_, solicitaca0_.data_inicio_download as data_ini5_2_, solicitaca0_.data_solicitacao as data_sol6_2_, solicitaca0_.data_ultima_resposta as data_ult7_2_, solicitaca0_.descricao_status_resposta as descrica8_2_, solicitaca0_.maximo_nsu_disponivel as maximo_n9_2_, solicitaca0_.mensagem_erro as mensage10_2_, solicitaca0_.nsu_inicio as nsu_ini11_2_, solicitaca0_.quantidade_documentos as quantid12_2_, solicitaca0_.status as status13_2_, solicitaca0_.ultimo_nsu_disponivel as ultimo_14_2_, solicitaca0_.ultimo_nsu_solicitado as ultimo_15_2_ from public.solicitacao_download_nfe solicitaca0_ where solicitaca0_.cnpj=$1 order by solicitaca0_.id desc limit $2client backend
16450fiscal1466 16402postgrescfe-importar-sqs10.0.16.55 557532025-08-20 06:57:24.536443-03 2025-08-20 07:04:02.920684-032025-08-20 07:04:02.920736-03ClientClientReadidle    client backend
1665815312documents31108 16402postgresmensageria-api10.0.16.55 437832025-08-20 06:48:21.351122-032025-08-20 07:04:03.799568-032025-08-20 07:04:03.806933-032025-08-20 07:04:03.806933-03ClientClientReadactive   COMMITclient backend
3333716331revizia1467 16402postgrescfe-importar-sqs10.0.20.107 654212025-08-20 06:57:24.549599-03 2025-08-20 07:04:02.919335-032025-08-20 07:04:02.91934-03ClientClientReadidle    client backend
1665815312documents1801 16402postgrescfe-job-download-documentos-recorrentes10.0.16.232 130792025-08-20 07:00:05.141069-03 2025-08-20 07:04:03.721102-032025-08-20 07:04:03.721198-03ClientClientReadidle    client backend
1665815312documents1469 16402postgrescfe-importar-sqs10.0.16.217 352772025-08-20 06:57:24.795499-032025-08-20 07:04:00.374748-032025-08-20 07:04:02.058122-032025-08-20 07:04:02.060662-03ClientClientReadidle in transaction 791390008 select documentst0_.cnpj_issuer as cnpj_iss1_1_, documentst0_.type as type2_1_, documentst0_.key as key3_1_, documentst0_.nsu as nsu4_1_, documentst0_.protocol as protocol5_1_, documentst0_.available_at as availabl6_1_, documentst0_.canceled_at as canceled7_1_, documentst0_.cce_events as cce_even8_1_, documentst0_.cce_updated_at as cce_upda9_1_, documentst0_.created_at as created10_1_, documentst0_.created_by as created11_1_, documentst0_.manifestation as manifes12_1_, documentst0_.status as status13_1_, documentst0_.updated_at as updated14_1_, documentst0_.updated_by as updated15_1_ from public.document_status documentst0_ where documentst0_.key=$1 limit $2client backend
1665815312documents1157 16402postgrescte-lambda-aws10.0.16.46 267532025-08-20 06:56:10.370914-03 2025-08-20 07:02:44.897272-032025-08-20 07:02:44.900916-03ClientClientReadidle   COMMITclient backend
16450fiscal2988 16402postgreslambda-go-revizia-metrics10.0.16.91 514252025-08-20 07:03:05.750398-03 2025-08-20 07:03:06.533153-032025-08-20 07:03:06.536953-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
3333716331revizia1468 16402postgrescfe-importar-sqs10.0.16.46 392872025-08-20 06:57:24.795191-03 2025-08-20 07:04:02.8841-032025-08-20 07:04:02.884152-03ClientClientReadidle    client backend
16450fiscal1470 16402postgrescfe-importar-sqs10.0.16.217 338952025-08-20 06:57:24.795945-03 2025-08-20 07:04:03.237183-032025-08-20 07:04:03.237286-03ClientClientReadidle    client backend
1665815312documents698 16402postgresnfse-lambda-aws10.0.16.91 195152025-08-20 06:55:24.100777-032025-08-20 07:04:03.774825-032025-08-20 07:04:03.800218-032025-08-20 07:04:03.800218-03  active 791390008 update document set info = cast($1 as jsonb) where key = $2 and data_emissao = $3 client backend
3333716331revizia2905 16402postgressped-importar-from-sqs10.0.16.225 640092025-08-20 07:02:28.436777-03 2025-08-20 07:02:32.777423-032025-08-20 07:02:32.777551-03ClientClientReadidle    client backend
16450fiscal15994 16402postgrespgAdmin 4 - CONN:754989310.0.28.38 534582025-08-19 18:42:28.407682-032025-08-19 21:44:18.146821-032025-08-19 21:23:36.591822-032025-08-19 21:23:36.591823-03IODataFileReadactive7914043587913896821558538948540241973CALL delete_empresa_limpeza(3)client backend
1665815312documents1591 16402postgresintegracao-fluxo-pagamento-worker10.0.16.55 499852025-08-20 06:58:17.010536-03 2025-08-20 07:03:57.535556-032025-08-20 07:03:57.535683-03ClientClientReadidle   ROLLBACKclient backend
1665815312documents2906 16402postgressped-importar-from-sqs10.0.16.46 427972025-08-20 07:02:28.437039-03 2025-08-20 07:02:35.654879-032025-08-20 07:02:35.656135-03ClientClientReadidle   COMMITclient backend
1665815312documents27597 16402postgresnfe-lambda-aws10.0.16.232 643892025-08-20 06:27:14.909105-03 2025-08-20 07:04:03.188373-032025-08-20 07:04:03.190762-03ClientClientReadidle   COMMITclient backend
1665815312documents1677 16402postgrescfe-importar-sqs10.0.20.107 400052025-08-20 06:59:06.016381-032025-08-20 07:04:01.881851-032025-08-20 07:04:03.353126-032025-08-20 07:04:03.35316-03ClientClientReadidle in transaction 791390008 select documentst0_.cnpj_issuer as cnpj_iss1_1_, documentst0_.type as type2_1_, documentst0_.key as key3_1_, documentst0_.nsu as nsu4_1_, documentst0_.protocol as protocol5_1_, documentst0_.available_at as availabl6_1_, documentst0_.canceled_at as canceled7_1_, documentst0_.cce_events as cce_even8_1_, documentst0_.cce_updated_at as cce_upda9_1_, documentst0_.created_at as created10_1_, documentst0_.created_by as created11_1_, documentst0_.manifestation as manifes12_1_, documentst0_.status as status13_1_, documentst0_.updated_at as updated14_1_, documentst0_.updated_by as updated15_1_ from public.document_status documentst0_ where documentst0_.key=$1 limit $2client backend
1665815312documents31952 16402postgrescte-lambda-aws10.0.16.91 635492025-08-20 06:52:11.639768-03 2025-08-20 07:03:35.585851-032025-08-20 07:03:35.58819-03ClientClientReadidle   COMMITclient backend
1665815312documents1683 16402postgrescfe-importar-sqs10.0.16.232 612812025-08-20 06:59:08.225155-032025-08-20 07:04:02.170652-032025-08-20 07:04:03.652203-032025-08-20 07:04:03.652231-03ClientClientReadidle in transaction 791390008 select documentst0_.cnpj_issuer as cnpj_iss1_1_, documentst0_.type as type2_1_, documentst0_.key as key3_1_, documentst0_.nsu as nsu4_1_, documentst0_.protocol as protocol5_1_, documentst0_.available_at as availabl6_1_, documentst0_.canceled_at as canceled7_1_, documentst0_.cce_events as cce_even8_1_, documentst0_.cce_updated_at as cce_upda9_1_, documentst0_.created_at as created10_1_, documentst0_.created_by as created11_1_, documentst0_.manifestation as manifes12_1_, documentst0_.status as status13_1_, documentst0_.updated_at as updated14_1_, documentst0_.updated_by as updated15_1_ from public.document_status documentst0_ where documentst0_.key=$1 limit $2client backend
1665815312documents3249 16402postgresdocument-api10.0.16.225 436192025-08-20 07:04:01.228203-032025-08-20 07:04:03.799936-032025-08-20 07:04:03.808538-032025-08-20 07:04:03.808538-03  active 791390008 select * from pg_stat_activityclient backend
1665815312documents31010 16402postgresnfe-lambda-aws10.0.16.225 209192025-08-20 06:47:28.1467-03 2025-08-20 07:03:44.786039-032025-08-20 07:03:44.788316-03ClientClientReadidle   COMMITclient backend
3333716331revizia1475 16402postgrescfe-importar-sqs10.0.16.91 37772025-08-20 06:57:29.659805-03 2025-08-20 07:04:02.607537-032025-08-20 07:04:02.607601-03ClientClientReadidle    client backend
1665815312documents3254 16402postgresnfse-lambda-aws10.0.20.66 290072025-08-20 07:04:03.020977-03 2025-08-20 07:04:03.575352-032025-08-20 07:04:03.578444-03ClientClientReadidle   COMMITclient backend
1665815312documents26550 3305731551dev_michael_alessanderDBeaver 25.1.4 - Main 10.0.28.38 603062025-08-20 06:23:10.793353-03 2025-08-20 06:23:12.413646-032025-08-20 06:23:12.413674-03ClientClientReadidle   SHOW search_pathclient backend
1665815312documents31412 16402postgrescfe-job-download-documentos10.0.16.225 272232025-08-20 06:50:40.212484-03 2025-08-20 07:03:54.67652-032025-08-20 07:03:54.677423-03ClientClientReadidle   COMMITclient backend
3333716331revizia18486 16402postgrespgAdmin 4 - CONN:836570210.0.28.38 490062025-08-14 23:15:11.693939-03 2025-08-14 23:15:17.31823-032025-08-14 23:15:17.318249-03ClientClientReadidle   SELECT oid, pg_catalog.format_type(oid, NULL) AS typname FROM pg_catalog.pg_type WHERE oid = ANY($1) ORDER BY oid;client backend
16450fiscal2907 16402postgressped-importar-from-sqs10.0.20.107 126532025-08-20 07:02:28.437306-03 2025-08-20 07:02:35.660191-032025-08-20 07:02:35.661945-03ClientClientReadidle   COMMITclient backend
16450fiscal1632 16402postgreslambda-go-revizia-metrics10.0.20.107 523792025-08-20 06:58:43.589875-03 2025-08-20 07:02:43.598996-032025-08-20 07:02:43.599491-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
1665815312documents30065 16402postgrescfe-job-download-documentos10.0.16.55 530472025-08-20 06:39:38.775626-03 2025-08-20 07:03:09.413802-032025-08-20 07:03:09.413847-03ClientClientReadidle    client backend
1665815312documents26554 3305731551dev_michael_alessanderDBeaver 25.1.4 - Metadata 10.0.28.38 603182025-08-20 06:23:12.546974-03 2025-08-20 06:23:18.647507-032025-08-20 06:23:18.647542-03ClientClientReadidle   SELECT i.*,c.relnamespace FROM pg_catalog.pg_inherits i,pg_catalog.pg_class c WHERE i.inhrelid=$1 AND c.oid=i.inhparent ORDER BY i.inhseqnoclient backend
1665815312documents31543 16402postgresmensageria-api10.0.16.225 374432025-08-20 06:51:30.17432-03 2025-08-20 07:03:59.95773-032025-08-20 07:03:59.957838-03ClientClientReadidle    client backend
1665815312documents26555 3305731551dev_michael_alessanderDBeaver 25.1.4 - SQLEditor 10.0.28.38 352262025-08-20 06:23:15.069687-03 2025-08-20 06:25:24.764844-032025-08-20 06:25:25.100659-03ClientClientReadidle  -8443625175337963435 update cfe_periodo_importacao_job set status ='PENDENTE'
where status = 'COM_ERRO_PERMANENTE'
and cnpj = '16602848000120'
and recorrente is false 		client backend
3333716331revizia1633 16402postgresnfe-lambda-aws10.0.16.55 407632025-08-20 06:58:44.630802-03 2025-08-20 07:03:56.96379-032025-08-20 07:03:56.964196-03ClientClientReadidle   SELECT 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
1665815312documents2917 16402postgrescte-lambda-aws10.0.16.225 11252025-08-20 07:02:39.066282-03 2025-08-20 07:03:32.639552-032025-08-20 07:03:32.641771-03ClientClientReadidle   COMMITclient backend
3333716331revizia2989 16402postgreslambda-go-revizia-metrics10.0.20.107 383252025-08-20 07:03:05.869817-03 2025-08-20 07:03:07.011536-032025-08-20 07:03:19.358632-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
16450fiscal3007 16402postgresfiscal-intelligence-sped-job10.0.16.55 615872025-08-20 07:03:11.99669-032025-08-20 07:04:03.793721-032025-08-20 07:04:03.794147-032025-08-20 07:04:03.794276-03ClientClientReadidle in transaction 791390008 SELECT bk.* FROM book_keeping bk WHERE bk.status = $1 ORDER BY created_at DESC client backend
1665815312documents1184 16402postgrescte-lambda-aws10.0.16.91 66152025-08-20 06:56:13.807837-03 2025-08-20 07:03:59.863857-032025-08-20 07:03:59.865126-03ClientClientReadidle   COMMITclient backend
1665815312documents1702 16402postgrescfe-job-queue-api10.0.16.232 625472025-08-20 06:59:23.454149-03 2025-08-20 07:03:53.6111-032025-08-20 07:03:53.611214-03ClientClientReadidle    client backend
1665815312documents707 16402postgresnfse-lambda-aws10.0.16.55 384112025-08-20 06:55:25.355242-03 2025-08-20 07:03:30.053981-032025-08-20 07:03:30.056522-03ClientClientReadidle   COMMITclient backend
1665815312documents2927 16402postgrescte-lambda-aws10.0.16.46 629792025-08-20 07:02:44.899604-03 2025-08-20 07:03:57.284521-032025-08-20 07:03:57.285881-03ClientClientReadidle   COMMITclient backend
1665815312documents1703 16402postgrescfe-job-queue-api10.0.16.232 500152025-08-20 06:59:23.478753-03 2025-08-20 07:03:53.607543-032025-08-20 07:03:53.607788-03ClientClientReadidle    client backend
1665815312documents28053 16402postgrescfe-job-queue-api10.0.20.107 145212025-08-20 06:29:24.338383-03 2025-08-20 07:03:53.691397-032025-08-20 07:03:53.691856-03ClientClientReadidle    client backend
3333716331revizia323 16402postgrescore-api10.0.16.217 582312025-08-20 06:54:27.72148-03 2025-08-20 07:03:36.305975-032025-08-20 07:03:36.305992-03ClientClientReadidle   COMMITclient backend
1665815312documents30153 16402postgresnfe-lambda-aws10.0.20.66 550232025-08-20 06:40:10.67042-03 2025-08-20 07:03:47.325527-032025-08-20 07:03:47.327701-03ClientClientReadidle   COMMITclient backend
16450fiscal31815 16402postgresprocessador-linhas-sped-api10.0.20.107 101152025-08-20 06:51:59.813227-03 2025-08-20 07:04:00.653738-032025-08-20 07:04:00.653779-03ClientClientReadidle    client backend
1665815312documents1716 16402postgresdownload-document-api10.0.16.55 433972025-08-20 06:59:29.906701-03 2025-08-20 07:02:04.850727-032025-08-20 07:02:04.850812-03ClientClientReadidle    client backend
1665815312documents29763 16402postgresdocument-api10.0.16.217 363932025-08-20 06:37:30.188147-03 2025-08-20 07:04:01.228706-032025-08-20 07:04:01.228859-03ClientClientReadidle    client backend
1665815312documents1717 16402postgresnfe-lambda-aws10.0.16.46 121072025-08-20 06:59:30.455882-03 2025-08-20 07:03:34.406338-032025-08-20 07:03:34.4096-03ClientClientReadidle   COMMITclient backend
1665815312documents2344 16402postgresmensageria-api10.0.16.91 386572025-08-20 07:01:12.162528-03 2025-08-20 07:03:37.382768-032025-08-20 07:03:37.384146-03ClientClientReadidle   COMMITclient backend
1665815312documents30092 16402postgresnfe-lambda-aws10.0.16.91 324512025-08-20 06:39:49.447388-03 2025-08-20 07:03:50.663504-032025-08-20 07:03:50.666208-03ClientClientReadidle   COMMITclient backend
3333716331revizia2351 16402postgresnfe-lambda-aws10.0.16.46 316412025-08-20 07:01:13.231117-03 2025-08-20 07:03:47.826507-032025-08-20 07:03:47.826572-03ClientClientReadidle   SELECT 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
3333716331revizia16715 16402postgrespgAdmin 4 - DB:revizia10.0.28.38 363162025-08-16 16:50:06.247273-03 2025-08-20 07:04:02.954922-032025-08-20 07:04:02.95948-03ClientClientReadidle  4653323128169443287/*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 = 3333716331)) AS "Total",
(SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 3333716331)) AS "Active",
(SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 3333716331)) 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 = 3333716331)) AS "Transactions",
(SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 3333716331)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 3333716331)) 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 = 3333716331)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 3333716331)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 3333716331)) 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 = 3333716331)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 3333716331)) 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 = 3333716331)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 3333716331)) AS "Hits"
) t
client backend
1665815312documents31132 16402postgrescfe-job-download-documentos10.0.16.91 397632025-08-20 06:48:37.019607-03 2025-08-20 07:03:54.529198-032025-08-20 07:03:54.530371-03ClientClientReadidle   COMMITclient backend
1665815312documents1189 16402postgrescfe-importar-sqs10.0.20.66 477172025-08-20 06:56:14.236081-032025-08-20 07:04:00.501481-032025-08-20 07:04:02.559257-032025-08-20 07:04:02.559293-03ClientClientReadidle in transaction791977670791390008 select documentst0_.cnpj_issuer as cnpj_iss1_1_, documentst0_.type as type2_1_, documentst0_.key as key3_1_, documentst0_.nsu as nsu4_1_, documentst0_.protocol as protocol5_1_, documentst0_.available_at as availabl6_1_, documentst0_.canceled_at as canceled7_1_, documentst0_.cce_events as cce_even8_1_, documentst0_.cce_updated_at as cce_upda9_1_, documentst0_.created_at as created10_1_, documentst0_.created_by as created11_1_, documentst0_.manifestation as manifes12_1_, documentst0_.status as status13_1_, documentst0_.updated_at as updated14_1_, documentst0_.updated_by as updated15_1_ from public.document_status documentst0_ where documentst0_.key=$1 limit $2client backend
1665815312documents1718 16402postgresnfe-lambda-aws10.0.16.46 349352025-08-20 06:59:30.472598-03 2025-08-20 07:03:18.232666-032025-08-20 07:03:18.234839-03ClientClientReadidle   COMMITclient backend
1665815312documents29027 16402postgrescfe-job-download-documentos10.0.20.66 531132025-08-20 06:33:49.760076-03 2025-08-20 07:03:51.297486-032025-08-20 07:03:51.298465-03ClientClientReadidle   COMMITclient backend
1665815312documents1812 16402postgrescfe-importar-sqs10.0.20.107 471512025-08-20 07:00:07.203863-03 2025-08-20 07:02:14.243808-032025-08-20 07:02:14.245808-03ClientClientReadidle   COMMITclient backend
16450fiscal16043 16402postgrespgAdmin 4 - CONN:381667910.0.28.38 361882025-08-19 18:42:42.079285-032025-08-20 03:04:53.183729-032025-08-19 21:23:35.241255-032025-08-19 21:23:35.241256-03IODataFileReadactive791872570791390008-2828850295681666026CALL delete_empresa_limpeza(2)client backend
1665815312documents31981 16402postgrescte-lambda-aws10.0.16.55 242212025-08-20 06:52:14.241699-03 2025-08-20 07:03:44.841311-032025-08-20 07:03:44.842531-03ClientClientReadidle   COMMITclient backend
3333716331revizia31171 16402postgrescore-api10.0.16.217 312092025-08-20 06:48:59.778486-03 2025-08-20 07:03:36.312649-032025-08-20 07:03:36.312713-03ClientClientReadidle   COMMITclient backend
1665815312documents2928 16402postgrescte-lambda-aws10.0.16.46 163372025-08-20 07:02:44.90109-03 2025-08-20 07:03:36.301762-032025-08-20 07:03:36.305146-03ClientClientReadidle   COMMITclient backend
1665815312documents1811 16402postgrescfe-importar-sqs10.0.16.91 410492025-08-20 07:00:07.05655-03 2025-08-20 07:02:13.402244-032025-08-20 07:02:13.403539-03ClientClientReadidle   COMMITclient backend
1665815312documents2358 16402postgrescfe-importar-sqs10.0.20.107 45872025-08-20 07:01:14.28876-03 2025-08-20 07:04:03.693047-032025-08-20 07:04:03.694388-03ClientClientReadidle   COMMITclient backend
1665815312documents2929 16402postgrescte-lambda-aws10.0.20.107 70812025-08-20 07:02:44.918746-03 2025-08-20 07:03:33.441958-032025-08-20 07:03:33.44467-03ClientClientReadidle   COMMITclient backend
3333716331revizia31172 16402postgresmensageria-api10.0.20.107 286772025-08-20 06:48:59.78526-03 2025-08-20 07:04:00.537618-032025-08-20 07:04:00.537742-03ClientClientReadidle    client backend
1665815312documents3008 16402postgresnfe-lambda-aws10.0.16.225 428552025-08-20 07:03:13.262089-03 2025-08-20 07:03:15.011871-032025-08-20 07:03:15.014279-03ClientClientReadidle   COMMITclient backend
1665815312documents2930 16402postgrescte-lambda-aws10.0.16.217 352572025-08-20 07:02:45.198797-03 2025-08-20 07:03:35.15217-032025-08-20 07:03:35.154396-03ClientClientReadidle   COMMITclient backend
1665815312documents32045 16402postgrescte-lambda-aws10.0.16.232 304912025-08-20 06:52:23.572394-03 2025-08-20 07:03:35.264807-032025-08-20 07:03:35.266947-03ClientClientReadidle   COMMITclient backend
1665815312documents1814 16402postgrescfe-importar-sqs10.0.16.91 427152025-08-20 07:00:07.822531-03 2025-08-20 07:03:35.263053-032025-08-20 07:03:35.263129-03ClientClientReadidle   COMMITclient backend
1665815312documents826 16402postgrescfe-job-download-documentos10.0.16.217 621872025-08-20 06:55:37.705183-03 2025-08-20 07:03:51.440949-032025-08-20 07:03:51.441863-03ClientClientReadidle   COMMITclient backend
1665815312documents29132 16402postgresnfe-lambda-aws10.0.16.55 399752025-08-20 06:34:05.944881-03 2025-08-20 07:04:02.798995-032025-08-20 07:04:02.801624-03ClientClientReadidle   COMMITclient backend
1665815312documents1726 16402postgresnfe-lambda-aws10.0.16.55 453312025-08-20 06:59:34.989336-03 2025-08-20 07:04:02.528649-032025-08-20 07:04:02.530824-03ClientClientReadidle   COMMITclient backend
1665815312documents31304 16402postgresnfse-lambda-aws10.0.16.46 577232025-08-20 06:49:42.830467-03 2025-08-20 07:03:57.031106-032025-08-20 07:03:57.035243-03ClientClientReadidle   COMMITclient backend
1665815312documents1738 16402postgrescfe-job-download-documentos10.0.16.232 322192025-08-20 06:59:41.323805-03 2025-08-20 07:03:52.810234-032025-08-20 07:03:52.811648-03ClientClientReadidle   COMMITclient backend
1665815312documents2940 16402postgresnfe-lambda-aws10.0.16.46 168992025-08-20 07:02:50.132986-03 2025-08-20 07:04:02.956757-032025-08-20 07:04:02.958997-03ClientClientReadidle   COMMITclient backend
1665815312documents3011 16402postgresnfe-lambda-aws10.0.20.107 642172025-08-20 07:03:15.764726-03 2025-08-20 07:04:01.185779-032025-08-20 07:04:01.189207-03ClientClientReadidle   COMMITclient backend
3333716331revizia23776 16402postgrespgAdmin 4 - CONN:170045610.0.28.38 560182025-08-19 15:43:53.625876-03 2025-08-19 15:48:11.087938-032025-08-19 15:48:11.087997-03ClientClientReadidle  -4364344397713342668commit transaction;client backend
1665815312documents3012 16402postgresnfe-lambda-aws10.0.20.107 281792025-08-20 07:03:15.785761-03 2025-08-20 07:04:02.504308-032025-08-20 07:04:02.507028-03ClientClientReadidle   COMMITclient backend
1665815312documents3015 16402postgresnfe-lambda-aws10.0.20.66 512572025-08-20 07:03:17.350791-03 2025-08-20 07:04:01.963433-032025-08-20 07:04:01.965866-03ClientClientReadidle   COMMITclient backend
1665815312documents3016 16402postgresnfe-lambda-aws10.0.16.46 234492025-08-20 07:03:18.24833-03 2025-08-20 07:03:55.250908-032025-08-20 07:03:55.253005-03ClientClientReadidle   COMMITclient backend
16450fiscal16061 16402postgrespgAdmin 4 - CONN:381667910.0.28.38 456642025-08-19 18:42:46.056255-032025-08-19 21:34:46.057489-032025-08-19 21:23:31.857188-032025-08-19 21:23:31.857189-03IODataFileReadactive791390008791381083-7402057875979027787CALL delete_empresa_limpeza(1)client backend
3333716331revizia31430 16402postgrescore-api10.0.16.232 555172025-08-20 06:50:52.30533-03 2025-08-20 07:03:36.285461-032025-08-20 07:03:36.285492-03ClientClientReadidle   COMMITclient backend
1665815312documents27124 16402postgresmensageria-api10.0.16.217 495512025-08-20 06:25:46.973157-03 2025-08-20 07:03:32.360283-032025-08-20 07:03:32.362168-03ClientClientReadidle   COMMITclient backend
1665815312documents3017 16402postgresecac-situacao-fiscal-api10.0.20.66 426012025-08-20 07:03:20.431819-03 2025-08-20 07:04:02.364159-032025-08-20 07:04:02.364191-03ClientClientReadidle    client backend
16450fiscal2359 16402postgrescfe-importar-sqs10.0.16.91 627172025-08-20 07:01:14.289263-03 2025-08-20 07:04:03.279751-032025-08-20 07:04:03.279954-03ClientClientReadidle    client backend
3333716331revizia856 16402postgresnfe-lambda-aws10.0.16.225 192732025-08-20 06:55:41.417606-03 2025-08-20 07:03:59.752841-032025-08-20 07:03:59.753235-03ClientClientReadidle   SELECT 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
1665815312documents3031 16402postgrescte-lambda-aws10.0.16.217 576412025-08-20 07:03:28.742722-03 2025-08-20 07:03:30.328277-032025-08-20 07:03:30.33065-03ClientClientReadidle   COMMITclient backend
1665815312documents29154 16402postgresmensageria-api10.0.20.66 336532025-08-20 06:34:10.291898-03 2025-08-20 07:03:53.191032-032025-08-20 07:03:53.192236-03ClientClientReadidle   COMMITclient backend
1665815312documents29889 16402postgresnfe-lambda-aws10.0.20.107 325352025-08-20 06:37:48.536849-03 2025-08-20 07:03:15.797734-032025-08-20 07:03:15.799921-03ClientClientReadidle   COMMITclient backend
3333716331revizia857 16402postgresnfe-lambda-aws10.0.16.232 154472025-08-20 06:55:41.429489-03 2025-08-20 07:03:34.752475-032025-08-20 07:03:34.75331-03ClientClientReadidle   SELECT 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
1665815312documents3032 16402postgrescte-lambda-aws10.0.20.66 608732025-08-20 07:03:29.295009-03 2025-08-20 07:03:29.60331-032025-08-20 07:03:29.60609-03ClientClientReadidle   COMMITclient backend
1665815312documents30216 16402postgrescfe-job-download-documentos10.0.20.107 159812025-08-20 06:40:48.725818-03 2025-08-20 07:03:53.754616-032025-08-20 07:03:53.756653-03ClientClientReadidle   COMMITclient backend
5postgres21980 3305731552dev_rafael_carvalhopgAdmin 4 - DB:postgres10.0.28.38 341702025-08-19 18:58:23.351203-03 2025-08-19 18:59:10.009558-032025-08-19 18:59:10.01302-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
16450fiscal22003 3305731552dev_rafael_carvalhopgAdmin 4 - DB:fiscal10.0.28.38 335162025-08-19 18:58:25.1666-03 2025-08-19 18:58:26.969697-032025-08-19 18:58:26.976031-03ClientClientReadidle  -6488867169811202377
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
3333716331revizia863 16402postgresnfe-lambda-aws10.0.16.91 612972025-08-20 06:55:42.361208-03 2025-08-20 07:04:01.805766-032025-08-20 07:04:01.806161-03ClientClientReadidle   SELECT 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
16450fiscal1228 16402postgresecac-darf-job-download-documentos10.0.16.225 518952025-08-20 06:56:18.921446-03 2025-08-20 07:03:15.155963-032025-08-20 07:03:15.156052-03ClientClientReadidle  -4199849316459484872DISCARD ALL;client backend
1665815312documents1817 16402postgrescfe-job-download-documentos-recorrentes10.0.16.55 171692025-08-20 07:00:09.047007-03 2025-08-20 07:04:03.586999-032025-08-20 07:04:03.587051-03ClientClientReadidle    client backend
1665815312documents32079 16402postgrescte-lambda-aws10.0.20.107 114772025-08-20 06:52:27.458574-03 2025-08-20 07:03:33.513148-032025-08-20 07:03:33.515304-03ClientClientReadidle   COMMITclient backend
1665815312documents3033 16402postgrescte-lambda-aws10.0.20.66 151372025-08-20 07:03:29.607737-03 2025-08-20 07:03:33.576751-032025-08-20 07:03:33.579398-03ClientClientReadidle   COMMITclient backend
16450fiscal26601 16402postgrespgAdmin 4 - CONN:820239810.0.28.38 481982025-08-15 06:43:24.036689-03 2025-08-15 06:45:26.126218-032025-08-15 06:45:26.126249-03ClientClientReadidle   SELECT oid, pg_catalog.format_type(oid, NULL) AS typname FROM pg_catalog.pg_type WHERE oid = ANY($1) ORDER BY oid;client backend
3333716331revizia866 16402postgresnfe-lambda-aws10.0.16.217 621012025-08-20 06:55:42.510127-03 2025-08-20 07:04:02.389523-032025-08-20 07:04:02.389911-03ClientClientReadidle   SELECT 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
1665815312documents3034 16402postgrescte-lambda-aws10.0.16.232 141112025-08-20 07:03:31.758684-03 2025-08-20 07:03:35.173906-032025-08-20 07:03:35.176135-03ClientClientReadidle   COMMITclient backend
3333716331revizia868 16402postgresnfe-lambda-aws10.0.20.66 635092025-08-20 06:55:42.981712-03 2025-08-20 07:03:54.709812-032025-08-20 07:03:54.710209-03ClientClientReadidle   SELECT 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
1665815312documents32182 16402postgrescte-lambda-aws10.0.16.217 216732025-08-20 06:52:41.67406-03 2025-08-20 07:03:35.381405-032025-08-20 07:03:35.383568-03ClientClientReadidle   COMMITclient backend
16450fiscal956 16402postgrespgAdmin 4 - CONN:322867310.0.28.38 427522025-08-19 17:51:57.679838-032025-08-20 05:55:57.45128-032025-08-19 21:23:38.10587-032025-08-19 21:23:38.105871-03IODataFileReadactive7919565807913900085416383927653580847CALL delete_empresa_limpeza(4)client backend
1665815312documents3574 16402postgrescfe-job-download-documentos-recorrentes10.0.16.232 115812025-08-20 05:47:47.345083-03 2025-08-20 07:03:55.132093-032025-08-20 07:03:55.132114-03ClientClientReadidle    client backend
1665815312documents3037 16402postgrescte-lambda-aws10.0.16.225 216592025-08-20 07:03:32.54861-03 2025-08-20 07:03:35.530241-032025-08-20 07:03:35.532233-03ClientClientReadidle   COMMITclient backend
1665815312documents30320 16402postgrescfe-job-download-documentos10.0.16.225 611672025-08-20 06:41:41.712041-03 2025-08-20 07:03:51.913943-032025-08-20 07:03:51.914041-03ClientClientReadidle    client backend
3333716331revizia2367 16402postgrescfe-importar-sqs10.0.16.55 371952025-08-20 07:01:15.20698-03 2025-08-20 07:02:02.970304-032025-08-20 07:02:02.970567-03ClientClientReadidle    client backend
1665815312documents3038 16402postgrescte-lambda-aws10.0.16.225 145012025-08-20 07:03:32.561717-03 2025-08-20 07:03:35.619339-032025-08-20 07:03:35.621602-03ClientClientReadidle   COMMITclient backend
1665815312documents3039 16402postgrescte-lambda-aws10.0.20.107 322812025-08-20 07:03:33.345246-03 2025-08-20 07:03:51.53382-032025-08-20 07:03:51.535138-03ClientClientReadidle   COMMITclient backend
1665815312documents1303 16402postgrescfe-job-download-documentos-recorrentes10.0.16.217 446152025-08-20 06:56:27.69394-03 2025-08-20 07:04:01.779235-032025-08-20 07:04:01.779294-03ClientClientReadidle    client backend
1665815312documents3040 16402postgrescte-lambda-aws10.0.16.55 587532025-08-20 07:03:33.462455-03 2025-08-20 07:03:33.835299-032025-08-20 07:03:33.837376-03ClientClientReadidle   COMMITclient backend
16450fiscal882 16402postgresrvz-esocial-importador10.0.16.55 125072025-08-20 06:55:44.574595-032025-08-20 06:55:53.499773-032025-08-20 07:04:03.532869-032025-08-20 07:04:03.535104-03ClientClientReadidle in transaction791965611791390008 select esocialcon0_.id as col_0_0_ from esocial_contribuicao_consolidada_contribuinte_s5011 esocialcon0_ where esocialcon0_.nome_arquivo=$1 limit $2client backend
1665815312documents32292 16402postgrescfe-importar-sqs10.0.20.66 305312025-08-20 06:52:57.928436-032025-08-20 07:04:03.259795-032025-08-20 07:04:03.79956-032025-08-20 07:04:03.799621-03ClientClientReadidle in transaction791977829 -794441490955842142insert into public.document_status (available_at, canceled_at, cce_events, cce_updated_at, created_at, created_by, manifestation, status, updated_at, updated_by, cnpj_issuer, type, key, nsu, protocol) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)client backend
16450fiscal3043 16402postgresecac-darf-job-download-documentos10.0.20.107 386212025-08-20 07:03:35.296978-03 2025-08-20 07:04:02.187267-032025-08-20 07:04:02.187348-03ClientClientReadidle    client backend
1665815312documents1759 16402postgrescfe-job-download-documentos-recorrentes10.0.20.66 401012025-08-20 06:59:49.580584-03 2025-08-20 07:03:02.691662-032025-08-20 07:03:02.691751-03ClientClientReadidle    client backend
1665815312documents32262 16402postgrescfe-job-download-documentos10.0.16.46 23172025-08-20 06:52:53.039649-03 2025-08-20 07:03:52.808561-032025-08-20 07:03:52.809871-03ClientClientReadidle   COMMITclient backend
1665815312documents2366 16402postgrescfe-importar-sqs10.0.16.55 291192025-08-20 07:01:15.206978-032025-08-20 07:04:02.984222-032025-08-20 07:04:03.799156-032025-08-20 07:04:03.799227-03ClientClientReadidle in transaction 791390008 select document0_.cnpj_issuer as cnpj_iss1_0_, document0_.type as type2_0_, document0_.key as key3_0_, document0_.nsu as nsu4_0_, document0_.protocol as protocol5_0_, document0_.cnpj as cnpj6_0_, document0_.cnpj_addressee as cnpj_add7_0_, document0_.cnpj_carrier as cnpj_car8_0_, document0_.data as data9_0_, document0_.data_emissao as data_em10_0_, document0_.group_type as group_t11_0_, document0_.gzip as gzip12_0_, document0_.import_type as import_13_0_, document0_.imported_at as importe14_0_, document0_.info as info15_0_, document0_.inscricao_estadual as inscric16_0_, document0_.migrated as migrate17_0_, document0_.name_file as name_fi18_0_, document0_.request_id as request19_0_, document0_.schema as schema20_0_, document0_.validated as validat21_0_ from public.document document0_ where document0_.key=$1 and (document0_.data_emissao between $2 and $3) and (document0_.type in ($4)) limit $5client backend
16450fiscal3570 16402postgrespgAdmin 4 - DB:fiscal10.0.28.38 341142025-08-19 10:32:47.541758-03 2025-08-19 18:43:37.247118-032025-08-19 18:43:37.247307-03ClientClientReadidle  -6488867169811202377SELECT pg_cancel_backend(956);client backend
3333716331revizia32304 16402postgresrvz-sintegra-job10.0.16.225 76032025-08-20 06:52:59.824599-03 2025-08-20 07:03:59.957608-032025-08-20 07:03:59.957738-03ClientClientReadidle    client backend
1665815312documents1392 16402postgrescfe-job-download-documentos10.0.16.46 397272025-08-20 06:56:44.504874-03 2025-08-20 07:03:48.059009-032025-08-20 07:03:48.060121-03ClientClientReadidle   COMMITclient backend
3333716331revizia3045 16402postgrescore-api10.0.16.55 618632025-08-20 07:03:36.28468-03 2025-08-20 07:04:03.320961-032025-08-20 07:04:03.321026-03ClientClientReadidle   ROLLBACKclient backend
3333716331revizia509 16402postgrescertificado-api10.0.16.91 567152025-08-20 06:54:59.845422-03 2025-08-20 07:04:03.413778-032025-08-20 07:04:03.413811-03ClientClientReadidle   ROLLBACKclient backend
1665815312documents7236 16402postgrescfe-job-download-documentos-recorrentes10.0.16.91 175612025-08-20 05:54:58.297732-03 2025-08-20 07:04:03.779165-032025-08-20 07:04:03.779255-03ClientClientReadidle    client backend
1665815312documents1766 16402postgresnfe-lambda-aws10.0.16.232 83172025-08-20 06:59:51.777114-03 2025-08-20 07:03:31.455109-032025-08-20 07:03:31.458525-03ClientClientReadidle   COMMITclient backend
3333716331revizia960 16402postgresnfe-lambda-aws10.0.20.107 145892025-08-20 06:55:53.369641-03 2025-08-20 07:03:54.625022-032025-08-20 07:03:54.625407-03ClientClientReadidle   SELECT 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
1665815312documents1394 16402postgresnfe-lambda-aws10.0.16.91 231692025-08-20 06:56:45.022528-03 2025-08-20 07:03:48.470448-032025-08-20 07:03:48.472688-03ClientClientReadidle   COMMITclient backend
16450fiscal963 16402postgresrvz-esocial-importador10.0.16.232 593272025-08-20 06:55:53.619881-032025-08-20 07:04:03.555-032025-08-20 07:04:03.808548-032025-08-20 07:04:03.808615-03ClientClientReadidle in transaction791977838791390008 select nextval ('esocial_indentificacao_lotacao_id_seq')client backend
3333716331revizia3050 16402postgresgo-sped-api10.0.16.225 318352025-08-20 07:03:38.535364-03 2025-08-20 07:03:38.560744-032025-08-20 07:03:38.575755-03ClientClientReadidle   
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
16450fiscal3061 16402postgresfiscal-intelligence-sped-job10.0.20.107 502352025-08-20 07:03:42.39696-03 2025-08-20 07:03:44.946786-032025-08-20 07:03:44.946794-03ClientClientReadidle   ROLLBACKclient backend
16450fiscal3062 16402postgreslambda-go-revizia-metrics10.0.16.232 334632025-08-20 07:03:43.584639-03 2025-08-20 07:03:43.607558-032025-08-20 07:03:43.609289-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
16450fiscal1827 16402postgresreinf-importador-from-sqs10.0.16.91 438272025-08-20 07:00:13.277155-03 2025-08-20 07:02:08.405688-032025-08-20 07:02:08.408165-03ClientClientReadidle   COMMITclient backend
1665815312documents1830 16402postgrescfe-importar-sqs10.0.16.46 420372025-08-20 07:00:15.789862-03 2025-08-20 07:04:03.670779-032025-08-20 07:04:03.672328-03ClientClientReadidle   COMMITclient backend
1665815312documents1422 16402postgresdocument-api10.0.16.46 428852025-08-20 06:56:59.872487-03 2025-08-20 07:02:34.850412-032025-08-20 07:02:34.850493-03ClientClientReadidle    client backend
1665815312documents3069 16402postgresnfe-lambda-aws10.0.16.217 199752025-08-20 07:03:48.120263-03 2025-08-20 07:04:03.732695-032025-08-20 07:04:03.735363-03ClientClientReadidle   COMMITclient backend
1665815312documents2376 16402postgresnfse-lambda-aws10.0.20.66 457452025-08-20 07:01:15.886594-03 2025-08-20 07:04:03.20194-032025-08-20 07:04:03.204421-03ClientClientReadidle   COMMITclient backend
1665815312documents3089 16402postgrescfe-job-download-documentos10.0.16.232 567432025-08-20 07:03:52.800791-03 2025-08-20 07:03:52.836153-032025-08-20 07:03:52.838679-03ClientClientReadidle   COMMITclient backend
3333716331revizia1539 16402postgresrvz-sintegra-job10.0.20.66 173252025-08-20 06:57:59.883247-03 2025-08-20 07:04:00.655754-032025-08-20 07:04:00.655785-03ClientClientReadidle    client backend
1665815312documents1764 16402postgrescfe-job-download-documentos10.0.16.217 395172025-08-20 06:59:50.730226-03 2025-08-20 07:03:51.297879-032025-08-20 07:03:51.299999-03ClientClientReadidle   COMMITclient backend
1665815312documents1778 16402postgrescte-lambda-aws10.0.20.66 237512025-08-20 06:59:57.799237-03 2025-08-20 07:04:03.25189-032025-08-20 07:04:03.253177-03ClientClientReadidle   COMMITclient backend
16450fiscal1781 16402postgresprocessador-linhas-sped-api10.0.16.225 240832025-08-20 06:59:59.910667-03 2025-08-20 07:04:00.527634-032025-08-20 07:04:00.527743-03ClientClientReadidle    client backend
1665815312documents1851 16402postgrescfe-job-download-documentos-recorrentes10.0.16.46 148032025-08-20 07:00:19.332347-03 2025-08-20 07:04:03.730323-032025-08-20 07:04:03.730411-03ClientClientReadidle    client backend
16450fiscal3137 16402postgresrps-barueri-emissao-api10.0.16.55 63332025-08-20 07:03:57.695634-03 2025-08-20 07:03:57.725854-032025-08-20 07:03:57.725878-03ClientClientReadidle   ROLLBACKclient backend
1665815312documents3152 16402postgresmensageria-api10.0.16.55 442552025-08-20 07:03:58.005594-03 2025-08-20 07:04:00.919972-032025-08-20 07:04:00.920099-03ClientClientReadidle   COMMITclient backend
1665815312documents1898 16402postgresnfse-lambda-aws10.0.16.225 606472025-08-20 07:00:25.048086-03 2025-08-20 07:04:03.455033-032025-08-20 07:04:03.460166-03ClientClientReadidle   COMMITclient backend
5postgres3723 16402postgrespgAdmin 4 - DB:postgres10.0.28.38 387542025-08-19 10:33:57.773971-03 2025-08-20 07:04:01.34309-032025-08-20 07:04:01.346639-03ClientClientReadidle  -3012509240442274851/*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) AS "Total",
(SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active') AS "Active",
(SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle') 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) AS "Transactions",
(SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) 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) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) 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) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) 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) AS "Reads",
(SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t
client backend
1665815312documents2034 16402postgresnfse-lambda-aws10.0.16.91 228132025-08-20 07:00:38.42366-032025-08-20 07:04:03.729412-032025-08-20 07:04:03.774311-032025-08-20 07:04:03.786962-03ClientClientReadidle in transaction791977844 1837391871733709138update document set info = cast($1 as jsonb) where key = $2 and data_emissao = $3 client backend
1665815312documents1911 16402postgresnfe-lambda-aws10.0.16.225 109992025-08-20 07:00:26.258486-03 2025-08-20 07:04:00.987353-032025-08-20 07:04:00.990593-03ClientClientReadidle   COMMITclient backend
1665815312documents1928 16402postgresdownload-document-api10.0.16.232 239252025-08-20 07:00:27.5575-03 2025-08-20 07:04:01.154542-032025-08-20 07:04:01.155704-03ClientClientReadidle   COMMITclient backend
1665815312documents1931 16402postgresdownload-document-api10.0.16.55 375652025-08-20 07:00:27.55862-03 2025-08-20 07:04:00.654089-032025-08-20 07:04:00.654149-03ClientClientReadidle    client backend
1665815312documents2054 16402postgrescfe-job-download-documentos10.0.20.107 388252025-08-20 07:00:40.492341-03 2025-08-20 07:03:53.796311-032025-08-20 07:03:53.798792-03ClientClientReadidle   COMMITclient backend
16450fiscal2384 16402postgrescfe-importar-sqs10.0.16.46 292852025-08-20 07:01:16.8763-03 2025-08-20 07:04:03.215576-032025-08-20 07:04:03.215653-03ClientClientReadidle    client backend
1665815312documents2098 16402postgrescfe-job-download-documentos10.0.16.46 324832025-08-20 07:00:46.3194-03 2025-08-20 07:03:02.252141-032025-08-20 07:03:02.253514-03ClientClientReadidle   COMMITclient backend
3333716331revizia2240 16402postgrescertificado-api10.0.16.232 446972025-08-20 07:00:59.917479-03 2025-08-20 07:04:00.525038-032025-08-20 07:04:00.525245-03ClientClientReadidle    client backend
16450fiscal2398 16402postgrescfe-importar-sqs10.0.16.232 244632025-08-20 07:01:18.945877-03 2025-08-20 07:04:02.029171-032025-08-20 07:04:02.0294-03ClientClientReadidle    client backend
1665815312documents2399 16402postgrescfe-importar-sqs10.0.16.232 56552025-08-20 07:01:18.946475-032025-08-20 07:04:03.033294-032025-08-20 07:04:03.61614-032025-08-20 07:04:03.616173-03ClientClientReadidle in transaction 791390008 select documentst0_.cnpj_issuer as cnpj_iss1_1_, documentst0_.type as type2_1_, documentst0_.key as key3_1_, documentst0_.nsu as nsu4_1_, documentst0_.protocol as protocol5_1_, documentst0_.available_at as availabl6_1_, documentst0_.canceled_at as canceled7_1_, documentst0_.cce_events as cce_even8_1_, documentst0_.cce_updated_at as cce_upda9_1_, documentst0_.created_at as created10_1_, documentst0_.created_by as created11_1_, documentst0_.manifestation as manifes12_1_, documentst0_.status as status13_1_, documentst0_.updated_at as updated14_1_, documentst0_.updated_by as updated15_1_ from public.document_status documentst0_ where documentst0_.key=$1 limit $2client backend
3333716331revizia2415 16402postgrescfe-importar-sqs10.0.16.217 512792025-08-20 07:01:21.200115-03 2025-08-20 07:03:33.454073-032025-08-20 07:03:33.454155-03ClientClientReadidle    client backend
1665815312documents2416 16402postgrescfe-importar-sqs10.0.16.225 585972025-08-20 07:01:21.200384-03 2025-08-20 07:03:35.532834-032025-08-20 07:03:35.532888-03ClientClientReadidle   COMMITclient backend
1665815312documents2419 16402postgrescfe-importar-sqs10.0.20.66 305172025-08-20 07:01:21.667311-03 2025-08-20 07:03:35.008612-032025-08-20 07:03:35.00963-03ClientClientReadidle   COMMITclient backend
1665815312documents2459 16402postgrescfe-importar-sqs10.0.16.55 496172025-08-20 07:01:26.250744-03 2025-08-20 07:02:14.110451-032025-08-20 07:02:14.110514-03ClientClientReadidle   COMMITclient backend
1665815312documents2462 16402postgresmensageria-api10.0.20.107 194472025-08-20 07:01:26.570463-03 2025-08-20 07:03:49.034734-032025-08-20 07:03:49.035835-03ClientClientReadidle   COMMITclient backend
1665815312documents2488 16402postgresnfse-lambda-aws10.0.16.232 20532025-08-20 07:01:29.061119-03 2025-08-20 07:04:03.765798-032025-08-20 07:04:03.769707-03ClientClientReadidle   COMMITclient backend
1665815312documents2511 16402postgresnfse-lambda-aws10.0.16.46 375372025-08-20 07:01:32.710705-03 2025-08-20 07:03:30.018856-032025-08-20 07:03:30.021464-03ClientClientReadidle   COMMITclient backend
1665815312documents2539 16402postgresnfse-lambda-aws10.0.16.217 154592025-08-20 07:01:36.039621-032025-08-20 07:04:03.731635-032025-08-20 07:04:03.774711-032025-08-20 07:04:03.784601-03ClientClientReadidle in transaction791977843 1837391871733709138update document set info = cast($1 as jsonb) where key = $2 and data_emissao = $3 client backend
1665815312documents2592 16402postgrescfe-job-download-documentos10.0.16.232 245112025-08-20 07:01:41.917999-03 2025-08-20 07:03:52.816032-032025-08-20 07:03:52.818422-03ClientClientReadidle   COMMITclient backend
1665815312documents2601 16402postgrescfe-job-download-documentos10.0.16.55 609252025-08-20 07:01:43.019578-03 2025-08-20 07:03:53.759229-032025-08-20 07:03:53.760166-03ClientClientReadidle   COMMITclient backend
16450fiscal2619 16402postgresfiscal-intelligence-sped-job10.0.20.66 323032025-08-20 07:01:45.405388-03 2025-08-20 07:03:37.422141-032025-08-20 07:03:37.422194-03ClientClientReadidle   ROLLBACKclient backend
16450fiscal2620 16402postgresfiscal-intelligence-sped-job10.0.16.91 616952025-08-20 07:01:45.44364-03 2025-08-20 07:04:02.695729-032025-08-20 07:04:02.695756-03ClientClientReadidle   COMMITclient backend
  888       2025-06-01 22:10:25.190835-03   ActivityBgWriterMain     background writer
  895       2025-06-01 22:10:25.239278-03   ActivityArchiverMain     archiver
  887       2025-06-01 22:10:25.190687-03   TimeoutCheckpointWriteDelay     checkpointer
  894       2025-06-01 22:10:25.23911-03   ActivityWalWriterMain     walwriter