pgBadger-
Global information
- Generated on Mon Sep 20 16:20:41 2021
- Log file: postgresql_20-09_21.log
- Parsed 50,008 log entries in 13s
- Log start from 2021-09-20 01:15:35 to 2021-09-20 09:19:54
-
Overview
Global Stats
- 1,054 Number of unique normalized queries
- 10,905 Number of queries
- 6h11m14s Total query duration
- 2021-09-20 01:15:35 First query
- 2021-09-20 09:19:54 Last query
- 16 queries/s at 2021-09-20 09:14:17 Query peak
- 6h11m14s Total query duration
- 933ms Prepare/parse total duration
- 47s624ms Bind total duration
- 6h10m26s Execute total duration
- 30 Number of events
- 5 Number of unique normalized events
- 23 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 776 Number temporary file
- 143.75 MiB Max size of temporary file
- 143.75 MiB Average size of temporary file
- 0 Total number of sessions
- 0 sessions at Session peak
- 0ms Total duration of sessions
- 0ms Average duration of sessions
- 10,905 Average queries per session
- 6h11m14s Average queries duration per session
- 0 Total number of connections
- 2 Total number of databases
SQL Traffic
Key values
- 16 queries/s Query Peak
- 2021-09-20 09:14:17 Date
SELECT Traffic
Key values
- 16 queries/s Query Peak
- 2021-09-20 09:14:17 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 6 queries/s Query Peak
- 2021-09-20 04:12:19 Date
Queries duration
Key values
- 6h11m14s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 20 01 184 247ms 3s796ms 2s693ms 17s370ms 17s957ms 21s47ms 02 251 264ms 14s68ms 3s17ms 18s687ms 21s678ms 1m3s 03 321 100ms 7m30s 14s64ms 3m2s 4m23s 8m5s 04 485 101ms 8m42s 8s611ms 2m18s 3m47s 8m48s 05 667 101ms 7m42s 6s883ms 2m26s 5m53s 8m15s 06 250 554ms 3s942ms 2s630ms 17s134ms 17s722ms 24s483ms 07 309 100ms 1m53s 2s684ms 21s212ms 24s534ms 2m3s 08 1,539 100ms 6m54s 832ms 25s347ms 31s206ms 7m21s 09 6,899 100ms 59s760ms 713ms 5m31s 5m38s 5m38s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 20 01 180 0 2s747ms 14s605ms 17s370ms 21s47ms 02 245 0 3s77ms 16s493ms 18s687ms 35s285ms 03 271 42 14s413ms 2m17s 2m53s 4m8s 04 243 236 8s712ms 1m31s 2m4s 4m5s 05 244 417 6s903ms 1m35s 2m20s 5m48s 06 244 0 2s680ms 14s349ms 17s134ms 19s982ms 07 303 0 2s729ms 16s840ms 21s212ms 54s259ms 08 1,529 0 834ms 17s276ms 25s347ms 44s82ms 09 6,061 0 765ms 4m47s 5m11s 5m20s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 20 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 1 2 0 0 644ms 0ms 0ms 0ms 09 606 205 25 0 338ms 12s53ms 16s616ms 17s634ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 20 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 1 0 0.00 0.15% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 3 16 5.33 0.20% 09 1 6,423 6,423.00 0.01% Day Hour Count Average / Second Sep 20 01 0 0.00/s 02 0 0.00/s 03 0 0.00/s 04 0 0.00/s 05 0 0.00/s 06 0 0.00/s 07 0 0.00/s 08 0 0.00/s 09 0 0.00/s Day Hour Count Average Duration Sep 20 01 0 0ms 02 0 0ms 03 0 0ms 04 0 0ms 05 0 0ms 06 0 0ms 07 0 0ms 08 0 0ms 09 0 0ms -
Connections
Established Connections
Key values
- 0 connections Connection Peak
- Date
Connections per database
Key values
- unknown Main Database
- 0 connections Total
Connections per user
Key values
- unknown Main User
- 0 connections Total
-
Sessions
Simultaneous sessions
Key values
- 0 sessions Session Peak
- Date
Histogram of session times
Key values
- duration
Sessions per database
Key values
- unknown Main Database
- 0 sessions Total
Sessions per user
Key values
- unknown Main User
- 0 sessions Total
Sessions per host
Key values
- unknown Main Host
- 0 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 32,786 buffers Checkpoint Peak
- 2021-09-20 09:17:26 Date
- 209.802 seconds Highest write time
- 0.156 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2021-09-20 04:13:51 Date
Checkpoints distance
Key values
- 433.16 Mo Distance Peak
- 2021-09-20 09:17:26 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 20 01 129 13.005s 0.183s 13.263s 02 177 17.874s 0.359s 18.592s 03 203 20.055s 0.374s 20.898s 04 177 17.727s 0.352s 18.355s 05 236 23.682s 0.293s 24.2s 06 178 17.956s 0.541s 18.655s 07 688 69.194s 0.378s 69.721s 08 777 78.083s 0.525s 78.829s 09 75,059 628.783s 0.341s 629.283s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 20 01 0 0 0 109 0.008s 0.01s 02 0 0 0 145 0.012s 0.023s 03 0 0 0 149 0.027s 0.025s 04 0 0 0 146 0.020s 0.025s 05 0 0 0 147 0.016s 0.018s 06 0 0 0 144 0.053s 0.038s 07 0 1 0 153 0.016s 0.024s 08 0 0 0 157 0.049s 0.034s 09 0 41 0 1,179 0.011s 0s Day Hour Count Avg time (sec) Sep 20 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s Day Hour Mean distance Mean estimate Sep 20 01 70.67 kB 85,546.44 kB 02 69.42 kB 29,163.42 kB 03 73.75 kB 8,292.08 kB 04 59.75 kB 2,384.50 kB 05 82.00 kB 733.00 kB 06 55.83 kB 247.92 kB 07 352.83 kB 402.33 kB 08 293.08 kB 2,204.58 kB 09 167,178.00 kB 167,178.00 kB -
Temporary Files
Size of temporary files
Key values
- 431.25 MiB Temp Files size Peak
- 2021-09-20 04:31:50 Date
Number of temporary files
Key values
- 3 per second Temp Files Peak
- 2021-09-20 04:31:50 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 20 01 72 10.11 GiB 143.75 MiB 02 96 13.48 GiB 143.75 MiB 03 96 13.48 GiB 143.75 MiB 04 96 13.48 GiB 143.75 MiB 05 96 13.48 GiB 143.75 MiB 06 96 13.48 GiB 143.75 MiB 07 96 13.48 GiB 143.75 MiB 08 96 13.48 GiB 143.75 MiB 09 32 4.49 GiB 143.75 MiB Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 194 27.23 GiB 143.75 MiB 143.75 MiB 143.75 MiB select count(*) from pg_buffercache where isdirty;-
select count(*) from pg_buffercache where isdirty;
Date: 2021-09-20 02:05:40 Duration: 13s Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where isdirty;
Date: 2021-09-20 03:06:11 Duration: 8s859ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where isdirty;
Date: 2021-09-20 02:10:56 Duration: 7s822ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
2 194 27.23 GiB 143.75 MiB 143.75 MiB 143.75 MiB select count(*) from pg_buffercache;-
select count(*) from pg_buffercache;
Date: 2021-09-20 02:05:41 Duration: 11s399ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache;
Date: 2021-09-20 02:10:56 Duration: 7s758ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache;
Date: 2021-09-20 03:06:56 Duration: 7s278ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
3 194 27.23 GiB 143.75 MiB 143.75 MiB 143.75 MiB select count(*) from pg_buffercache where reldatabase is not null;-
select count(*) from pg_buffercache where reldatabase is not null;
Date: 2021-09-20 02:05:41 Duration: 5s256ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where reldatabase is not null;
Date: 2021-09-20 03:06:56 Duration: 4s331ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where reldatabase is not null;
Date: 2021-09-20 03:01:12 Duration: 4s114ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
4 194 27.23 GiB 143.75 MiB 143.75 MiB 143.75 MiB select count(*) from pg_buffercache where not isdirty;-
select count(*) from pg_buffercache where not isdirty;
Date: 2021-09-20 02:05:36 Duration: 11s834ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where not isdirty;
Date: 2021-09-20 03:06:10 Duration: 11s826ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where not isdirty;
Date: 2021-09-20 02:10:56 Duration: 8s58ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
Queries generating the largest temporary files
Rank Size Query 1 143.75 MiB select count(*) from pg_buffercache where not isdirty;[ Date: 2021-09-20 01:16:01 - Database: postgres - User: zabbix - Remote: seedbm19 - Application: psql ]
2 143.75 MiB select count(*) from pg_buffercache where isdirty;[ Date: 2021-09-20 01:16:04 - Database: postgres - User: zabbix - Remote: seedbm19 - Application: psql ]
3 143.75 MiB select count(*) from pg_buffercache;[ Date: 2021-09-20 01:16:05 - Database: postgres - User: zabbix - Remote: seedbm19 - Application: psql ]
4 143.75 MiB select count(*) from pg_buffercache where reldatabase is not null;[ Date: 2021-09-20 01:16:06 - Database: postgres - User: zabbix - Remote: seedbm19 - Application: psql ]
5 143.75 MiB select count(*) from pg_buffercache where not isdirty;[ Date: 2021-09-20 01:16:49 - Database: postgres - User: zabbix - Remote: seedbm19 - Application: psql ]
6 143.75 MiB select count(*) from pg_buffercache;[ Date: 2021-09-20 01:16:49 - Database: postgres - User: zabbix - Remote: seedbm19 - Application: psql ]
7 143.75 MiB select count(*) from pg_buffercache where isdirty;[ Date: 2021-09-20 01:16:49 - Database: postgres - User: zabbix - Remote: seedbm19 - Application: psql ]
8 143.75 MiB select count(*) from pg_buffercache where reldatabase is not null;[ Date: 2021-09-20 01:16:50 - Database: postgres - User: zabbix - Remote: seedbm19 - Application: psql ]
9 143.75 MiB select count(*) from pg_buffercache where not isdirty;[ Date: 2021-09-20 01:20:32 - Database: postgres - User: zabbix - Remote: seedbm19 - Application: psql ]
10 143.75 MiB select count(*) from pg_buffercache where isdirty;[ Date: 2021-09-20 01:20:33 - Database: postgres - User: zabbix - Remote: seedbm19 - Application: psql ]
11 143.75 MiB select count(*) from pg_buffercache;[ Date: 2021-09-20 01:20:34 - Database: postgres - User: zabbix - Remote: seedbm19 - Application: psql ]
12 143.75 MiB select count(*) from pg_buffercache where reldatabase is not null;[ Date: 2021-09-20 01:20:35 - Database: postgres - User: zabbix - Remote: seedbm19 - Application: psql ]
13 143.75 MiB select count(*) from pg_buffercache where not isdirty;[ Date: 2021-09-20 01:21:48 - Database: postgres - User: zabbix - Remote: seedbm19 - Application: psql ]
14 143.75 MiB select count(*) from pg_buffercache where isdirty;[ Date: 2021-09-20 01:21:48 - Database: postgres - User: zabbix - Remote: seedbm19 - Application: psql ]
15 143.75 MiB select count(*) from pg_buffercache;[ Date: 2021-09-20 01:21:50 - Database: postgres - User: zabbix - Remote: seedbm19 - Application: psql ]
16 143.75 MiB select count(*) from pg_buffercache where reldatabase is not null;[ Date: 2021-09-20 01:21:51 - Database: postgres - User: zabbix - Remote: seedbm19 - Application: psql ]
17 143.75 MiB select count(*) from pg_buffercache where isdirty;[ Date: 2021-09-20 01:25:36 - Database: postgres - User: zabbix - Remote: seedbm19 - Application: psql ]
18 143.75 MiB select count(*) from pg_buffercache where not isdirty;[ Date: 2021-09-20 01:25:36 - Database: postgres - User: zabbix - Remote: seedbm19 - Application: psql ]
19 143.75 MiB select count(*) from pg_buffercache;[ Date: 2021-09-20 01:25:38 - Database: postgres - User: zabbix - Remote: seedbm19 - Application: psql ]
20 143.75 MiB select count(*) from pg_buffercache where reldatabase is not null;[ Date: 2021-09-20 01:25:40 - Database: postgres - User: zabbix - Remote: seedbm19 - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 20 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 9,320 Total read queries
- 1,537 Total write queries
Queries by database
Key values
- augeeducacional Main database
- 8,350 Requests
- 5h40m13s (augeeducacional)
- Main time consuming database
Queries by user
Key values
- augeeducacional Main user
- 6,439 Requests
User Request type Count Duration augeeducacional Total 6,439 1h24m42s delete 25 16s350ms insert 607 3m39s select 5,601 1h19m57s update 206 48s598ms pgagent Total 51 3m1s others 48 48s335ms select 2 2m13s update 1 332ms postgres Total 2,412 3h2m9s copy to 695 2h58m55s cte 3 767ms select 1,714 3m13s sergio_veiga Total 21 2m45s select 21 2m45s zabbix Total 1,982 1h37m47s select 1,982 1h37m47s Duration by user
Key values
- 3h2m9s (postgres) Main time consuming user
User Request type Count Duration augeeducacional Total 6,439 1h24m42s delete 25 16s350ms insert 607 3m39s select 5,601 1h19m57s update 206 48s598ms pgagent Total 51 3m1s others 48 48s335ms select 2 2m13s update 1 332ms postgres Total 2,412 3h2m9s copy to 695 2h58m55s cte 3 767ms select 1,714 3m13s sergio_veiga Total 21 2m45s select 21 2m45s zabbix Total 1,982 1h37m47s select 1,982 1h37m47s Queries by host
Key values
- seeweb85 Main host
- 6,438 Requests
- 4h13m47s ([local])
- Main time consuming host
Host Request type Count Duration 10.81.1.92 Total 21 2m45s select 21 2m45s [local] Total 3,596 4h13m47s copy to 695 2h58m55s cte 3 767ms select 2,898 1h14m51s localhost Total 51 3m1s others 48 48s335ms select 2 2m13s update 1 332ms seeapp38 Total 1 287ms select 1 287ms seedbm19 Total 798 26m9s select 798 26m9s seeweb85 Total 6,438 1h24m42s delete 25 16s350ms insert 607 3m39s select 5,600 1h19m57s update 206 48s598ms Queries by application
Key values
- augeeducacional - principal Main application
- 5,532 Requests
- 2h58m58s (pg_dump)
- Main time consuming application
Application Request type Count Duration [unknown] Total 1,757 6m13s cte 2 586ms others 48 48s335ms select 1,706 5m23s update 1 332ms augeeducacional - fila Total 906 10m5s delete 6 720ms insert 401 2m17s select 395 7m21s update 104 26s14ms augeeducacional - principal Total 5,532 1h14m36s delete 19 15s630ms insert 206 1m22s select 5,205 1h12m35s update 102 22s583ms pgAdmin III - Browser Total 14 47s422ms select 14 47s422ms pgAdmin III - Query Tool Total 7 1m57s select 7 1m57s pg_dump Total 706 2h58m58s copy to 695 2h58m55s cte 1 180ms select 10 3s18ms prematricula - principal Total 1 287ms select 1 287ms psql Total 1,982 1h37m47s select 1,982 1h37m47s Number of cancelled queries
Key values
- 2 per second Cancelled query Peak
- 2021-09-20 09:00:41 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 6,109 100-500ms duration
Slowest individual queries
Rank Duration Query 1 8m42s COPY aluno_lancamento.nota_aluno_atividade_legado (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, id_atividade_avaliativa, nota, nota_recuperacao, flg_nao_compareceu, flg_nao_compareceu_rp) TO stdout;[ Date: 2021-09-20 04:07:08 - Database: augeeducacional - User: postgres - Remote: [local] - Application: pg_dump ]
2 7m42s COPY public.planejamento_bimestral (id_turma, id_serie, id_disciplina, id_nota_periodo_aluno, aulas_previstas, aulas_dadas, justificativa, objetivo, conteudo_eixo_tematico, procedimento_metodologico, procedimento_avaliativo, flg_usa_calendario_oficial, flg_aprovacao_professor, flg_aprovacao_diretor, flg_aprovacao_secretario, habilidades_desenvolvidas, itinerario_formativo, data_inclusao, data_atualizacao, data_alteracao_planejamento, id_planejamento_unificado, uuid_pacote, bncc_competencia_especifica, bncc_unidade_tematica, bncc_objeto_conhecimento, bncc_conteudo, bncc_habilidade, bncc_procedimento_metodologico, bncc_procedimento_avaliativo) TO stdout;[ Date: 2021-09-20 05:45:25 - Database: augeeducacional - User: postgres - Remote: [local] - Application: pg_dump ]
3 7m30s COPY aluno_lancamento.falta_aluno_disciplina_diario_2020 (id_falta_aluno_disciplina_diario, id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, data, id_horario_turma, flg_justificada, id_motivo_falta_justificada, descricao_motivo_falta_justificada) TO stdout;[ Date: 2021-09-20 03:31:09 - Database: augeeducacional - User: postgres - Remote: [local] - Application: pg_dump ]
4 6m54s select id_fila_trabalho, nome_fila, id_situacao_trabalho, (((regexp_replace(parametros::text, '\\u0000', '', 'g'))::json) ->> 'idUsuario')::integer as id_usuario from fila_trabalho.fila_trabalho where id_situacao_trabalho in ('1', '2') order by id_fila_trabalho;[ Date: 2021-09-20 08:59:39 - Database: augeeducacional - User: augeeducacional - Remote: seeweb85 - Application: augeeducacional - principal - Bind query: yes ]
5 5m42s COPY public.conteudo_curricular_aula (id_conteudo_curricular_aula, id_situacao_didatica_aula, id_conteudo_curricular_componente, id_conteudo_analise_linguistica, id_situacao_didatica, descricao_situacao_didatica, conteudo_trab_situacao_didatica, data_realizacao, justificativa, complementacao_conteudo) TO stdout;[ Date: 2021-09-20 05:30:46 - Database: augeeducacional - User: postgres - Remote: [local] - Application: pg_dump ]
6 5m27s COPY indicador.consulta_dia (data, sql, media, min, max, execucoes) TO stdout;[ Date: 2021-09-20 05:02:18 - Database: augeeducacional - User: postgres - Remote: [local] - Application: pg_dump ]
7 4m56s COPY public.registro_falta_disciplina_diario (id_turma, id_disciplina, data_inclusao, data_atualizacao, data_referencia, flg_concluido, flg_aplicativo_movel, data_ref_sincronizacao, id_usuario, uuid_pacote) TO stdout;[ Date: 2021-09-20 05:51:28 - Database: augeeducacional - User: postgres - Remote: [local] - Application: pg_dump ]
8 4m35s COPY public.situacao_didatica_aula (id_situacao_didatica_aula, id_turma, id_serie, id_componente_curricular, data, id_horario_turma, numero_aula, data_atualizacao, data_criacao, uuid_pacote) TO stdout;[ Date: 2021-09-20 05:58:33 - Database: augeeducacional - User: postgres - Remote: [local] - Application: pg_dump ]
9 4m8s COPY aluno_lancamento.falta_aluno_disciplina_2017 (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, falta_justificada, falta_nao_justificada, qtd_faltas) TO stdout;[ Date: 2021-09-20 03:08:43 - Database: augeeducacional - User: postgres - Remote: [local] - Application: pg_dump ]
10 4m5s COPY fila_trabalho.fila_trabalho_2020_12 (id_fila_trabalho, nome_fila, descricao_metodo, descricao_parametros, prioridade, espera_maxima, recuperavel, nome_metodo, parametros, tipos_parametros, entrada_fila, inicio_execucao, fim_execucao, id_situacao_trabalho, id_recuperacao, resultado, atributos, tipos_atributos, id_instituicao, usuarios) TO stdout;[ Date: 2021-09-20 04:44:12 - Database: augeeducacional - User: postgres - Remote: [local] - Application: pg_dump ]
11 4m4s COPY aluno_lancamento.falta_aluno_disciplina_diario_2019 (id_falta_aluno_disciplina_diario, id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, data, id_horario_turma, flg_justificada, id_motivo_falta_justificada, descricao_motivo_falta_justificada) TO stdout;[ Date: 2021-09-20 03:23:39 - Database: augeeducacional - User: postgres - Remote: [local] - Application: pg_dump ]
12 3m34s COPY aluno_lancamento.falta_aluno_disciplina_2016 (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, falta_justificada, falta_nao_justificada, qtd_faltas) TO stdout;[ Date: 2021-09-20 03:04:34 - Database: augeeducacional - User: postgres - Remote: [local] - Application: pg_dump ]
13 3m32s COPY aluno_lancamento.nota_aluno_legado (nota, id_disciplina, id_aluno_matricula, id_turma, id_nota_periodo_aluno, id_conceito_avaliacao, flg_nao_compareceu, id_resultado_final_disciplina, nota_conselho, nota_continuidade_ciclo) TO stdout;[ Date: 2021-09-20 04:10:41 - Database: augeeducacional - User: postgres - Remote: [local] - Application: pg_dump ]
14 3m25s COPY aluno_lancamento.falta_aluno_disciplina_diario_2021 (id_falta_aluno_disciplina_diario, id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, data, id_horario_turma, flg_justificada, id_motivo_falta_justificada, descricao_motivo_falta_justificada) TO stdout;[ Date: 2021-09-20 03:34:34 - Database: augeeducacional - User: postgres - Remote: [local] - Application: pg_dump ]
15 2m53s COPY aluno_lancamento.nota_aluno_atividade_2016 (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, id_atividade_avaliativa, nota, nota_recuperacao, flg_nao_compareceu, flg_nao_compareceu_rp) TO stdout;[ Date: 2021-09-20 03:47:10 - Database: augeeducacional - User: postgres - Remote: [local] - Application: pg_dump ]
16 2m46s COPY aluno_lancamento.falta_aluno_disciplina_diario_legado (id_falta_aluno_disciplina_diario, id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, data, id_horario_turma, flg_justificada, id_motivo_falta_justificada, descricao_motivo_falta_justificada) TO stdout;[ Date: 2021-09-20 03:37:28 - Database: augeeducacional - User: postgres - Remote: [local] - Application: pg_dump ]
17 2m41s COPY aluno_lancamento.nota_aluno_atividade_2017 (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, id_atividade_avaliativa, nota, nota_recuperacao, flg_nao_compareceu, flg_nao_compareceu_rp) TO stdout;[ Date: 2021-09-20 03:49:51 - Database: augeeducacional - User: postgres - Remote: [local] - Application: pg_dump ]
18 2m36s COPY aluno_lancamento.nota_aluno_atividade_2019 (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, id_atividade_avaliativa, nota, nota_recuperacao, flg_nao_compareceu, flg_nao_compareceu_rp) TO stdout;[ Date: 2021-09-20 03:55:03 - Database: augeeducacional - User: postgres - Remote: [local] - Application: pg_dump ]
19 2m34s COPY aluno_lancamento.nota_aluno_atividade_2018 (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, id_atividade_avaliativa, nota, nota_recuperacao, flg_nao_compareceu, flg_nao_compareceu_rp) TO stdout;[ Date: 2021-09-20 03:52:26 - Database: augeeducacional - User: postgres - Remote: [local] - Application: pg_dump ]
20 2m20s COPY aluno_lancamento.falta_aluno_disciplina_legado (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, falta_justificada, falta_nao_justificada, qtd_faltas) TO stdout;[ Date: 2021-09-20 03:39:48 - Database: augeeducacional - User: postgres - Remote: [local] - Application: pg_dump ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h11m38s 1,184 2s847ms 27s15ms 3s630ms select count(*) as fila from fila_trabalho.fila_trabalho where id_situacao_trabalho in (...) and entrada_fila > (now() - interval ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 20 01 108 6m7s 3s401ms 02 147 8m47s 3s590ms 03 148 12m2s 4s878ms 04 147 8m25s 3s438ms 05 146 8m8s 3s347ms 06 148 8m9s 3s306ms 07 145 8m13s 3s400ms 08 146 8m50s 3s636ms 09 49 2m53s 3s537ms [ User: zabbix - Total duration: 1h11m38s - Times executed: 1184 ]
[ Application: psql - Total duration: 1h11m38s - Times executed: 1184 ]
-
SELECT COUNT(*) as fila FROM fila_trabalho.fila_trabalho WHERE id_situacao_trabalho IN (1) and entrada_fila > (NOW() - interval '60 day');
Date: 2021-09-20 08:51:30 Duration: 27s15ms Database: augeeducacional User: zabbix Remote: [local] Application: psql
-
SELECT COUNT(*) as fila FROM fila_trabalho.fila_trabalho WHERE id_situacao_trabalho IN (1) and entrada_fila > (NOW() - interval '60 day');
Date: 2021-09-20 02:05:17 Duration: 14s68ms Database: augeeducacional User: zabbix Remote: [local] Application: psql
-
SELECT COUNT(*) as fila FROM fila_trabalho.fila_trabalho WHERE id_situacao_trabalho IN (1) and entrada_fila > (NOW() - interval '60 day');
Date: 2021-09-20 03:03:44 Duration: 12s188ms Database: augeeducacional User: zabbix Remote: [local] Application: psql
2 10m19s 283 1s785ms 3s367ms 2s188ms select ts.id_turma, ts.id_modelo_avaliacao_desc, ts.id_modelo_acompanhamento_atitudinal, ts.id_modelo_observacao_estudante, null as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma on turma.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = turma.id_unidade_funcional where uf.id_instituicao = ? and (ts.id_modelo_avaliacao_desc is not null or ts.id_modelo_acompanhamento_atitudinal is not null or ts.id_modelo_observacao_estudante is not null) and turma.flg_organizada is true and turma.id_turma in ( select tp.id_turma from turma_professor tp where tp.id_turma = turma.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = ?) union all select ts.id_turma, null as id_modelo_avaliacao_desc, null as id_modelo_observacao_estudante, null as id_modelo_acompanhamento_atitudinal, tsm.id_modelo_avaliacao_desc as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma t on t.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = t.id_unidade_funcional inner join turma_serie_modelo_avaliacao_desc tsm on tsm.id_serie = ts.id_serie and tsm.id_turma = ts.id_turma and tsm.id_tipo_modelo_avaliacao_desc = ? inner join modelo_avaliacao_desc modelo_ficha_acompanhamento on modelo_ficha_acompanhamento.id_modelo_avaliacao_desc = tsm.id_modelo_avaliacao_desc where uf.id_instituicao = ? and t.flg_organizada is true and exists ( select null from turma_professor tp inner join componente_curricular on componente_curricular.id_componente_curricular = tp.id_componente_curricular where tp.id_turma = t.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = ? and componente_curricular.id_disciplina = modelo_ficha_acompanhamento.id_disciplina);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 20 09 283 10m19s 2s188ms [ User: augeeducacional - Total duration: 10m19s - Times executed: 283 ]
[ Application: augeeducacional - principal - Total duration: 10m19s - Times executed: 283 ]
-
select ts.id_turma, ts.id_modelo_avaliacao_desc, ts.id_modelo_acompanhamento_atitudinal, ts.id_modelo_observacao_estudante, null as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma on turma.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = turma.id_unidade_funcional where uf.id_instituicao = '60' and (ts.id_modelo_avaliacao_desc is not null or ts.id_modelo_acompanhamento_atitudinal is not null or ts.id_modelo_observacao_estudante is not null) and turma.flg_organizada is true and turma.id_turma in ( select tp.id_turma from turma_professor tp where tp.id_turma = turma.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = '2682309') union all select ts.id_turma, null as id_modelo_avaliacao_desc, null as id_modelo_observacao_estudante, null as id_modelo_acompanhamento_atitudinal, tsm.id_modelo_avaliacao_desc as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma t on t.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = t.id_unidade_funcional inner join turma_serie_modelo_avaliacao_desc tsm on tsm.id_serie = ts.id_serie and tsm.id_turma = ts.id_turma and tsm.id_tipo_modelo_avaliacao_desc = 4 inner join modelo_avaliacao_desc modelo_ficha_acompanhamento on modelo_ficha_acompanhamento.id_modelo_avaliacao_desc = tsm.id_modelo_avaliacao_desc where uf.id_instituicao = '60' and t.flg_organizada is true and exists ( select null from turma_professor tp inner join componente_curricular on componente_curricular.id_componente_curricular = tp.id_componente_curricular where tp.id_turma = t.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = '2682309' and componente_curricular.id_disciplina = modelo_ficha_acompanhamento.id_disciplina);
Date: 2021-09-20 09:05:34 Duration: 3s367ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select ts.id_turma, ts.id_modelo_avaliacao_desc, ts.id_modelo_acompanhamento_atitudinal, ts.id_modelo_observacao_estudante, null as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma on turma.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = turma.id_unidade_funcional where uf.id_instituicao = '60' and (ts.id_modelo_avaliacao_desc is not null or ts.id_modelo_acompanhamento_atitudinal is not null or ts.id_modelo_observacao_estudante is not null) and turma.flg_organizada is true and turma.id_turma in ( select tp.id_turma from turma_professor tp where tp.id_turma = turma.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = '7797887') union all select ts.id_turma, null as id_modelo_avaliacao_desc, null as id_modelo_observacao_estudante, null as id_modelo_acompanhamento_atitudinal, tsm.id_modelo_avaliacao_desc as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma t on t.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = t.id_unidade_funcional inner join turma_serie_modelo_avaliacao_desc tsm on tsm.id_serie = ts.id_serie and tsm.id_turma = ts.id_turma and tsm.id_tipo_modelo_avaliacao_desc = 4 inner join modelo_avaliacao_desc modelo_ficha_acompanhamento on modelo_ficha_acompanhamento.id_modelo_avaliacao_desc = tsm.id_modelo_avaliacao_desc where uf.id_instituicao = '60' and t.flg_organizada is true and exists ( select null from turma_professor tp inner join componente_curricular on componente_curricular.id_componente_curricular = tp.id_componente_curricular where tp.id_turma = t.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = '7797887' and componente_curricular.id_disciplina = modelo_ficha_acompanhamento.id_disciplina);
Date: 2021-09-20 09:04:12 Duration: 2s940ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select ts.id_turma, ts.id_modelo_avaliacao_desc, ts.id_modelo_acompanhamento_atitudinal, ts.id_modelo_observacao_estudante, null as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma on turma.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = turma.id_unidade_funcional where uf.id_instituicao = '60' and (ts.id_modelo_avaliacao_desc is not null or ts.id_modelo_acompanhamento_atitudinal is not null or ts.id_modelo_observacao_estudante is not null) and turma.flg_organizada is true and turma.id_turma in ( select tp.id_turma from turma_professor tp where tp.id_turma = turma.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = '7169818') union all select ts.id_turma, null as id_modelo_avaliacao_desc, null as id_modelo_observacao_estudante, null as id_modelo_acompanhamento_atitudinal, tsm.id_modelo_avaliacao_desc as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma t on t.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = t.id_unidade_funcional inner join turma_serie_modelo_avaliacao_desc tsm on tsm.id_serie = ts.id_serie and tsm.id_turma = ts.id_turma and tsm.id_tipo_modelo_avaliacao_desc = 4 inner join modelo_avaliacao_desc modelo_ficha_acompanhamento on modelo_ficha_acompanhamento.id_modelo_avaliacao_desc = tsm.id_modelo_avaliacao_desc where uf.id_instituicao = '60' and t.flg_organizada is true and exists ( select null from turma_professor tp inner join componente_curricular on componente_curricular.id_componente_curricular = tp.id_componente_curricular where tp.id_turma = t.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = '7169818' and componente_curricular.id_disciplina = modelo_ficha_acompanhamento.id_disciplina);
Date: 2021-09-20 09:01:31 Duration: 2s837ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
3 8m42s 1 8m42s 8m42s 8m42s copy aluno_lancamento.nota_aluno_atividade_legado (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, id_atividade_avaliativa, nota, nota_recuperacao, flg_nao_compareceu, flg_nao_compareceu_rp) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 20 04 1 8m42s 8m42s [ User: postgres - Total duration: 8m42s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 8m42s - Times executed: 1 ]
-
COPY aluno_lancamento.nota_aluno_atividade_legado (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, id_atividade_avaliativa, nota, nota_recuperacao, flg_nao_compareceu, flg_nao_compareceu_rp) TO stdout;
Date: 2021-09-20 04:07:08 Duration: 8m42s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
4 7m42s 1 7m42s 7m42s 7m42s copy public.planejamento_bimestral (id_turma, id_serie, id_disciplina, id_nota_periodo_aluno, aulas_previstas, aulas_dadas, justificativa, objetivo, conteudo_eixo_tematico, procedimento_metodologico, procedimento_avaliativo, flg_usa_calendario_oficial, flg_aprovacao_professor, flg_aprovacao_diretor, flg_aprovacao_secretario, habilidades_desenvolvidas, itinerario_formativo, data_inclusao, data_atualizacao, data_alteracao_planejamento, id_planejamento_unificado, uuid_pacote, bncc_competencia_especifica, bncc_unidade_tematica, bncc_objeto_conhecimento, bncc_conteudo, bncc_habilidade, bncc_procedimento_metodologico, bncc_procedimento_avaliativo) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 20 05 1 7m42s 7m42s [ User: postgres - Total duration: 7m42s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 7m42s - Times executed: 1 ]
-
COPY public.planejamento_bimestral (id_turma, id_serie, id_disciplina, id_nota_periodo_aluno, aulas_previstas, aulas_dadas, justificativa, objetivo, conteudo_eixo_tematico, procedimento_metodologico, procedimento_avaliativo, flg_usa_calendario_oficial, flg_aprovacao_professor, flg_aprovacao_diretor, flg_aprovacao_secretario, habilidades_desenvolvidas, itinerario_formativo, data_inclusao, data_atualizacao, data_alteracao_planejamento, id_planejamento_unificado, uuid_pacote, bncc_competencia_especifica, bncc_unidade_tematica, bncc_objeto_conhecimento, bncc_conteudo, bncc_habilidade, bncc_procedimento_metodologico, bncc_procedimento_avaliativo) TO stdout;
Date: 2021-09-20 05:45:25 Duration: 7m42s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
5 7m32s 194 1s526ms 11s834ms 2s330ms select count(*) from pg_buffercache where not isdirty;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 20 01 18 36s460ms 2s25ms 02 24 1m3s 2s632ms 03 24 1m42s 4s289ms 04 24 46s719ms 1s946ms 05 24 47s339ms 1s972ms 06 24 45s991ms 1s916ms 07 24 47s446ms 1s976ms 08 24 46s872ms 1s953ms 09 8 15s64ms 1s883ms [ User: zabbix - Total duration: 7m32s - Times executed: 194 ]
[ Application: psql - Total duration: 7m32s - Times executed: 194 ]
-
select count(*) from pg_buffercache where not isdirty;
Date: 2021-09-20 02:05:36 Duration: 11s834ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where not isdirty;
Date: 2021-09-20 03:06:10 Duration: 11s826ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where not isdirty;
Date: 2021-09-20 02:10:56 Duration: 8s58ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
6 7m30s 1 7m30s 7m30s 7m30s copy aluno_lancamento.falta_aluno_disciplina_diario_2020 (id_falta_aluno_disciplina_diario, id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, data, id_horario_turma, flg_justificada, id_motivo_falta_justificada, descricao_motivo_falta_justificada) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 20 03 1 7m30s 7m30s [ User: postgres - Total duration: 7m30s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 7m30s - Times executed: 1 ]
-
COPY aluno_lancamento.falta_aluno_disciplina_diario_2020 (id_falta_aluno_disciplina_diario, id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, data, id_horario_turma, flg_justificada, id_motivo_falta_justificada, descricao_motivo_falta_justificada) TO stdout;
Date: 2021-09-20 03:31:09 Duration: 7m30s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
7 6m54s 1 6m54s 6m54s 6m54s select id_fila_trabalho, nome_fila, id_situacao_trabalho, (((regexp_replace(parametros::text, ?, ?, ?))::json) ->> ?)::integer as id_usuario from fila_trabalho.fila_trabalho where id_situacao_trabalho in (...) order by id_fila_trabalho;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 20 08 1 6m54s 6m54s [ User: augeeducacional - Total duration: 6m54s - Times executed: 1 ]
[ Application: augeeducacional - principal - Total duration: 6m54s - Times executed: 1 ]
-
select id_fila_trabalho, nome_fila, id_situacao_trabalho, (((regexp_replace(parametros::text, '\\u0000', '', 'g'))::json) ->> 'idUsuario')::integer as id_usuario from fila_trabalho.fila_trabalho where id_situacao_trabalho in ('1', '2') order by id_fila_trabalho;
Date: 2021-09-20 08:59:39 Duration: 6m54s Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
8 6m39s 194 1s342ms 13s 2s57ms select count(*) from pg_buffercache where isdirty;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 20 01 18 30s381ms 1s687ms 02 24 59s670ms 2s486ms 03 24 1m34s 3s918ms 04 24 41s633ms 1s734ms 05 24 40s353ms 1s681ms 06 24 39s265ms 1s636ms 07 24 40s82ms 1s670ms 08 24 40s19ms 1s667ms 09 8 13s666ms 1s708ms [ User: zabbix - Total duration: 6m39s - Times executed: 194 ]
[ Application: psql - Total duration: 6m39s - Times executed: 194 ]
-
select count(*) from pg_buffercache where isdirty;
Date: 2021-09-20 02:05:40 Duration: 13s Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where isdirty;
Date: 2021-09-20 03:06:11 Duration: 8s859ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where isdirty;
Date: 2021-09-20 02:10:56 Duration: 7s822ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
9 6m3s 194 1s294ms 11s399ms 1s875ms select count(*) from pg_buffercache;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 20 01 18 29s301ms 1s627ms 02 24 56s941ms 2s372ms 03 24 1m15s 3s137ms 04 24 37s370ms 1s557ms 05 24 38s196ms 1s591ms 06 24 38s473ms 1s603ms 07 24 38s980ms 1s624ms 08 24 37s93ms 1s545ms 09 8 12s153ms 1s519ms [ User: zabbix - Total duration: 6m3s - Times executed: 194 ]
[ Application: psql - Total duration: 6m3s - Times executed: 194 ]
-
select count(*) from pg_buffercache;
Date: 2021-09-20 02:05:41 Duration: 11s399ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache;
Date: 2021-09-20 02:10:56 Duration: 7s758ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache;
Date: 2021-09-20 03:06:56 Duration: 7s278ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
10 5m46s 194 1s455ms 5s256ms 1s784ms select count(*) from pg_buffercache where reldatabase is not null;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 20 01 18 31s130ms 1s729ms 02 24 45s376ms 1s890ms 03 24 49s889ms 2s78ms 04 24 40s554ms 1s689ms 05 24 42s813ms 1s783ms 06 24 40s976ms 1s707ms 07 24 41s598ms 1s733ms 08 24 40s439ms 1s684ms 09 8 13s488ms 1s686ms [ User: zabbix - Total duration: 5m46s - Times executed: 194 ]
[ Application: psql - Total duration: 5m46s - Times executed: 194 ]
-
select count(*) from pg_buffercache where reldatabase is not null;
Date: 2021-09-20 02:05:41 Duration: 5s256ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where reldatabase is not null;
Date: 2021-09-20 03:06:56 Duration: 4s331ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where reldatabase is not null;
Date: 2021-09-20 03:01:12 Duration: 4s114ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
11 5m42s 1 5m42s 5m42s 5m42s copy public.conteudo_curricular_aula (id_conteudo_curricular_aula, id_situacao_didatica_aula, id_conteudo_curricular_componente, id_conteudo_analise_linguistica, id_situacao_didatica, descricao_situacao_didatica, conteudo_trab_situacao_didatica, data_realizacao, justificativa, complementacao_conteudo) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 20 05 1 5m42s 5m42s [ User: postgres - Total duration: 5m42s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 5m42s - Times executed: 1 ]
-
COPY public.conteudo_curricular_aula (id_conteudo_curricular_aula, id_situacao_didatica_aula, id_conteudo_curricular_componente, id_conteudo_analise_linguistica, id_situacao_didatica, descricao_situacao_didatica, conteudo_trab_situacao_didatica, data_realizacao, justificativa, complementacao_conteudo) TO stdout;
Date: 2021-09-20 05:30:46 Duration: 5m42s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
12 5m27s 1 5m27s 5m27s 5m27s copy indicador.consulta_dia (data, sql, media, min, max, execucoes) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 20 05 1 5m27s 5m27s [ User: postgres - Total duration: 5m27s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 5m27s - Times executed: 1 ]
-
COPY indicador.consulta_dia (data, sql, media, min, max, execucoes) TO stdout;
Date: 2021-09-20 05:02:18 Duration: 5m27s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
13 4m56s 1 4m56s 4m56s 4m56s copy public.registro_falta_disciplina_diario (id_turma, id_disciplina, data_inclusao, data_atualizacao, data_referencia, flg_concluido, flg_aplicativo_movel, data_ref_sincronizacao, id_usuario, uuid_pacote) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 20 05 1 4m56s 4m56s [ User: postgres - Total duration: 4m56s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 4m56s - Times executed: 1 ]
-
COPY public.registro_falta_disciplina_diario (id_turma, id_disciplina, data_inclusao, data_atualizacao, data_referencia, flg_concluido, flg_aplicativo_movel, data_ref_sincronizacao, id_usuario, uuid_pacote) TO stdout;
Date: 2021-09-20 05:51:28 Duration: 4m56s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
14 4m35s 1 4m35s 4m35s 4m35s copy public.situacao_didatica_aula (id_situacao_didatica_aula, id_turma, id_serie, id_componente_curricular, data, id_horario_turma, numero_aula, data_atualizacao, data_criacao, uuid_pacote) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 20 05 1 4m35s 4m35s [ User: postgres - Total duration: 4m35s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 4m35s - Times executed: 1 ]
-
COPY public.situacao_didatica_aula (id_situacao_didatica_aula, id_turma, id_serie, id_componente_curricular, data, id_horario_turma, numero_aula, data_atualizacao, data_criacao, uuid_pacote) TO stdout;
Date: 2021-09-20 05:58:33 Duration: 4m35s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
15 4m8s 1 4m8s 4m8s 4m8s copy aluno_lancamento.falta_aluno_disciplina_2017 (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, falta_justificada, falta_nao_justificada, qtd_faltas) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 20 03 1 4m8s 4m8s [ User: postgres - Total duration: 4m8s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 4m8s - Times executed: 1 ]
-
COPY aluno_lancamento.falta_aluno_disciplina_2017 (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, falta_justificada, falta_nao_justificada, qtd_faltas) TO stdout;
Date: 2021-09-20 03:08:43 Duration: 4m8s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
16 4m5s 1 4m5s 4m5s 4m5s copy fila_trabalho.fila_trabalho_2020_12 (id_fila_trabalho, nome_fila, descricao_metodo, descricao_parametros, prioridade, espera_maxima, recuperavel, nome_metodo, parametros, tipos_parametros, entrada_fila, inicio_execucao, fim_execucao, id_situacao_trabalho, id_recuperacao, resultado, atributos, tipos_atributos, id_instituicao, usuarios) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 20 04 1 4m5s 4m5s [ User: postgres - Total duration: 4m5s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 4m5s - Times executed: 1 ]
-
COPY fila_trabalho.fila_trabalho_2020_12 (id_fila_trabalho, nome_fila, descricao_metodo, descricao_parametros, prioridade, espera_maxima, recuperavel, nome_metodo, parametros, tipos_parametros, entrada_fila, inicio_execucao, fim_execucao, id_situacao_trabalho, id_recuperacao, resultado, atributos, tipos_atributos, id_instituicao, usuarios) TO stdout;
Date: 2021-09-20 04:44:12 Duration: 4m5s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
17 4m4s 1 4m4s 4m4s 4m4s copy aluno_lancamento.falta_aluno_disciplina_diario_2019 (id_falta_aluno_disciplina_diario, id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, data, id_horario_turma, flg_justificada, id_motivo_falta_justificada, descricao_motivo_falta_justificada) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 20 03 1 4m4s 4m4s [ User: postgres - Total duration: 4m4s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 4m4s - Times executed: 1 ]
-
COPY aluno_lancamento.falta_aluno_disciplina_diario_2019 (id_falta_aluno_disciplina_diario, id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, data, id_horario_turma, flg_justificada, id_motivo_falta_justificada, descricao_motivo_falta_justificada) TO stdout;
Date: 2021-09-20 03:23:39 Duration: 4m4s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
18 3m34s 1 3m34s 3m34s 3m34s copy aluno_lancamento.falta_aluno_disciplina_2016 (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, falta_justificada, falta_nao_justificada, qtd_faltas) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 20 03 1 3m34s 3m34s [ User: postgres - Total duration: 3m34s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 3m34s - Times executed: 1 ]
-
COPY aluno_lancamento.falta_aluno_disciplina_2016 (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, falta_justificada, falta_nao_justificada, qtd_faltas) TO stdout;
Date: 2021-09-20 03:04:34 Duration: 3m34s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
19 3m32s 1 3m32s 3m32s 3m32s copy aluno_lancamento.nota_aluno_legado (nota, id_disciplina, id_aluno_matricula, id_turma, id_nota_periodo_aluno, id_conceito_avaliacao, flg_nao_compareceu, id_resultado_final_disciplina, nota_conselho, nota_continuidade_ciclo) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 20 04 1 3m32s 3m32s [ User: postgres - Total duration: 3m32s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 3m32s - Times executed: 1 ]
-
COPY aluno_lancamento.nota_aluno_legado (nota, id_disciplina, id_aluno_matricula, id_turma, id_nota_periodo_aluno, id_conceito_avaliacao, flg_nao_compareceu, id_resultado_final_disciplina, nota_conselho, nota_continuidade_ciclo) TO stdout;
Date: 2021-09-20 04:10:41 Duration: 3m32s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
20 3m32s 126 219ms 8s292ms 1s686ms select json_agg(r.*)::text as r from ( select sda.id_situacao_didatica_aula, sda.id_turma, sda.id_serie, sda.id_componente_curricular, sda.data, sda.id_horario_turma, sda.numero_aula, sda.data_atualizacao from situacao_didatica_aula sda inner join componente_curricular on componente_curricular.id_componente_curricular = sda.id_componente_curricular where sda.id_turma in (...) and exists ( select null from turma_professor tp where tp.id_cidadao = ? and tp.id_turma = sda.id_turma and componente_curricular.id_componente_curricular = tp.id_componente_curricular) and exists ( select null from registro_lancamento_conteudo_diario registro_lancamento where registro_lancamento.id_turma = sda.id_turma and registro_lancamento.id_componente_curricular = sda.id_componente_curricular and registro_lancamento.data_referencia = sda.data and registro_lancamento.data_atualizacao > ?)) r;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 20 09 126 3m32s 1s686ms [ User: augeeducacional - Total duration: 3m32s - Times executed: 126 ]
[ Application: augeeducacional - principal - Total duration: 3m32s - Times executed: 126 ]
-
select json_agg(r.*)::text as r from ( select sda.id_situacao_didatica_aula, sda.id_turma, sda.id_serie, sda.id_componente_curricular, sda.data, sda.id_horario_turma, sda.numero_aula, sda.data_atualizacao from situacao_didatica_aula sda inner join componente_curricular on componente_curricular.id_componente_curricular = sda.id_componente_curricular where sda.id_turma in ('210007052', '210007053', '210007054', '210007055', '210007056', '210007057', '210007058', '210007059', '210007060', '210007061', '210007062', '210007617', '210007618', '210007619', '210007620', '210007621', '210007622', '210007623', '210007624', '210007626', '210007628', '210007629', '210007630', '210008977') and exists ( select null from turma_professor tp where tp.id_cidadao = '6369256' and tp.id_turma = sda.id_turma and componente_curricular.id_componente_curricular = tp.id_componente_curricular) and exists ( select null from registro_lancamento_conteudo_diario registro_lancamento where registro_lancamento.id_turma = sda.id_turma and registro_lancamento.id_componente_curricular = sda.id_componente_curricular and registro_lancamento.data_referencia = sda.data and registro_lancamento.data_atualizacao > '2021-09-18 15:45:45.604')) r;
Date: 2021-09-20 09:17:06 Duration: 8s292ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select json_agg(r.*)::text as r from ( select sda.id_situacao_didatica_aula, sda.id_turma, sda.id_serie, sda.id_componente_curricular, sda.data, sda.id_horario_turma, sda.numero_aula, sda.data_atualizacao from situacao_didatica_aula sda inner join componente_curricular on componente_curricular.id_componente_curricular = sda.id_componente_curricular where sda.id_turma in ('210000492', '210000493', '210000494', '210000495', '210000496', '210000497', '210000498', '210001210') and exists ( select null from turma_professor tp where tp.id_cidadao = '5006929' and tp.id_turma = sda.id_turma and componente_curricular.id_componente_curricular = tp.id_componente_curricular) and exists ( select null from registro_lancamento_conteudo_diario registro_lancamento where registro_lancamento.id_turma = sda.id_turma and registro_lancamento.id_componente_curricular = sda.id_componente_curricular and registro_lancamento.data_referencia = sda.data and registro_lancamento.data_atualizacao > '2021-09-17 15:42:44.552')) r;
Date: 2021-09-20 09:18:01 Duration: 4s581ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select json_agg(r.*)::text as r from ( select sda.id_situacao_didatica_aula, sda.id_turma, sda.id_serie, sda.id_componente_curricular, sda.data, sda.id_horario_turma, sda.numero_aula, sda.data_atualizacao from situacao_didatica_aula sda inner join componente_curricular on componente_curricular.id_componente_curricular = sda.id_componente_curricular where sda.id_turma in ('210006933', '210006934', '210006935', '210006936', '210006937', '210006938', '210006939', '210006940', '210006942', '210006943', '210006945', '210006946', '210008001', '210008108', '210040250', '210040252', '210040253', '210041414') and exists ( select null from turma_professor tp where tp.id_cidadao = '2638887' and tp.id_turma = sda.id_turma and componente_curricular.id_componente_curricular = tp.id_componente_curricular) and exists ( select null from registro_lancamento_conteudo_diario registro_lancamento where registro_lancamento.id_turma = sda.id_turma and registro_lancamento.id_componente_curricular = sda.id_componente_curricular and registro_lancamento.data_referencia = sda.data and registro_lancamento.data_atualizacao > '2021-09-18 20:07:32.05')) r;
Date: 2021-09-20 09:07:23 Duration: 4s291ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,703 3m10s 100ms 516ms 111ms select extract(epoch from now()) as timestamp, sum(pg_stat_get_db_xact_commit(oid) + pg_stat_get_db_xact_rollback(oid))::bigint as no_xact, sum(pg_database_size(datname)) as total_size, max(length(datname)) as max_length from pg_database;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 20 07 48 6s114ms 127ms 08 1,262 2m20s 111ms 09 393 43s560ms 110ms [ User: postgres - Total duration: 3m10s - Times executed: 1703 ]
[ Application: [unknown] - Total duration: 3m10s - Times executed: 1703 ]
-
SELECT EXTRACT(EPOCH FROM NOW()) AS timestamp, SUM(pg_stat_get_db_xact_commit(oid) + pg_stat_get_db_xact_rollback(oid))::bigint AS no_xact, SUM(pg_database_size(datname)) AS total_size, MAX(LENGTH(datname)) AS max_length FROM pg_database;
Date: 2021-09-20 07:58:12 Duration: 516ms Database: postgres User: postgres Remote: [local] Application: [unknown]
-
SELECT EXTRACT(EPOCH FROM NOW()) AS timestamp, SUM(pg_stat_get_db_xact_commit(oid) + pg_stat_get_db_xact_rollback(oid))::bigint AS no_xact, SUM(pg_database_size(datname)) AS total_size, MAX(LENGTH(datname)) AS max_length FROM pg_database;
Date: 2021-09-20 08:53:44 Duration: 451ms Database: postgres User: postgres Remote: [local] Application: [unknown]
-
SELECT EXTRACT(EPOCH FROM NOW()) AS timestamp, SUM(pg_stat_get_db_xact_commit(oid) + pg_stat_get_db_xact_rollback(oid))::bigint AS no_xact, SUM(pg_database_size(datname)) AS total_size, MAX(LENGTH(datname)) AS max_length FROM pg_database;
Date: 2021-09-20 07:49:36 Duration: 439ms Database: postgres User: postgres Remote: [local] Application: [unknown]
2 1,184 1h11m38s 2s847ms 27s15ms 3s630ms select count(*) as fila from fila_trabalho.fila_trabalho where id_situacao_trabalho in (...) and entrada_fila > (now() - interval ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 20 01 108 6m7s 3s401ms 02 147 8m47s 3s590ms 03 148 12m2s 4s878ms 04 147 8m25s 3s438ms 05 146 8m8s 3s347ms 06 148 8m9s 3s306ms 07 145 8m13s 3s400ms 08 146 8m50s 3s636ms 09 49 2m53s 3s537ms [ User: zabbix - Total duration: 1h11m38s - Times executed: 1184 ]
[ Application: psql - Total duration: 1h11m38s - Times executed: 1184 ]
-
SELECT COUNT(*) as fila FROM fila_trabalho.fila_trabalho WHERE id_situacao_trabalho IN (1) and entrada_fila > (NOW() - interval '60 day');
Date: 2021-09-20 08:51:30 Duration: 27s15ms Database: augeeducacional User: zabbix Remote: [local] Application: psql
-
SELECT COUNT(*) as fila FROM fila_trabalho.fila_trabalho WHERE id_situacao_trabalho IN (1) and entrada_fila > (NOW() - interval '60 day');
Date: 2021-09-20 02:05:17 Duration: 14s68ms Database: augeeducacional User: zabbix Remote: [local] Application: psql
-
SELECT COUNT(*) as fila FROM fila_trabalho.fila_trabalho WHERE id_situacao_trabalho IN (1) and entrada_fila > (NOW() - interval '60 day');
Date: 2021-09-20 03:03:44 Duration: 12s188ms Database: augeeducacional User: zabbix Remote: [local] Application: psql
3 638 2m32s 100ms 1s23ms 239ms select distinct d.id_disciplina, d.descricao, cc.flg_aponta_notas, p1.nota as nota_p1, p1.sigla as conceito_p1, fad1.qtd_faltas as qtd_faltas_p1, p1.flg_nao_compareceu as nc_p1, p2.nota as nota_p2, p2.sigla as conceito_p2, fad2.qtd_faltas as qtd_faltas_p2, p2.flg_nao_compareceu as nc_p2, p3.nota as nota_p3, p3.sigla as conceito_p3, fad3.qtd_faltas as qtd_faltas_p3, p3.flg_nao_compareceu as nc_p3, p4.nota as nota_p4, p4.sigla as conceito_p4, fad4.qtd_faltas as qtd_faltas_p4, p4.flg_nao_compareceu as nc_p4, cf.nota as nota_rf, cf.sigla as conceito_rf, null as qtd_faltas, rec.nota as nota_rec, rec.sigla conceito_rec, cc.qtd_aulas_semanal, amdd.flg_dispensado_todos_periodos is true as flg_dispensado, case when amdd.flg_dispensado_todos_periodos is true then null else amdd.periodos || mdp.periodos end AS "periodosDispensaDisciplina", null as perc_freq, null as flg_possui_falta, rec.flg_nao_compareceu as nc_rec, fad1.falta_justificada as fj_p1, fad1.falta_nao_justificada as fnj_p1, fad2.falta_justificada as fj_p2, fad2.falta_nao_justificada as fnj_p2, fad3.falta_justificada as fj_p3, fad3.falta_nao_justificada as fnj_p3, fad4.falta_justificada as fj_p4, fad4.falta_nao_justificada as fnj_p4, null as qtd_faltas_nao_justificadas, cc.flg_aponta_faltas, d.ordem, cc.id_nucleo_disciplina, nd.descricao_historico from aluno_matricula am inner join aluno_matr_turma amt on amt.id_aluno_matricula = am.id_aluno_matricula inner join turma_serie ts on ts.id_serie = amt.id_serie_enturmacao and ts.id_turma = amt.id_turma inner join componente_curricular cc on cc.id_grade_curricular = ts.id_grade_curricular inner join disciplina d on d.id_disciplina = cc.id_disciplina inner join nucleo_disciplina nd on nd.id_nucleo_disciplina = cc.id_nucleo_disciplina left join aluno_matr_dispensa_disciplina amdd on amdd.id_aluno_matricula = am.id_aluno_matricula and amdd.id_turma = amt.id_turma and amdd.id_disciplina = d.id_disciplina left join aluno_matr_dispensa_periodo amdp on amdp.id_aluno_matricula = am.id_aluno_matricula left join motivo_dispensa_periodo mdp on mdp.id_motivo_dispensa_periodo = amdp.id_motivo_dispensa_periodo left join falta_aluno_disciplina fad1 on fad1.id_aluno_matricula = am.id_aluno_matricula and fad1.id_turma = amt.id_turma and fad1.id_disciplina = d.id_disciplina and fad1.id_nota_periodo_aluno = ? left join falta_aluno_disciplina fad2 on fad2.id_aluno_matricula = am.id_aluno_matricula and fad2.id_turma = amt.id_turma and fad2.id_disciplina = d.id_disciplina and fad2.id_nota_periodo_aluno = ? left join falta_aluno_disciplina fad3 on fad3.id_aluno_matricula = am.id_aluno_matricula and fad3.id_turma = amt.id_turma and fad3.id_disciplina = d.id_disciplina and fad3.id_nota_periodo_aluno = ? left join falta_aluno_disciplina fad4 on fad4.id_aluno_matricula = am.id_aluno_matricula and fad4.id_turma = amt.id_turma and fad4.id_disciplina = d.id_disciplina and fad4.id_nota_periodo_aluno = ? left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, coalesce(na.nota_continuidade_ciclo, na.nota) as nota, na.flg_nao_compareceu, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = ?) as p1 on p1.id_aluno_matricula = amt.id_aluno_matricula and p1.id_turma = amt.id_turma and p1.id_disciplina = d.id_disciplina left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, coalesce(na.nota_continuidade_ciclo, na.nota) as nota, na.flg_nao_compareceu, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = ?) as p2 on p2.id_aluno_matricula = amt.id_aluno_matricula and p2.id_turma = amt.id_turma and p2.id_disciplina = d.id_disciplina left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, coalesce(na.nota_continuidade_ciclo, na.nota) as nota, na.flg_nao_compareceu, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = ?) as p3 on p3.id_aluno_matricula = amt.id_aluno_matricula and p3.id_turma = amt.id_turma and p3.id_disciplina = d.id_disciplina left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, coalesce(na.nota_continuidade_ciclo, na.nota) as nota, na.flg_nao_compareceu, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = ?) as p4 on p4.id_aluno_matricula = amt.id_aluno_matricula and p4.id_turma = amt.id_turma and p4.id_disciplina = d.id_disciplina left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, na.nota, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = ?) as cf on cf.id_aluno_matricula = amt.id_aluno_matricula and cf.id_turma = amt.id_turma and cf.id_disciplina = d.id_disciplina left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, na.nota, na.flg_nao_compareceu, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = ?) as rec on rec.id_aluno_matricula = amt.id_aluno_matricula and rec.id_turma = amt.id_turma and rec.id_disciplina = d.id_disciplina where am.id_aluno_matricula = ? and amt.id_turma = ? order by id_nucleo_disciplina, d.ordem, d.descricao;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 20 09 638 2m32s 239ms [ User: augeeducacional - Total duration: 2m32s - Times executed: 638 ]
[ Application: augeeducacional - principal - Total duration: 2m32s - Times executed: 638 ]
-
select distinct d.id_disciplina, d.descricao, cc.flg_aponta_notas, p1.nota as nota_p1, p1.sigla as conceito_p1, fad1.qtd_faltas as qtd_faltas_p1, p1.flg_nao_compareceu as nc_p1, p2.nota as nota_p2, p2.sigla as conceito_p2, fad2.qtd_faltas as qtd_faltas_p2, p2.flg_nao_compareceu as nc_p2, p3.nota as nota_p3, p3.sigla as conceito_p3, fad3.qtd_faltas as qtd_faltas_p3, p3.flg_nao_compareceu as nc_p3, p4.nota as nota_p4, p4.sigla as conceito_p4, fad4.qtd_faltas as qtd_faltas_p4, p4.flg_nao_compareceu as nc_p4, cf.nota as nota_rf, cf.sigla as conceito_rf, null as qtd_faltas, rec.nota as nota_rec, rec.sigla conceito_rec, cc.qtd_aulas_semanal, amdd.flg_dispensado_todos_periodos is true as flg_dispensado, case when amdd.flg_dispensado_todos_periodos is true then null else amdd.periodos || mdp.periodos end as "periodosDispensaDisciplina", null as perc_freq, null as flg_possui_falta, rec.flg_nao_compareceu as nc_rec, fad1.falta_justificada as fj_p1, fad1.falta_nao_justificada as fnj_p1, fad2.falta_justificada as fj_p2, fad2.falta_nao_justificada as fnj_p2, fad3.falta_justificada as fj_p3, fad3.falta_nao_justificada as fnj_p3, fad4.falta_justificada as fj_p4, fad4.falta_nao_justificada as fnj_p4, null as qtd_faltas_nao_justificadas, cc.flg_aponta_faltas, d.ordem, cc.id_nucleo_disciplina, nd.descricao_historico from aluno_matricula am inner join aluno_matr_turma amt on amt.id_aluno_matricula = am.id_aluno_matricula inner join turma_serie ts on ts.id_serie = amt.id_serie_enturmacao and ts.id_turma = amt.id_turma inner join componente_curricular cc on cc.id_grade_curricular = ts.id_grade_curricular inner join disciplina d on d.id_disciplina = cc.id_disciplina inner join nucleo_disciplina nd on nd.id_nucleo_disciplina = cc.id_nucleo_disciplina left join aluno_matr_dispensa_disciplina amdd on amdd.id_aluno_matricula = am.id_aluno_matricula and amdd.id_turma = amt.id_turma and amdd.id_disciplina = d.id_disciplina left join aluno_matr_dispensa_periodo amdp on amdp.id_aluno_matricula = am.id_aluno_matricula left join motivo_dispensa_periodo mdp on mdp.id_motivo_dispensa_periodo = amdp.id_motivo_dispensa_periodo left join falta_aluno_disciplina fad1 on fad1.id_aluno_matricula = am.id_aluno_matricula and fad1.id_turma = amt.id_turma and fad1.id_disciplina = d.id_disciplina and fad1.id_nota_periodo_aluno = '1' left join falta_aluno_disciplina fad2 on fad2.id_aluno_matricula = am.id_aluno_matricula and fad2.id_turma = amt.id_turma and fad2.id_disciplina = d.id_disciplina and fad2.id_nota_periodo_aluno = '2' left join falta_aluno_disciplina fad3 on fad3.id_aluno_matricula = am.id_aluno_matricula and fad3.id_turma = amt.id_turma and fad3.id_disciplina = d.id_disciplina and fad3.id_nota_periodo_aluno = '3' left join falta_aluno_disciplina fad4 on fad4.id_aluno_matricula = am.id_aluno_matricula and fad4.id_turma = amt.id_turma and fad4.id_disciplina = d.id_disciplina and fad4.id_nota_periodo_aluno = '4' left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, coalesce(na.nota_continuidade_ciclo, na.nota) as nota, na.flg_nao_compareceu, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = '1') as p1 on p1.id_aluno_matricula = amt.id_aluno_matricula and p1.id_turma = amt.id_turma and p1.id_disciplina = d.id_disciplina left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, coalesce(na.nota_continuidade_ciclo, na.nota) as nota, na.flg_nao_compareceu, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = '2') as p2 on p2.id_aluno_matricula = amt.id_aluno_matricula and p2.id_turma = amt.id_turma and p2.id_disciplina = d.id_disciplina left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, coalesce(na.nota_continuidade_ciclo, na.nota) as nota, na.flg_nao_compareceu, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = '3') as p3 on p3.id_aluno_matricula = amt.id_aluno_matricula and p3.id_turma = amt.id_turma and p3.id_disciplina = d.id_disciplina left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, coalesce(na.nota_continuidade_ciclo, na.nota) as nota, na.flg_nao_compareceu, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = '4') as p4 on p4.id_aluno_matricula = amt.id_aluno_matricula and p4.id_turma = amt.id_turma and p4.id_disciplina = d.id_disciplina left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, na.nota, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = '5') as cf on cf.id_aluno_matricula = amt.id_aluno_matricula and cf.id_turma = amt.id_turma and cf.id_disciplina = d.id_disciplina left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, na.nota, na.flg_nao_compareceu, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = '6') as rec on rec.id_aluno_matricula = amt.id_aluno_matricula and rec.id_turma = amt.id_turma and rec.id_disciplina = d.id_disciplina where am.id_aluno_matricula = '8561668' and amt.id_turma = '190037939' order by id_nucleo_disciplina, d.ordem, d.descricao;
Date: 2021-09-20 09:13:48 Duration: 1s23ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select distinct d.id_disciplina, d.descricao, cc.flg_aponta_notas, p1.nota as nota_p1, p1.sigla as conceito_p1, fad1.qtd_faltas as qtd_faltas_p1, p1.flg_nao_compareceu as nc_p1, p2.nota as nota_p2, p2.sigla as conceito_p2, fad2.qtd_faltas as qtd_faltas_p2, p2.flg_nao_compareceu as nc_p2, p3.nota as nota_p3, p3.sigla as conceito_p3, fad3.qtd_faltas as qtd_faltas_p3, p3.flg_nao_compareceu as nc_p3, p4.nota as nota_p4, p4.sigla as conceito_p4, fad4.qtd_faltas as qtd_faltas_p4, p4.flg_nao_compareceu as nc_p4, cf.nota as nota_rf, cf.sigla as conceito_rf, null as qtd_faltas, rec.nota as nota_rec, rec.sigla conceito_rec, cc.qtd_aulas_semanal, amdd.flg_dispensado_todos_periodos is true as flg_dispensado, case when amdd.flg_dispensado_todos_periodos is true then null else amdd.periodos || mdp.periodos end as "periodosDispensaDisciplina", null as perc_freq, null as flg_possui_falta, rec.flg_nao_compareceu as nc_rec, fad1.falta_justificada as fj_p1, fad1.falta_nao_justificada as fnj_p1, fad2.falta_justificada as fj_p2, fad2.falta_nao_justificada as fnj_p2, fad3.falta_justificada as fj_p3, fad3.falta_nao_justificada as fnj_p3, fad4.falta_justificada as fj_p4, fad4.falta_nao_justificada as fnj_p4, null as qtd_faltas_nao_justificadas, cc.flg_aponta_faltas, d.ordem, cc.id_nucleo_disciplina, nd.descricao_historico from aluno_matricula am inner join aluno_matr_turma amt on amt.id_aluno_matricula = am.id_aluno_matricula inner join turma_serie ts on ts.id_serie = amt.id_serie_enturmacao and ts.id_turma = amt.id_turma inner join componente_curricular cc on cc.id_grade_curricular = ts.id_grade_curricular inner join disciplina d on d.id_disciplina = cc.id_disciplina inner join nucleo_disciplina nd on nd.id_nucleo_disciplina = cc.id_nucleo_disciplina left join aluno_matr_dispensa_disciplina amdd on amdd.id_aluno_matricula = am.id_aluno_matricula and amdd.id_turma = amt.id_turma and amdd.id_disciplina = d.id_disciplina left join aluno_matr_dispensa_periodo amdp on amdp.id_aluno_matricula = am.id_aluno_matricula left join motivo_dispensa_periodo mdp on mdp.id_motivo_dispensa_periodo = amdp.id_motivo_dispensa_periodo left join falta_aluno_disciplina fad1 on fad1.id_aluno_matricula = am.id_aluno_matricula and fad1.id_turma = amt.id_turma and fad1.id_disciplina = d.id_disciplina and fad1.id_nota_periodo_aluno = '1' left join falta_aluno_disciplina fad2 on fad2.id_aluno_matricula = am.id_aluno_matricula and fad2.id_turma = amt.id_turma and fad2.id_disciplina = d.id_disciplina and fad2.id_nota_periodo_aluno = '2' left join falta_aluno_disciplina fad3 on fad3.id_aluno_matricula = am.id_aluno_matricula and fad3.id_turma = amt.id_turma and fad3.id_disciplina = d.id_disciplina and fad3.id_nota_periodo_aluno = '3' left join falta_aluno_disciplina fad4 on fad4.id_aluno_matricula = am.id_aluno_matricula and fad4.id_turma = amt.id_turma and fad4.id_disciplina = d.id_disciplina and fad4.id_nota_periodo_aluno = '4' left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, coalesce(na.nota_continuidade_ciclo, na.nota) as nota, na.flg_nao_compareceu, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = '1') as p1 on p1.id_aluno_matricula = amt.id_aluno_matricula and p1.id_turma = amt.id_turma and p1.id_disciplina = d.id_disciplina left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, coalesce(na.nota_continuidade_ciclo, na.nota) as nota, na.flg_nao_compareceu, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = '2') as p2 on p2.id_aluno_matricula = amt.id_aluno_matricula and p2.id_turma = amt.id_turma and p2.id_disciplina = d.id_disciplina left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, coalesce(na.nota_continuidade_ciclo, na.nota) as nota, na.flg_nao_compareceu, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = '3') as p3 on p3.id_aluno_matricula = amt.id_aluno_matricula and p3.id_turma = amt.id_turma and p3.id_disciplina = d.id_disciplina left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, coalesce(na.nota_continuidade_ciclo, na.nota) as nota, na.flg_nao_compareceu, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = '4') as p4 on p4.id_aluno_matricula = amt.id_aluno_matricula and p4.id_turma = amt.id_turma and p4.id_disciplina = d.id_disciplina left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, na.nota, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = '5') as cf on cf.id_aluno_matricula = amt.id_aluno_matricula and cf.id_turma = amt.id_turma and cf.id_disciplina = d.id_disciplina left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, na.nota, na.flg_nao_compareceu, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = '6') as rec on rec.id_aluno_matricula = amt.id_aluno_matricula and rec.id_turma = amt.id_turma and rec.id_disciplina = d.id_disciplina where am.id_aluno_matricula = '8641724' and amt.id_turma = '190005890' order by id_nucleo_disciplina, d.ordem, d.descricao;
Date: 2021-09-20 09:14:03 Duration: 837ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select distinct d.id_disciplina, d.descricao, cc.flg_aponta_notas, p1.nota as nota_p1, p1.sigla as conceito_p1, fad1.qtd_faltas as qtd_faltas_p1, p1.flg_nao_compareceu as nc_p1, p2.nota as nota_p2, p2.sigla as conceito_p2, fad2.qtd_faltas as qtd_faltas_p2, p2.flg_nao_compareceu as nc_p2, p3.nota as nota_p3, p3.sigla as conceito_p3, fad3.qtd_faltas as qtd_faltas_p3, p3.flg_nao_compareceu as nc_p3, p4.nota as nota_p4, p4.sigla as conceito_p4, fad4.qtd_faltas as qtd_faltas_p4, p4.flg_nao_compareceu as nc_p4, cf.nota as nota_rf, cf.sigla as conceito_rf, null as qtd_faltas, rec.nota as nota_rec, rec.sigla conceito_rec, cc.qtd_aulas_semanal, amdd.flg_dispensado_todos_periodos is true as flg_dispensado, case when amdd.flg_dispensado_todos_periodos is true then null else amdd.periodos || mdp.periodos end as "periodosDispensaDisciplina", null as perc_freq, null as flg_possui_falta, rec.flg_nao_compareceu as nc_rec, fad1.falta_justificada as fj_p1, fad1.falta_nao_justificada as fnj_p1, fad2.falta_justificada as fj_p2, fad2.falta_nao_justificada as fnj_p2, fad3.falta_justificada as fj_p3, fad3.falta_nao_justificada as fnj_p3, fad4.falta_justificada as fj_p4, fad4.falta_nao_justificada as fnj_p4, null as qtd_faltas_nao_justificadas, cc.flg_aponta_faltas, d.ordem, cc.id_nucleo_disciplina, nd.descricao_historico from aluno_matricula am inner join aluno_matr_turma amt on amt.id_aluno_matricula = am.id_aluno_matricula inner join turma_serie ts on ts.id_serie = amt.id_serie_enturmacao and ts.id_turma = amt.id_turma inner join componente_curricular cc on cc.id_grade_curricular = ts.id_grade_curricular inner join disciplina d on d.id_disciplina = cc.id_disciplina inner join nucleo_disciplina nd on nd.id_nucleo_disciplina = cc.id_nucleo_disciplina left join aluno_matr_dispensa_disciplina amdd on amdd.id_aluno_matricula = am.id_aluno_matricula and amdd.id_turma = amt.id_turma and amdd.id_disciplina = d.id_disciplina left join aluno_matr_dispensa_periodo amdp on amdp.id_aluno_matricula = am.id_aluno_matricula left join motivo_dispensa_periodo mdp on mdp.id_motivo_dispensa_periodo = amdp.id_motivo_dispensa_periodo left join falta_aluno_disciplina fad1 on fad1.id_aluno_matricula = am.id_aluno_matricula and fad1.id_turma = amt.id_turma and fad1.id_disciplina = d.id_disciplina and fad1.id_nota_periodo_aluno = '1' left join falta_aluno_disciplina fad2 on fad2.id_aluno_matricula = am.id_aluno_matricula and fad2.id_turma = amt.id_turma and fad2.id_disciplina = d.id_disciplina and fad2.id_nota_periodo_aluno = '2' left join falta_aluno_disciplina fad3 on fad3.id_aluno_matricula = am.id_aluno_matricula and fad3.id_turma = amt.id_turma and fad3.id_disciplina = d.id_disciplina and fad3.id_nota_periodo_aluno = '3' left join falta_aluno_disciplina fad4 on fad4.id_aluno_matricula = am.id_aluno_matricula and fad4.id_turma = amt.id_turma and fad4.id_disciplina = d.id_disciplina and fad4.id_nota_periodo_aluno = '4' left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, coalesce(na.nota_continuidade_ciclo, na.nota) as nota, na.flg_nao_compareceu, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = '1') as p1 on p1.id_aluno_matricula = amt.id_aluno_matricula and p1.id_turma = amt.id_turma and p1.id_disciplina = d.id_disciplina left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, coalesce(na.nota_continuidade_ciclo, na.nota) as nota, na.flg_nao_compareceu, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = '2') as p2 on p2.id_aluno_matricula = amt.id_aluno_matricula and p2.id_turma = amt.id_turma and p2.id_disciplina = d.id_disciplina left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, coalesce(na.nota_continuidade_ciclo, na.nota) as nota, na.flg_nao_compareceu, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = '3') as p3 on p3.id_aluno_matricula = amt.id_aluno_matricula and p3.id_turma = amt.id_turma and p3.id_disciplina = d.id_disciplina left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, coalesce(na.nota_continuidade_ciclo, na.nota) as nota, na.flg_nao_compareceu, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = '4') as p4 on p4.id_aluno_matricula = amt.id_aluno_matricula and p4.id_turma = amt.id_turma and p4.id_disciplina = d.id_disciplina left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, na.nota, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = '5') as cf on cf.id_aluno_matricula = amt.id_aluno_matricula and cf.id_turma = amt.id_turma and cf.id_disciplina = d.id_disciplina left join ( select na.id_disciplina, na.id_aluno_matricula, na.id_turma, na.nota, na.flg_nao_compareceu, ca.sigla from nota_aluno na left join conceito_avaliacao ca on ca.id_conceito_avaliacao = na.id_conceito_avaliacao where na.id_nota_periodo_aluno = '6') as rec on rec.id_aluno_matricula = amt.id_aluno_matricula and rec.id_turma = amt.id_turma and rec.id_disciplina = d.id_disciplina where am.id_aluno_matricula = '9499035' and amt.id_turma = '200012416' order by id_nucleo_disciplina, d.ordem, d.descricao;
Date: 2021-09-20 09:07:33 Duration: 781ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
4 553 3m28s 100ms 2s80ms 376ms insert into falta_aluno_disciplina (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, falta_justificada, falta_nao_justificada, qtd_faltas) select amt.id_aluno_matricula, amt.id_turma, ? as id_disciplina, ? as id_nota_periodo_aluno, sum( case when falta.flg_justificada is true then ? else ? end) + coalesce(falta_anterior.falta_justificada, ?) as falta_justificada, sum( case when falta.flg_justificada is false then ? else ? end) + coalesce(falta_anterior.falta_nao_justificada, ?) as falta_nao_justificada, count(falta.id_aluno_matricula) + coalesce(falta_anterior.falta_justificada, ?) + coalesce(falta_anterior.falta_nao_justificada, ?) as qtd_faltas from aluno_matr_turma amt left join falta_aluno_disciplina_diario falta on falta.id_aluno_matricula = amt.id_aluno_matricula and amt.id_turma = falta.id_turma and falta.id_disciplina = ? and falta.id_nota_periodo_aluno = ? left join falta_anterior_aluno_disciplina falta_anterior on falta_anterior.id_aluno_matricula = amt.id_aluno_matricula and amt.id_turma = falta_anterior.id_turma and falta_anterior.id_disciplina = ? and falta_anterior.id_nota_periodo_aluno = ? where amt.id_turma = ? group by amt.id_aluno_matricula, amt.id_turma, falta_anterior.falta_justificada, falta_anterior.falta_nao_justificada;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 20 08 1 264ms 264ms 09 552 3m28s 376ms [ User: augeeducacional - Total duration: 3m28s - Times executed: 553 ]
[ Application: augeeducacional - fila - Total duration: 2m13s - Times executed: 377 ]
[ Application: augeeducacional - principal - Total duration: 1m14s - Times executed: 176 ]
-
insert into falta_aluno_disciplina (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, falta_justificada, falta_nao_justificada, qtd_faltas) select amt.id_aluno_matricula, amt.id_turma, '1131' as id_disciplina, '3' as id_nota_periodo_aluno, sum( case when falta.flg_justificada is true then 1 else 0 end) + coalesce(falta_anterior.falta_justificada, 0) as falta_justificada, sum( case when falta.flg_justificada is false then 1 else 0 end) + coalesce(falta_anterior.falta_nao_justificada, 0) as falta_nao_justificada, count(falta.id_aluno_matricula) + coalesce(falta_anterior.falta_justificada, 0) + coalesce(falta_anterior.falta_nao_justificada, 0) as qtd_faltas from aluno_matr_turma amt left join falta_aluno_disciplina_diario falta on falta.id_aluno_matricula = amt.id_aluno_matricula and amt.id_turma = falta.id_turma and falta.id_disciplina = '1131' and falta.id_nota_periodo_aluno = '3' left join falta_anterior_aluno_disciplina falta_anterior on falta_anterior.id_aluno_matricula = amt.id_aluno_matricula and amt.id_turma = falta_anterior.id_turma and falta_anterior.id_disciplina = '1131' and falta_anterior.id_nota_periodo_aluno = '3' where amt.id_turma = '210016672' group by amt.id_aluno_matricula, amt.id_turma, falta_anterior.falta_justificada, falta_anterior.falta_nao_justificada;
Date: 2021-09-20 09:10:21 Duration: 2s80ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
insert into falta_aluno_disciplina (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, falta_justificada, falta_nao_justificada, qtd_faltas) select amt.id_aluno_matricula, amt.id_turma, '1128' as id_disciplina, '3' as id_nota_periodo_aluno, sum( case when falta.flg_justificada is true then 1 else 0 end) + coalesce(falta_anterior.falta_justificada, 0) as falta_justificada, sum( case when falta.flg_justificada is false then 1 else 0 end) + coalesce(falta_anterior.falta_nao_justificada, 0) as falta_nao_justificada, count(falta.id_aluno_matricula) + coalesce(falta_anterior.falta_justificada, 0) + coalesce(falta_anterior.falta_nao_justificada, 0) as qtd_faltas from aluno_matr_turma amt left join falta_aluno_disciplina_diario falta on falta.id_aluno_matricula = amt.id_aluno_matricula and amt.id_turma = falta.id_turma and falta.id_disciplina = '1128' and falta.id_nota_periodo_aluno = '3' left join falta_anterior_aluno_disciplina falta_anterior on falta_anterior.id_aluno_matricula = amt.id_aluno_matricula and amt.id_turma = falta_anterior.id_turma and falta_anterior.id_disciplina = '1128' and falta_anterior.id_nota_periodo_aluno = '3' where amt.id_turma = '210012715' group by amt.id_aluno_matricula, amt.id_turma, falta_anterior.falta_justificada, falta_anterior.falta_nao_justificada;
Date: 2021-09-20 09:18:05 Duration: 1s831ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - fila Bind query: yes
-
insert into falta_aluno_disciplina (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, falta_justificada, falta_nao_justificada, qtd_faltas) select amt.id_aluno_matricula, amt.id_turma, '1128' as id_disciplina, '3' as id_nota_periodo_aluno, sum( case when falta.flg_justificada is true then 1 else 0 end) + coalesce(falta_anterior.falta_justificada, 0) as falta_justificada, sum( case when falta.flg_justificada is false then 1 else 0 end) + coalesce(falta_anterior.falta_nao_justificada, 0) as falta_nao_justificada, count(falta.id_aluno_matricula) + coalesce(falta_anterior.falta_justificada, 0) + coalesce(falta_anterior.falta_nao_justificada, 0) as qtd_faltas from aluno_matr_turma amt left join falta_aluno_disciplina_diario falta on falta.id_aluno_matricula = amt.id_aluno_matricula and amt.id_turma = falta.id_turma and falta.id_disciplina = '1128' and falta.id_nota_periodo_aluno = '3' left join falta_anterior_aluno_disciplina falta_anterior on falta_anterior.id_aluno_matricula = amt.id_aluno_matricula and amt.id_turma = falta_anterior.id_turma and falta_anterior.id_disciplina = '1128' and falta_anterior.id_nota_periodo_aluno = '3' where amt.id_turma = '210016597' group by amt.id_aluno_matricula, amt.id_turma, falta_anterior.falta_justificada, falta_anterior.falta_nao_justificada;
Date: 2021-09-20 09:13:49 Duration: 1s477ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - fila Bind query: yes
5 283 10m19s 1s785ms 3s367ms 2s188ms select ts.id_turma, ts.id_modelo_avaliacao_desc, ts.id_modelo_acompanhamento_atitudinal, ts.id_modelo_observacao_estudante, null as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma on turma.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = turma.id_unidade_funcional where uf.id_instituicao = ? and (ts.id_modelo_avaliacao_desc is not null or ts.id_modelo_acompanhamento_atitudinal is not null or ts.id_modelo_observacao_estudante is not null) and turma.flg_organizada is true and turma.id_turma in ( select tp.id_turma from turma_professor tp where tp.id_turma = turma.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = ?) union all select ts.id_turma, null as id_modelo_avaliacao_desc, null as id_modelo_observacao_estudante, null as id_modelo_acompanhamento_atitudinal, tsm.id_modelo_avaliacao_desc as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma t on t.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = t.id_unidade_funcional inner join turma_serie_modelo_avaliacao_desc tsm on tsm.id_serie = ts.id_serie and tsm.id_turma = ts.id_turma and tsm.id_tipo_modelo_avaliacao_desc = ? inner join modelo_avaliacao_desc modelo_ficha_acompanhamento on modelo_ficha_acompanhamento.id_modelo_avaliacao_desc = tsm.id_modelo_avaliacao_desc where uf.id_instituicao = ? and t.flg_organizada is true and exists ( select null from turma_professor tp inner join componente_curricular on componente_curricular.id_componente_curricular = tp.id_componente_curricular where tp.id_turma = t.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = ? and componente_curricular.id_disciplina = modelo_ficha_acompanhamento.id_disciplina);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 20 09 283 10m19s 2s188ms [ User: augeeducacional - Total duration: 10m19s - Times executed: 283 ]
[ Application: augeeducacional - principal - Total duration: 10m19s - Times executed: 283 ]
-
select ts.id_turma, ts.id_modelo_avaliacao_desc, ts.id_modelo_acompanhamento_atitudinal, ts.id_modelo_observacao_estudante, null as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma on turma.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = turma.id_unidade_funcional where uf.id_instituicao = '60' and (ts.id_modelo_avaliacao_desc is not null or ts.id_modelo_acompanhamento_atitudinal is not null or ts.id_modelo_observacao_estudante is not null) and turma.flg_organizada is true and turma.id_turma in ( select tp.id_turma from turma_professor tp where tp.id_turma = turma.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = '2682309') union all select ts.id_turma, null as id_modelo_avaliacao_desc, null as id_modelo_observacao_estudante, null as id_modelo_acompanhamento_atitudinal, tsm.id_modelo_avaliacao_desc as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma t on t.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = t.id_unidade_funcional inner join turma_serie_modelo_avaliacao_desc tsm on tsm.id_serie = ts.id_serie and tsm.id_turma = ts.id_turma and tsm.id_tipo_modelo_avaliacao_desc = 4 inner join modelo_avaliacao_desc modelo_ficha_acompanhamento on modelo_ficha_acompanhamento.id_modelo_avaliacao_desc = tsm.id_modelo_avaliacao_desc where uf.id_instituicao = '60' and t.flg_organizada is true and exists ( select null from turma_professor tp inner join componente_curricular on componente_curricular.id_componente_curricular = tp.id_componente_curricular where tp.id_turma = t.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = '2682309' and componente_curricular.id_disciplina = modelo_ficha_acompanhamento.id_disciplina);
Date: 2021-09-20 09:05:34 Duration: 3s367ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select ts.id_turma, ts.id_modelo_avaliacao_desc, ts.id_modelo_acompanhamento_atitudinal, ts.id_modelo_observacao_estudante, null as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma on turma.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = turma.id_unidade_funcional where uf.id_instituicao = '60' and (ts.id_modelo_avaliacao_desc is not null or ts.id_modelo_acompanhamento_atitudinal is not null or ts.id_modelo_observacao_estudante is not null) and turma.flg_organizada is true and turma.id_turma in ( select tp.id_turma from turma_professor tp where tp.id_turma = turma.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = '7797887') union all select ts.id_turma, null as id_modelo_avaliacao_desc, null as id_modelo_observacao_estudante, null as id_modelo_acompanhamento_atitudinal, tsm.id_modelo_avaliacao_desc as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma t on t.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = t.id_unidade_funcional inner join turma_serie_modelo_avaliacao_desc tsm on tsm.id_serie = ts.id_serie and tsm.id_turma = ts.id_turma and tsm.id_tipo_modelo_avaliacao_desc = 4 inner join modelo_avaliacao_desc modelo_ficha_acompanhamento on modelo_ficha_acompanhamento.id_modelo_avaliacao_desc = tsm.id_modelo_avaliacao_desc where uf.id_instituicao = '60' and t.flg_organizada is true and exists ( select null from turma_professor tp inner join componente_curricular on componente_curricular.id_componente_curricular = tp.id_componente_curricular where tp.id_turma = t.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = '7797887' and componente_curricular.id_disciplina = modelo_ficha_acompanhamento.id_disciplina);
Date: 2021-09-20 09:04:12 Duration: 2s940ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select ts.id_turma, ts.id_modelo_avaliacao_desc, ts.id_modelo_acompanhamento_atitudinal, ts.id_modelo_observacao_estudante, null as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma on turma.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = turma.id_unidade_funcional where uf.id_instituicao = '60' and (ts.id_modelo_avaliacao_desc is not null or ts.id_modelo_acompanhamento_atitudinal is not null or ts.id_modelo_observacao_estudante is not null) and turma.flg_organizada is true and turma.id_turma in ( select tp.id_turma from turma_professor tp where tp.id_turma = turma.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = '7169818') union all select ts.id_turma, null as id_modelo_avaliacao_desc, null as id_modelo_observacao_estudante, null as id_modelo_acompanhamento_atitudinal, tsm.id_modelo_avaliacao_desc as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma t on t.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = t.id_unidade_funcional inner join turma_serie_modelo_avaliacao_desc tsm on tsm.id_serie = ts.id_serie and tsm.id_turma = ts.id_turma and tsm.id_tipo_modelo_avaliacao_desc = 4 inner join modelo_avaliacao_desc modelo_ficha_acompanhamento on modelo_ficha_acompanhamento.id_modelo_avaliacao_desc = tsm.id_modelo_avaliacao_desc where uf.id_instituicao = '60' and t.flg_organizada is true and exists ( select null from turma_professor tp inner join componente_curricular on componente_curricular.id_componente_curricular = tp.id_componente_curricular where tp.id_turma = t.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = '7169818' and componente_curricular.id_disciplina = modelo_ficha_acompanhamento.id_disciplina);
Date: 2021-09-20 09:01:31 Duration: 2s837ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
6 219 1m18s 106ms 9s813ms 356ms select exists ( select null from movel.turma_mudanca where id_turma in ( select tp.id_turma from turma_professor tp where tp.id_cidadao = ?) and data between ? and now());Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 20 09 219 1m18s 356ms [ User: augeeducacional - Total duration: 1m18s - Times executed: 219 ]
[ Application: augeeducacional - principal - Total duration: 1m18s - Times executed: 219 ]
-
select exists ( select null from movel.turma_mudanca where id_turma in ( select tp.id_turma from turma_professor tp where tp.id_cidadao = '2621799') and data between '2021-09-17 11:40:35.143' and now());
Date: 2021-09-20 09:00:28 Duration: 9s813ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select exists ( select null from movel.turma_mudanca where id_turma in ( select tp.id_turma from turma_professor tp where tp.id_cidadao = '4952654') and data between '2021-08-06 11:09:27.419' and now());
Date: 2021-09-20 09:14:08 Duration: 8s121ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select exists ( select null from movel.turma_mudanca where id_turma in ( select tp.id_turma from turma_professor tp where tp.id_cidadao = '5561510') and data between '2021-09-17 11:25:18.719' and now());
Date: 2021-09-20 09:01:09 Duration: 1s539ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
7 194 7m32s 1s526ms 11s834ms 2s330ms select count(*) from pg_buffercache where not isdirty;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 20 01 18 36s460ms 2s25ms 02 24 1m3s 2s632ms 03 24 1m42s 4s289ms 04 24 46s719ms 1s946ms 05 24 47s339ms 1s972ms 06 24 45s991ms 1s916ms 07 24 47s446ms 1s976ms 08 24 46s872ms 1s953ms 09 8 15s64ms 1s883ms [ User: zabbix - Total duration: 7m32s - Times executed: 194 ]
[ Application: psql - Total duration: 7m32s - Times executed: 194 ]
-
select count(*) from pg_buffercache where not isdirty;
Date: 2021-09-20 02:05:36 Duration: 11s834ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where not isdirty;
Date: 2021-09-20 03:06:10 Duration: 11s826ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where not isdirty;
Date: 2021-09-20 02:10:56 Duration: 8s58ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
8 194 6m39s 1s342ms 13s 2s57ms select count(*) from pg_buffercache where isdirty;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 20 01 18 30s381ms 1s687ms 02 24 59s670ms 2s486ms 03 24 1m34s 3s918ms 04 24 41s633ms 1s734ms 05 24 40s353ms 1s681ms 06 24 39s265ms 1s636ms 07 24 40s82ms 1s670ms 08 24 40s19ms 1s667ms 09 8 13s666ms 1s708ms [ User: zabbix - Total duration: 6m39s - Times executed: 194 ]
[ Application: psql - Total duration: 6m39s - Times executed: 194 ]
-
select count(*) from pg_buffercache where isdirty;
Date: 2021-09-20 02:05:40 Duration: 13s Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where isdirty;
Date: 2021-09-20 03:06:11 Duration: 8s859ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where isdirty;
Date: 2021-09-20 02:10:56 Duration: 7s822ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
9 194 6m3s 1s294ms 11s399ms 1s875ms select count(*) from pg_buffercache;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 20 01 18 29s301ms 1s627ms 02 24 56s941ms 2s372ms 03 24 1m15s 3s137ms 04 24 37s370ms 1s557ms 05 24 38s196ms 1s591ms 06 24 38s473ms 1s603ms 07 24 38s980ms 1s624ms 08 24 37s93ms 1s545ms 09 8 12s153ms 1s519ms [ User: zabbix - Total duration: 6m3s - Times executed: 194 ]
[ Application: psql - Total duration: 6m3s - Times executed: 194 ]
-
select count(*) from pg_buffercache;
Date: 2021-09-20 02:05:41 Duration: 11s399ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache;
Date: 2021-09-20 02:10:56 Duration: 7s758ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache;
Date: 2021-09-20 03:06:56 Duration: 7s278ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
10 194 5m46s 1s455ms 5s256ms 1s784ms select count(*) from pg_buffercache where reldatabase is not null;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 20 01 18 31s130ms 1s729ms 02 24 45s376ms 1s890ms 03 24 49s889ms 2s78ms 04 24 40s554ms 1s689ms 05 24 42s813ms 1s783ms 06 24 40s976ms 1s707ms 07 24 41s598ms 1s733ms 08 24 40s439ms 1s684ms 09 8 13s488ms 1s686ms [ User: zabbix - Total duration: 5m46s - Times executed: 194 ]
[ Application: psql - Total duration: 5m46s - Times executed: 194 ]
-
select count(*) from pg_buffercache where reldatabase is not null;
Date: 2021-09-20 02:05:41 Duration: 5s256ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where reldatabase is not null;
Date: 2021-09-20 03:06:56 Duration: 4s331ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where reldatabase is not null;
Date: 2021-09-20 03:01:12 Duration: 4s114ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
11 176 42s351ms 102ms 764ms 240ms update situacao_didatica_aula set numero_aula = sda.seq_numero_aula from ( select sda.id_situacao_didatica_aula, row_number() over (order by sda.data, horario_turma.horario_inicio) as seq_numero_aula from situacao_didatica_aula sda inner join horario_turma on horario_turma.id_horario_turma = sda.id_horario_turma where sda.id_turma = ? and sda.id_serie = ? and sda.id_componente_curricular = ?) as sda where situacao_didatica_aula.id_situacao_didatica_aula = sda.id_situacao_didatica_aula;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 20 09 176 42s351ms 240ms [ User: augeeducacional - Total duration: 42s351ms - Times executed: 176 ]
[ Application: augeeducacional - fila - Total duration: 23s814ms - Times executed: 99 ]
[ Application: augeeducacional - principal - Total duration: 18s536ms - Times executed: 77 ]
-
update situacao_didatica_aula set numero_aula = sda.seq_numero_aula from ( select sda.id_situacao_didatica_aula, row_number() over (order by sda.data, horario_turma.horario_inicio) as seq_numero_aula from situacao_didatica_aula sda inner join horario_turma on horario_turma.id_horario_turma = sda.id_horario_turma where sda.id_turma = '210025672' and sda.id_serie = '1209' and sda.id_componente_curricular = '80350') as sda where situacao_didatica_aula.id_situacao_didatica_aula = sda.id_situacao_didatica_aula;
Date: 2021-09-20 09:13:54 Duration: 764ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
update situacao_didatica_aula set numero_aula = sda.seq_numero_aula from ( select sda.id_situacao_didatica_aula, row_number() over (order by sda.data, horario_turma.horario_inicio) as seq_numero_aula from situacao_didatica_aula sda inner join horario_turma on horario_turma.id_horario_turma = sda.id_horario_turma where sda.id_turma = '210006666' and sda.id_serie = '1908' and sda.id_componente_curricular = '76349') as sda where situacao_didatica_aula.id_situacao_didatica_aula = sda.id_situacao_didatica_aula;
Date: 2021-09-20 09:17:02 Duration: 629ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
update situacao_didatica_aula set numero_aula = sda.seq_numero_aula from ( select sda.id_situacao_didatica_aula, row_number() over (order by sda.data, horario_turma.horario_inicio) as seq_numero_aula from situacao_didatica_aula sda inner join horario_turma on horario_turma.id_horario_turma = sda.id_horario_turma where sda.id_turma = '210016597' and sda.id_serie = '1211' and sda.id_componente_curricular = '80359') as sda where situacao_didatica_aula.id_situacao_didatica_aula = sda.id_situacao_didatica_aula;
Date: 2021-09-20 09:12:12 Duration: 600ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - fila Bind query: yes
12 167 2m45s 323ms 5s113ms 991ms select json_agg(r.*)::text as r from ( select apontamento.id_aluno_matricula, apontamento.id_turma, apontamento.id_area_conhecimento_gestao, apontamento.id_nota_periodo_aluno, apontamento.id_eixo_modelo_avaliacao_desc, apontamento.id_opcao_eixo_modelo_aval, apontamento.expressao_aval_livre, apontamento.valor_numerico, apontamento.id_area_conhecimento_gestao from apontamento_acompanhamento_atitudinal apontamento inner join turma on turma.id_turma = apontamento.id_turma where turma.id_turma_status = ? and turma.flg_organizada is true and exists ( select null from turma_professor tp inner join componente_curricular cc on cc.id_componente_curricular = tp.id_componente_curricular inner join disciplina on disciplina.id_disciplina = cc.id_disciplina where tp.id_turma = turma.id_turma and disciplina.id_area_conhecimento_gestao = apontamento.id_area_conhecimento_gestao and tp.id_turma in (...) and tp.id_cidadao = ?) and exists ( select null from registro_lancamento_acompanhamento_atitudinal registro where registro.data_atualizacao > ? and registro.id_turma = apontamento.id_turma and registro.id_aluno_matricula = apontamento.id_aluno_matricula and registro.id_area_conhecimento_gestao = apontamento.id_area_conhecimento_gestao and registro.id_nota_periodo_aluno = apontamento.id_nota_periodo_aluno)) r;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 20 09 167 2m45s 991ms [ User: augeeducacional - Total duration: 2m45s - Times executed: 167 ]
[ Application: augeeducacional - principal - Total duration: 2m45s - Times executed: 167 ]
-
select json_agg(r.*)::text as r from ( select apontamento.id_aluno_matricula, apontamento.id_turma, apontamento.id_area_conhecimento_gestao, apontamento.id_nota_periodo_aluno, apontamento.id_eixo_modelo_avaliacao_desc, apontamento.id_opcao_eixo_modelo_aval, apontamento.expressao_aval_livre, apontamento.valor_numerico, apontamento.id_area_conhecimento_gestao from apontamento_acompanhamento_atitudinal apontamento inner join turma on turma.id_turma = apontamento.id_turma where turma.id_turma_status = 1 and turma.flg_organizada is true and exists ( select null from turma_professor tp inner join componente_curricular cc on cc.id_componente_curricular = tp.id_componente_curricular inner join disciplina on disciplina.id_disciplina = cc.id_disciplina where tp.id_turma = turma.id_turma and disciplina.id_area_conhecimento_gestao = apontamento.id_area_conhecimento_gestao and tp.id_turma in ('210020820', '210020821', '210020822', '210020823', '210020828', '210020824', '210020825', '210020826', '210020827') and tp.id_cidadao = '2628899') and exists ( select null from registro_lancamento_acompanhamento_atitudinal registro where registro.data_atualizacao > '2021-09-16 17:14:04.502' and registro.id_turma = apontamento.id_turma and registro.id_aluno_matricula = apontamento.id_aluno_matricula and registro.id_area_conhecimento_gestao = apontamento.id_area_conhecimento_gestao and registro.id_nota_periodo_aluno = apontamento.id_nota_periodo_aluno)) r;
Date: 2021-09-20 09:16:08 Duration: 5s113ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select json_agg(r.*)::text as r from ( select apontamento.id_aluno_matricula, apontamento.id_turma, apontamento.id_area_conhecimento_gestao, apontamento.id_nota_periodo_aluno, apontamento.id_eixo_modelo_avaliacao_desc, apontamento.id_opcao_eixo_modelo_aval, apontamento.expressao_aval_livre, apontamento.valor_numerico, apontamento.id_area_conhecimento_gestao from apontamento_acompanhamento_atitudinal apontamento inner join turma on turma.id_turma = apontamento.id_turma where turma.id_turma_status = 1 and turma.flg_organizada is true and exists ( select null from turma_professor tp inner join componente_curricular cc on cc.id_componente_curricular = tp.id_componente_curricular inner join disciplina on disciplina.id_disciplina = cc.id_disciplina where tp.id_turma = turma.id_turma and disciplina.id_area_conhecimento_gestao = apontamento.id_area_conhecimento_gestao and tp.id_turma in ('210006981', '210006976', '210006977', '210006978', '210006973', '210006974', '210006975') and tp.id_cidadao = '2631704') and exists ( select null from registro_lancamento_acompanhamento_atitudinal registro where registro.data_atualizacao > '2021-09-16 09:21:38.9' and registro.id_turma = apontamento.id_turma and registro.id_aluno_matricula = apontamento.id_aluno_matricula and registro.id_area_conhecimento_gestao = apontamento.id_area_conhecimento_gestao and registro.id_nota_periodo_aluno = apontamento.id_nota_periodo_aluno)) r;
Date: 2021-09-20 09:02:35 Duration: 4s801ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select json_agg(r.*)::text as r from ( select apontamento.id_aluno_matricula, apontamento.id_turma, apontamento.id_area_conhecimento_gestao, apontamento.id_nota_periodo_aluno, apontamento.id_eixo_modelo_avaliacao_desc, apontamento.id_opcao_eixo_modelo_aval, apontamento.expressao_aval_livre, apontamento.valor_numerico, apontamento.id_area_conhecimento_gestao from apontamento_acompanhamento_atitudinal apontamento inner join turma on turma.id_turma = apontamento.id_turma where turma.id_turma_status = 1 and turma.flg_organizada is true and exists ( select null from turma_professor tp inner join componente_curricular cc on cc.id_componente_curricular = tp.id_componente_curricular inner join disciplina on disciplina.id_disciplina = cc.id_disciplina where tp.id_turma = turma.id_turma and disciplina.id_area_conhecimento_gestao = apontamento.id_area_conhecimento_gestao and tp.id_turma in ('210038612', '210005269', '210038608', '210000881', '210038611', '210001004', '210001005', '210001000', '210001001', '210001002', '210000875', '210001003') and tp.id_cidadao = '6803761') and exists ( select null from registro_lancamento_acompanhamento_atitudinal registro where registro.data_atualizacao > '2021-09-16 19:30:18.606' and registro.id_turma = apontamento.id_turma and registro.id_aluno_matricula = apontamento.id_aluno_matricula and registro.id_area_conhecimento_gestao = apontamento.id_area_conhecimento_gestao and registro.id_nota_periodo_aluno = apontamento.id_nota_periodo_aluno)) r;
Date: 2021-09-20 09:10:25 Duration: 4s669ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
13 166 2m44s 321ms 5s850ms 990ms select json_agg(r.*)::text as r from ( select apontamento.id_turma, apontamento.id_area_conhecimento_gestao, apontamento.id_aluno_matricula, apontamento.id_nota_periodo_aluno, apontamento.id_eixo_modelo_avaliacao_desc, case when apontamento.opcoes_eixo_modelo_aval is not null then opcao_eixo else apontamento.id_opcao_eixo_modelo_aval end as id_opcao_eixo_modelo_aval from ( select apontamento.id_turma, apontamento.id_area_conhecimento_gestao, apontamento.id_aluno_matricula, apontamento.id_nota_periodo_aluno, apontamento.id_eixo_modelo_avaliacao_desc, apontamento.opcoes_eixo_modelo_aval, apontamento.id_opcao_eixo_modelo_aval from apontamento_acompanhamento_atitudinal apontamento inner join turma on turma.id_turma = apontamento.id_turma where turma.id_turma_status = ? and turma.flg_organizada is true and (apontamento.opcoes_eixo_modelo_aval is not null or apontamento.id_opcao_eixo_modelo_aval is not null) and exists ( select null from turma_professor tp inner join componente_curricular cc on cc.id_componente_curricular = tp.id_componente_curricular inner join disciplina on disciplina.id_disciplina = cc.id_disciplina where tp.id_turma = turma.id_turma and disciplina.id_area_conhecimento_gestao = apontamento.id_area_conhecimento_gestao and tp.id_turma in (...) and tp.id_cidadao = ?) and exists ( select null from registro_lancamento_acompanhamento_atitudinal registro where registro.data_atualizacao > ? and registro.id_turma = apontamento.id_turma and registro.id_aluno_matricula = apontamento.id_aluno_matricula and registro.id_area_conhecimento_gestao = apontamento.id_area_conhecimento_gestao and registro.id_nota_periodo_aluno = apontamento.id_nota_periodo_aluno)) as apontamento left join unnest(apontamento.opcoes_eixo_modelo_aval) as opcao_eixo on apontamento.opcoes_eixo_modelo_aval is not null) r;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 20 09 166 2m44s 990ms [ User: augeeducacional - Total duration: 2m44s - Times executed: 166 ]
[ Application: augeeducacional - principal - Total duration: 2m44s - Times executed: 166 ]
-
select json_agg(r.*)::text as r from ( select apontamento.id_turma, apontamento.id_area_conhecimento_gestao, apontamento.id_aluno_matricula, apontamento.id_nota_periodo_aluno, apontamento.id_eixo_modelo_avaliacao_desc, case when apontamento.opcoes_eixo_modelo_aval is not null then opcao_eixo else apontamento.id_opcao_eixo_modelo_aval end as id_opcao_eixo_modelo_aval from ( select apontamento.id_turma, apontamento.id_area_conhecimento_gestao, apontamento.id_aluno_matricula, apontamento.id_nota_periodo_aluno, apontamento.id_eixo_modelo_avaliacao_desc, apontamento.opcoes_eixo_modelo_aval, apontamento.id_opcao_eixo_modelo_aval from apontamento_acompanhamento_atitudinal apontamento inner join turma on turma.id_turma = apontamento.id_turma where turma.id_turma_status = 1 and turma.flg_organizada is true and (apontamento.opcoes_eixo_modelo_aval is not null or apontamento.id_opcao_eixo_modelo_aval is not null) and exists ( select null from turma_professor tp inner join componente_curricular cc on cc.id_componente_curricular = tp.id_componente_curricular inner join disciplina on disciplina.id_disciplina = cc.id_disciplina where tp.id_turma = turma.id_turma and disciplina.id_area_conhecimento_gestao = apontamento.id_area_conhecimento_gestao and tp.id_turma in ('210020820', '210020821', '210020822', '210020823', '210020828', '210020824', '210020825', '210020826', '210020827') and tp.id_cidadao = '2628899') and exists ( select null from registro_lancamento_acompanhamento_atitudinal registro where registro.data_atualizacao > '2021-09-16 17:14:04.502' and registro.id_turma = apontamento.id_turma and registro.id_aluno_matricula = apontamento.id_aluno_matricula and registro.id_area_conhecimento_gestao = apontamento.id_area_conhecimento_gestao and registro.id_nota_periodo_aluno = apontamento.id_nota_periodo_aluno)) as apontamento left join unnest(apontamento.opcoes_eixo_modelo_aval) as opcao_eixo on apontamento.opcoes_eixo_modelo_aval is not null) r;
Date: 2021-09-20 09:16:14 Duration: 5s850ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select json_agg(r.*)::text as r from ( select apontamento.id_turma, apontamento.id_area_conhecimento_gestao, apontamento.id_aluno_matricula, apontamento.id_nota_periodo_aluno, apontamento.id_eixo_modelo_avaliacao_desc, case when apontamento.opcoes_eixo_modelo_aval is not null then opcao_eixo else apontamento.id_opcao_eixo_modelo_aval end as id_opcao_eixo_modelo_aval from ( select apontamento.id_turma, apontamento.id_area_conhecimento_gestao, apontamento.id_aluno_matricula, apontamento.id_nota_periodo_aluno, apontamento.id_eixo_modelo_avaliacao_desc, apontamento.opcoes_eixo_modelo_aval, apontamento.id_opcao_eixo_modelo_aval from apontamento_acompanhamento_atitudinal apontamento inner join turma on turma.id_turma = apontamento.id_turma where turma.id_turma_status = 1 and turma.flg_organizada is true and (apontamento.opcoes_eixo_modelo_aval is not null or apontamento.id_opcao_eixo_modelo_aval is not null) and exists ( select null from turma_professor tp inner join componente_curricular cc on cc.id_componente_curricular = tp.id_componente_curricular inner join disciplina on disciplina.id_disciplina = cc.id_disciplina where tp.id_turma = turma.id_turma and disciplina.id_area_conhecimento_gestao = apontamento.id_area_conhecimento_gestao and tp.id_turma in ('210038612', '210005269', '210038608', '210000881', '210038611', '210001004', '210001005', '210001000', '210001001', '210001002', '210000875', '210001003') and tp.id_cidadao = '6803761') and exists ( select null from registro_lancamento_acompanhamento_atitudinal registro where registro.data_atualizacao > '2021-09-16 19:30:18.606' and registro.id_turma = apontamento.id_turma and registro.id_aluno_matricula = apontamento.id_aluno_matricula and registro.id_area_conhecimento_gestao = apontamento.id_area_conhecimento_gestao and registro.id_nota_periodo_aluno = apontamento.id_nota_periodo_aluno)) as apontamento left join unnest(apontamento.opcoes_eixo_modelo_aval) as opcao_eixo on apontamento.opcoes_eixo_modelo_aval is not null) r;
Date: 2021-09-20 09:10:30 Duration: 5s81ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select json_agg(r.*)::text as r from ( select apontamento.id_turma, apontamento.id_area_conhecimento_gestao, apontamento.id_aluno_matricula, apontamento.id_nota_periodo_aluno, apontamento.id_eixo_modelo_avaliacao_desc, case when apontamento.opcoes_eixo_modelo_aval is not null then opcao_eixo else apontamento.id_opcao_eixo_modelo_aval end as id_opcao_eixo_modelo_aval from ( select apontamento.id_turma, apontamento.id_area_conhecimento_gestao, apontamento.id_aluno_matricula, apontamento.id_nota_periodo_aluno, apontamento.id_eixo_modelo_avaliacao_desc, apontamento.opcoes_eixo_modelo_aval, apontamento.id_opcao_eixo_modelo_aval from apontamento_acompanhamento_atitudinal apontamento inner join turma on turma.id_turma = apontamento.id_turma where turma.id_turma_status = 1 and turma.flg_organizada is true and (apontamento.opcoes_eixo_modelo_aval is not null or apontamento.id_opcao_eixo_modelo_aval is not null) and exists ( select null from turma_professor tp inner join componente_curricular cc on cc.id_componente_curricular = tp.id_componente_curricular inner join disciplina on disciplina.id_disciplina = cc.id_disciplina where tp.id_turma = turma.id_turma and disciplina.id_area_conhecimento_gestao = apontamento.id_area_conhecimento_gestao and tp.id_turma in ('210006981', '210006976', '210006977', '210006978', '210006973', '210006974', '210006975') and tp.id_cidadao = '2631704') and exists ( select null from registro_lancamento_acompanhamento_atitudinal registro where registro.data_atualizacao > '2021-09-16 09:21:38.9' and registro.id_turma = apontamento.id_turma and registro.id_aluno_matricula = apontamento.id_aluno_matricula and registro.id_area_conhecimento_gestao = apontamento.id_area_conhecimento_gestao and registro.id_nota_periodo_aluno = apontamento.id_nota_periodo_aluno)) as apontamento left join unnest(apontamento.opcoes_eixo_modelo_aval) as opcao_eixo on apontamento.opcoes_eixo_modelo_aval is not null) r;
Date: 2021-09-20 09:02:40 Duration: 4s840ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
14 149 22s655ms 100ms 325ms 152ms select cast(count(qh.id_quadro_horario_homologado) as integer) as aulas from quadro_horario_homologado qh inner join componente_curricular cc on cc.id_componente_curricular = qh.id_componente_curricular inner join calendario_periodo_data on calendario_periodo_data.id_calendario = ? and calendario_periodo_data.dia_semana = qh.dia_semana left join calendario_data on calendario_data.id_calendario = calendario_periodo_data.id_calendario and calendario_data.data = calendario_periodo_data.data where qh.id_turma = ? and qh.id_serie = ? and cc.flg_aponta_faltas is true and calendario_periodo_data.bimestre between ? and ? and calendario_data.id_motivo_dia_nao_letivo is null and (qh.data_inicio_vigencia is null or qh.data_inicio_vigencia <= calendario_periodo_data.data) and (qh.data_termino_vigencia is null or qh.data_termino_vigencia >= calendario_periodo_data.data) and not exists ( select null from aluno_matr_dispensa_disciplina dispensa where dispensa.id_aluno_matricula = ? and dispensa.id_turma = ? and dispensa.id_disciplina = cc.id_disciplina and (dispensa.flg_dispensado_todos_periodos is true or dispensa.periodos @> array[?]));Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 20 09 149 22s655ms 152ms [ User: augeeducacional - Total duration: 22s655ms - Times executed: 149 ]
[ Application: augeeducacional - principal - Total duration: 22s655ms - Times executed: 149 ]
-
select cast(count(qh.id_quadro_horario_homologado) as integer) as aulas from quadro_horario_homologado qh inner join componente_curricular cc on cc.id_componente_curricular = qh.id_componente_curricular inner join calendario_periodo_data on calendario_periodo_data.id_calendario = '18673' and calendario_periodo_data.dia_semana = qh.dia_semana left join calendario_data on calendario_data.id_calendario = calendario_periodo_data.id_calendario and calendario_data.data = calendario_periodo_data.data where qh.id_turma = '210005060' and qh.id_serie = '1466' and cc.flg_aponta_faltas is true and calendario_periodo_data.bimestre between '1' and '1' and calendario_data.id_motivo_dia_nao_letivo is null and (qh.data_inicio_vigencia is null or qh.data_inicio_vigencia <= calendario_periodo_data.data) and (qh.data_termino_vigencia is null or qh.data_termino_vigencia >= calendario_periodo_data.data) and not exists ( select null from aluno_matr_dispensa_disciplina dispensa where dispensa.id_aluno_matricula = '9832328' and dispensa.id_turma = '210005060' and dispensa.id_disciplina = cc.id_disciplina and (dispensa.flg_dispensado_todos_periodos is true or dispensa.periodos @> ARRAY['1']));
Date: 2021-09-20 09:02:10 Duration: 325ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select cast(count(qh.id_quadro_horario_homologado) as integer) as aulas from quadro_horario_homologado qh inner join componente_curricular cc on cc.id_componente_curricular = qh.id_componente_curricular inner join calendario_periodo_data on calendario_periodo_data.id_calendario = '16948' and calendario_periodo_data.dia_semana = qh.dia_semana left join calendario_data on calendario_data.id_calendario = calendario_periodo_data.id_calendario and calendario_data.data = calendario_periodo_data.data where qh.id_turma = '200022497' and qh.id_serie = '1909' and cc.flg_aponta_faltas is true and calendario_periodo_data.bimestre between '1' and '1' and calendario_data.id_motivo_dia_nao_letivo is null and (qh.data_inicio_vigencia is null or qh.data_inicio_vigencia <= calendario_periodo_data.data) and (qh.data_termino_vigencia is null or qh.data_termino_vigencia >= calendario_periodo_data.data) and not exists ( select null from aluno_matr_dispensa_disciplina dispensa where dispensa.id_aluno_matricula = '9464631' and dispensa.id_turma = '200022497' and dispensa.id_disciplina = cc.id_disciplina and (dispensa.flg_dispensado_todos_periodos is true or dispensa.periodos @> ARRAY['1']));
Date: 2021-09-20 09:13:08 Duration: 319ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select cast(count(qh.id_quadro_horario_homologado) as integer) as aulas from quadro_horario_homologado qh inner join componente_curricular cc on cc.id_componente_curricular = qh.id_componente_curricular inner join calendario_periodo_data on calendario_periodo_data.id_calendario = '15960' and calendario_periodo_data.dia_semana = qh.dia_semana left join calendario_data on calendario_data.id_calendario = calendario_periodo_data.id_calendario and calendario_data.data = calendario_periodo_data.data where qh.id_turma = '190031594' and qh.id_serie = '1909' and cc.flg_aponta_faltas is true and calendario_periodo_data.bimestre between '1' and '1' and calendario_data.id_motivo_dia_nao_letivo is null and (qh.data_inicio_vigencia is null or qh.data_inicio_vigencia <= calendario_periodo_data.data) and (qh.data_termino_vigencia is null or qh.data_termino_vigencia >= calendario_periodo_data.data) and not exists ( select null from aluno_matr_dispensa_disciplina dispensa where dispensa.id_aluno_matricula = '8693263' and dispensa.id_turma = '190031594' and dispensa.id_disciplina = cc.id_disciplina and (dispensa.flg_dispensado_todos_periodos is true or dispensa.periodos @> ARRAY['1']));
Date: 2021-09-20 09:06:30 Duration: 297ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
15 146 1m13s 236ms 7s102ms 503ms select id_fila_trabalho, descricao_metodo, to_char(entrada_fila, ?) as entrada_fila, to_char(inicio_execucao, ?) as inicio_execucao, to_char(fim_execucao, ?) as fim_execucao, s.id_situacao_trabalho, s.nome as situacao, f.atributos ->> ? as content_type_arquivo, f.atributos ->> ? as extensao_arquivo from fila_trabalho.fila_trabalho f join fila_trabalho.situacao_trabalho s on s.id_situacao_trabalho = f.id_situacao_trabalho where f.id_instituicao = ? and f.id_situacao_trabalho <> ? and entrada_fila >= ? and entrada_fila < ? and f.usuarios @> array[?] order by f.entrada_fila desc limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 20 09 146 1m13s 503ms [ User: augeeducacional - Total duration: 1m13s - Times executed: 146 ]
[ Application: augeeducacional - principal - Total duration: 1m13s - Times executed: 146 ]
-
select id_fila_trabalho, descricao_metodo, to_char(entrada_fila, 'DD/MM/YYYY HH24:MI:SS') as entrada_fila, to_char(inicio_execucao, 'DD/MM/YYYY HH24:MI:SS') as inicio_execucao, to_char(fim_execucao, 'DD/MM/YYYY HH24:MI:SS') as fim_execucao, s.id_situacao_trabalho, s.nome as situacao, f.atributos ->> 'arquivoResultado.contentType' as content_type_arquivo, f.atributos ->> 'arquivoResultado.extensaoArquivo' as extensao_arquivo from fila_trabalho.fila_trabalho f join fila_trabalho.situacao_trabalho s on s.id_situacao_trabalho = f.id_situacao_trabalho where f.id_instituicao = '60' and f.id_situacao_trabalho <> '8' and entrada_fila >= '2021-09-20 00:00:00' and entrada_fila < '2021-09-21 00:00:00' and f.usuarios @> ARRAY['35659'] order by f.entrada_fila desc limit 10;
Date: 2021-09-20 09:02:05 Duration: 7s102ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select id_fila_trabalho, descricao_metodo, to_char(entrada_fila, 'DD/MM/YYYY HH24:MI:SS') as entrada_fila, to_char(inicio_execucao, 'DD/MM/YYYY HH24:MI:SS') as inicio_execucao, to_char(fim_execucao, 'DD/MM/YYYY HH24:MI:SS') as fim_execucao, s.id_situacao_trabalho, s.nome as situacao, f.atributos ->> 'arquivoResultado.contentType' as content_type_arquivo, f.atributos ->> 'arquivoResultado.extensaoArquivo' as extensao_arquivo from fila_trabalho.fila_trabalho f join fila_trabalho.situacao_trabalho s on s.id_situacao_trabalho = f.id_situacao_trabalho where f.id_instituicao = '60' and f.id_situacao_trabalho <> '8' and entrada_fila >= '2021-09-20 00:00:00' and entrada_fila < '2021-09-21 00:00:00' and f.usuarios @> ARRAY['43012'] order by f.entrada_fila desc limit 10;
Date: 2021-09-20 09:14:10 Duration: 679ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select id_fila_trabalho, descricao_metodo, to_char(entrada_fila, 'DD/MM/YYYY HH24:MI:SS') as entrada_fila, to_char(inicio_execucao, 'DD/MM/YYYY HH24:MI:SS') as inicio_execucao, to_char(fim_execucao, 'DD/MM/YYYY HH24:MI:SS') as fim_execucao, s.id_situacao_trabalho, s.nome as situacao, f.atributos ->> 'arquivoResultado.contentType' as content_type_arquivo, f.atributos ->> 'arquivoResultado.extensaoArquivo' as extensao_arquivo from fila_trabalho.fila_trabalho f join fila_trabalho.situacao_trabalho s on s.id_situacao_trabalho = f.id_situacao_trabalho where f.id_instituicao = '60' and f.id_situacao_trabalho <> '8' and entrada_fila >= '2021-09-20 00:00:00' and entrada_fila < '2021-09-21 00:00:00' and f.usuarios @> ARRAY['19580'] order by f.entrada_fila desc limit 10;
Date: 2021-09-20 09:15:37 Duration: 673ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
16 146 54s913ms 237ms 655ms 376ms select count(*) as contagem from ( select id_fila_trabalho, descricao_metodo, to_char(entrada_fila, ?) as entrada_fila, to_char(inicio_execucao, ?) as inicio_execucao, to_char(fim_execucao, ?) as fim_execucao, s.id_situacao_trabalho, s.nome as situacao, f.atributos ->> ? as content_type_arquivo, f.atributos ->> ? as extensao_arquivo from fila_trabalho.fila_trabalho f join fila_trabalho.situacao_trabalho s on s.id_situacao_trabalho = f.id_situacao_trabalho where f.id_instituicao = ? and f.id_situacao_trabalho <> ? and entrada_fila >= ? and entrada_fila < ? and f.usuarios @> array[?] order by f.entrada_fila desc) tabela;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 20 09 146 54s913ms 376ms [ User: augeeducacional - Total duration: 54s913ms - Times executed: 146 ]
[ Application: augeeducacional - principal - Total duration: 54s913ms - Times executed: 146 ]
-
select count(*) as contagem from ( select id_fila_trabalho, descricao_metodo, to_char(entrada_fila, 'DD/MM/YYYY HH24:MI:SS') as entrada_fila, to_char(inicio_execucao, 'DD/MM/YYYY HH24:MI:SS') as inicio_execucao, to_char(fim_execucao, 'DD/MM/YYYY HH24:MI:SS') as fim_execucao, s.id_situacao_trabalho, s.nome as situacao, f.atributos ->> 'arquivoResultado.contentType' as content_type_arquivo, f.atributos ->> 'arquivoResultado.extensaoArquivo' as extensao_arquivo from fila_trabalho.fila_trabalho f join fila_trabalho.situacao_trabalho s on s.id_situacao_trabalho = f.id_situacao_trabalho where f.id_instituicao = '60' and f.id_situacao_trabalho <> '8' and entrada_fila >= '2021-09-20 00:00:00' and entrada_fila < '2021-09-21 00:00:00' and f.usuarios @> ARRAY['43012'] order by f.entrada_fila desc) tabela;
Date: 2021-09-20 09:14:10 Duration: 655ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select count(*) as contagem from ( select id_fila_trabalho, descricao_metodo, to_char(entrada_fila, 'DD/MM/YYYY HH24:MI:SS') as entrada_fila, to_char(inicio_execucao, 'DD/MM/YYYY HH24:MI:SS') as inicio_execucao, to_char(fim_execucao, 'DD/MM/YYYY HH24:MI:SS') as fim_execucao, s.id_situacao_trabalho, s.nome as situacao, f.atributos ->> 'arquivoResultado.contentType' as content_type_arquivo, f.atributos ->> 'arquivoResultado.extensaoArquivo' as extensao_arquivo from fila_trabalho.fila_trabalho f join fila_trabalho.situacao_trabalho s on s.id_situacao_trabalho = f.id_situacao_trabalho where f.id_instituicao = '60' and f.id_situacao_trabalho <> '8' and entrada_fila >= '2021-09-20 00:00:00' and entrada_fila < '2021-09-21 00:00:00' and f.usuarios @> ARRAY['19029'] order by f.entrada_fila desc) tabela;
Date: 2021-09-20 09:05:42 Duration: 640ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select count(*) as contagem from ( select id_fila_trabalho, descricao_metodo, to_char(entrada_fila, 'DD/MM/YYYY HH24:MI:SS') as entrada_fila, to_char(inicio_execucao, 'DD/MM/YYYY HH24:MI:SS') as inicio_execucao, to_char(fim_execucao, 'DD/MM/YYYY HH24:MI:SS') as fim_execucao, s.id_situacao_trabalho, s.nome as situacao, f.atributos ->> 'arquivoResultado.contentType' as content_type_arquivo, f.atributos ->> 'arquivoResultado.extensaoArquivo' as extensao_arquivo from fila_trabalho.fila_trabalho f join fila_trabalho.situacao_trabalho s on s.id_situacao_trabalho = f.id_situacao_trabalho where f.id_instituicao = '60' and f.id_situacao_trabalho <> '8' and entrada_fila >= '2021-09-20 00:00:00' and entrada_fila < '2021-09-21 00:00:00' and f.usuarios @> ARRAY['22904'] order by f.entrada_fila desc) tabela;
Date: 2021-09-20 09:04:19 Duration: 633ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
17 146 21s91ms 100ms 427ms 144ms select sum(falta_nao_justificada) from falta_aluno_disciplina fad where id_nota_periodo_aluno = ? and id_aluno_matricula = ? and id_turma = ? and not exists ( select null from aluno_matr_dispensa_disciplina dispensa where dispensa.id_aluno_matricula = ? and dispensa.id_turma = ? and dispensa.id_disciplina = fad.id_disciplina and (dispensa.flg_dispensado_todos_periodos is true or dispensa.periodos @> array[?]));Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 20 09 146 21s91ms 144ms [ User: augeeducacional - Total duration: 21s91ms - Times executed: 146 ]
[ Application: augeeducacional - principal - Total duration: 21s91ms - Times executed: 146 ]
-
select sum(falta_nao_justificada) from falta_aluno_disciplina fad where id_nota_periodo_aluno = '1' and id_aluno_matricula = '9719572' and id_turma = '210001353' and not exists ( select null from aluno_matr_dispensa_disciplina dispensa where dispensa.id_aluno_matricula = '9719572' and dispensa.id_turma = '210001353' and dispensa.id_disciplina = fad.id_disciplina and (dispensa.flg_dispensado_todos_periodos is true or dispensa.periodos @> ARRAY['1']));
Date: 2021-09-20 09:16:47 Duration: 427ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select sum(falta_nao_justificada) from falta_aluno_disciplina fad where id_nota_periodo_aluno = '1' and id_aluno_matricula = '9839983' and id_turma = '210014768' and not exists ( select null from aluno_matr_dispensa_disciplina dispensa where dispensa.id_aluno_matricula = '9839983' and dispensa.id_turma = '210014768' and dispensa.id_disciplina = fad.id_disciplina and (dispensa.flg_dispensado_todos_periodos is true or dispensa.periodos @> ARRAY['1']));
Date: 2021-09-20 09:04:56 Duration: 427ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select sum(falta_nao_justificada) from falta_aluno_disciplina fad where id_nota_periodo_aluno = '1' and id_aluno_matricula = '8561668' and id_turma = '190037939' and not exists ( select null from aluno_matr_dispensa_disciplina dispensa where dispensa.id_aluno_matricula = '8561668' and dispensa.id_turma = '190037939' and dispensa.id_disciplina = fad.id_disciplina and (dispensa.flg_dispensado_todos_periodos is true or dispensa.periodos @> ARRAY['1']));
Date: 2021-09-20 09:13:47 Duration: 364ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
18 130 2m23s 100ms 4s329ms 1s100ms select json_agg(r.*)::text as r from ( select nota.id_turma, nota.id_aluno_matricula, nota.id_disciplina, nota.id_nota_periodo_aluno, nota.id_atividade_avaliativa, nota.nota, nota.nota_recuperacao, nota.flg_nao_compareceu, nota.flg_nao_compareceu_rp from nota_aluno_atividade nota inner join turma on turma.id_turma = nota.id_turma where turma.id_turma_status = ? and turma.flg_organizada is true and nota.id_turma in (...) and exists ( select null from registro_lancamento_nota_disciplina registro where registro.data_ref_sincronizacao > ? and registro.id_turma = nota.id_turma and registro.id_disciplina = nota.id_disciplina and registro.id_nota_periodo_aluno = nota.id_nota_periodo_aluno) and exists ( select null from turma_professor tp inner join componente_curricular cc on cc.id_componente_curricular = tp.id_componente_curricular where tp.id_cidadao = ? and tp.id_turma in (...) and cc.id_disciplina = nota.id_disciplina)) r;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 20 09 130 2m23s 1s100ms [ User: augeeducacional - Total duration: 2m23s - Times executed: 130 ]
[ Application: augeeducacional - principal - Total duration: 2m23s - Times executed: 130 ]
-
select json_agg(r.*)::text as r from ( select nota.id_turma, nota.id_aluno_matricula, nota.id_disciplina, nota.id_nota_periodo_aluno, nota.id_atividade_avaliativa, nota.nota, nota.nota_recuperacao, nota.flg_nao_compareceu, nota.flg_nao_compareceu_rp from nota_aluno_atividade nota inner join turma on turma.id_turma = nota.id_turma where turma.id_turma_status = 1 and turma.flg_organizada is true and nota.id_turma in ('210005743', '210005745', '210005746', '210005747', '210033679', '210033680', '210033682', '210033683', '210033684', '210033687', '210033688', '210033689', '210033690', '210033691') and exists ( select null from registro_lancamento_nota_disciplina registro where registro.data_ref_sincronizacao > '2021-09-18 20:43:55.647' and registro.id_turma = nota.id_turma and registro.id_disciplina = nota.id_disciplina and registro.id_nota_periodo_aluno = nota.id_nota_periodo_aluno) and exists ( select null from turma_professor tp inner join componente_curricular cc on cc.id_componente_curricular = tp.id_componente_curricular where tp.id_cidadao = '2640863' and tp.id_turma in ('210005743', '210005745', '210005746', '210005747', '210033679', '210033680', '210033682', '210033683', '210033684', '210033687', '210033688', '210033689', '210033690', '210033691') and cc.id_disciplina = nota.id_disciplina)) r;
Date: 2021-09-20 09:15:22 Duration: 4s329ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select json_agg(r.*)::text as r from ( select nota.id_turma, nota.id_aluno_matricula, nota.id_disciplina, nota.id_nota_periodo_aluno, nota.id_atividade_avaliativa, nota.nota, nota.nota_recuperacao, nota.flg_nao_compareceu, nota.flg_nao_compareceu_rp from nota_aluno_atividade nota inner join turma on turma.id_turma = nota.id_turma where turma.id_turma_status = 1 and turma.flg_organizada is true and nota.id_turma in ('210000328', '210000332', '210000333', '210000334', '210000335', '210000336', '210000338', '210000339', '210000342', '210000343', '210000358', '210000359') and exists ( select null from registro_lancamento_nota_disciplina registro where registro.data_ref_sincronizacao > '2021-09-14 21:45:55.865' and registro.id_turma = nota.id_turma and registro.id_disciplina = nota.id_disciplina and registro.id_nota_periodo_aluno = nota.id_nota_periodo_aluno) and exists ( select null from turma_professor tp inner join componente_curricular cc on cc.id_componente_curricular = tp.id_componente_curricular where tp.id_cidadao = '5499767' and tp.id_turma in ('210000328', '210000332', '210000333', '210000334', '210000335', '210000336', '210000338', '210000339', '210000342', '210000343', '210000358', '210000359') and cc.id_disciplina = nota.id_disciplina)) r;
Date: 2021-09-20 09:18:00 Duration: 3s627ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select json_agg(r.*)::text as r from ( select nota.id_turma, nota.id_aluno_matricula, nota.id_disciplina, nota.id_nota_periodo_aluno, nota.id_atividade_avaliativa, nota.nota, nota.nota_recuperacao, nota.flg_nao_compareceu, nota.flg_nao_compareceu_rp from nota_aluno_atividade nota inner join turma on turma.id_turma = nota.id_turma where turma.id_turma_status = 1 and turma.flg_organizada is true and nota.id_turma in ('200045532', '210007080', '210007100', '210007101', '210007103', '210007159', '210007160', '210007161', '210007162', '210007163', '210007368') and exists ( select null from registro_lancamento_nota_disciplina registro where registro.data_ref_sincronizacao > '2021-09-18 11:37:36.009' and registro.id_turma = nota.id_turma and registro.id_disciplina = nota.id_disciplina and registro.id_nota_periodo_aluno = nota.id_nota_periodo_aluno) and exists ( select null from turma_professor tp inner join componente_curricular cc on cc.id_componente_curricular = tp.id_componente_curricular where tp.id_cidadao = '6670259' and tp.id_turma in ('200045532', '210007080', '210007100', '210007101', '210007103', '210007159', '210007160', '210007161', '210007162', '210007163', '210007368') and cc.id_disciplina = nota.id_disciplina)) r;
Date: 2021-09-20 09:07:28 Duration: 3s326ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
19 126 3m32s 219ms 8s292ms 1s686ms select json_agg(r.*)::text as r from ( select sda.id_situacao_didatica_aula, sda.id_turma, sda.id_serie, sda.id_componente_curricular, sda.data, sda.id_horario_turma, sda.numero_aula, sda.data_atualizacao from situacao_didatica_aula sda inner join componente_curricular on componente_curricular.id_componente_curricular = sda.id_componente_curricular where sda.id_turma in (...) and exists ( select null from turma_professor tp where tp.id_cidadao = ? and tp.id_turma = sda.id_turma and componente_curricular.id_componente_curricular = tp.id_componente_curricular) and exists ( select null from registro_lancamento_conteudo_diario registro_lancamento where registro_lancamento.id_turma = sda.id_turma and registro_lancamento.id_componente_curricular = sda.id_componente_curricular and registro_lancamento.data_referencia = sda.data and registro_lancamento.data_atualizacao > ?)) r;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 20 09 126 3m32s 1s686ms [ User: augeeducacional - Total duration: 3m32s - Times executed: 126 ]
[ Application: augeeducacional - principal - Total duration: 3m32s - Times executed: 126 ]
-
select json_agg(r.*)::text as r from ( select sda.id_situacao_didatica_aula, sda.id_turma, sda.id_serie, sda.id_componente_curricular, sda.data, sda.id_horario_turma, sda.numero_aula, sda.data_atualizacao from situacao_didatica_aula sda inner join componente_curricular on componente_curricular.id_componente_curricular = sda.id_componente_curricular where sda.id_turma in ('210007052', '210007053', '210007054', '210007055', '210007056', '210007057', '210007058', '210007059', '210007060', '210007061', '210007062', '210007617', '210007618', '210007619', '210007620', '210007621', '210007622', '210007623', '210007624', '210007626', '210007628', '210007629', '210007630', '210008977') and exists ( select null from turma_professor tp where tp.id_cidadao = '6369256' and tp.id_turma = sda.id_turma and componente_curricular.id_componente_curricular = tp.id_componente_curricular) and exists ( select null from registro_lancamento_conteudo_diario registro_lancamento where registro_lancamento.id_turma = sda.id_turma and registro_lancamento.id_componente_curricular = sda.id_componente_curricular and registro_lancamento.data_referencia = sda.data and registro_lancamento.data_atualizacao > '2021-09-18 15:45:45.604')) r;
Date: 2021-09-20 09:17:06 Duration: 8s292ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select json_agg(r.*)::text as r from ( select sda.id_situacao_didatica_aula, sda.id_turma, sda.id_serie, sda.id_componente_curricular, sda.data, sda.id_horario_turma, sda.numero_aula, sda.data_atualizacao from situacao_didatica_aula sda inner join componente_curricular on componente_curricular.id_componente_curricular = sda.id_componente_curricular where sda.id_turma in ('210000492', '210000493', '210000494', '210000495', '210000496', '210000497', '210000498', '210001210') and exists ( select null from turma_professor tp where tp.id_cidadao = '5006929' and tp.id_turma = sda.id_turma and componente_curricular.id_componente_curricular = tp.id_componente_curricular) and exists ( select null from registro_lancamento_conteudo_diario registro_lancamento where registro_lancamento.id_turma = sda.id_turma and registro_lancamento.id_componente_curricular = sda.id_componente_curricular and registro_lancamento.data_referencia = sda.data and registro_lancamento.data_atualizacao > '2021-09-17 15:42:44.552')) r;
Date: 2021-09-20 09:18:01 Duration: 4s581ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select json_agg(r.*)::text as r from ( select sda.id_situacao_didatica_aula, sda.id_turma, sda.id_serie, sda.id_componente_curricular, sda.data, sda.id_horario_turma, sda.numero_aula, sda.data_atualizacao from situacao_didatica_aula sda inner join componente_curricular on componente_curricular.id_componente_curricular = sda.id_componente_curricular where sda.id_turma in ('210006933', '210006934', '210006935', '210006936', '210006937', '210006938', '210006939', '210006940', '210006942', '210006943', '210006945', '210006946', '210008001', '210008108', '210040250', '210040252', '210040253', '210041414') and exists ( select null from turma_professor tp where tp.id_cidadao = '2638887' and tp.id_turma = sda.id_turma and componente_curricular.id_componente_curricular = tp.id_componente_curricular) and exists ( select null from registro_lancamento_conteudo_diario registro_lancamento where registro_lancamento.id_turma = sda.id_turma and registro_lancamento.id_componente_curricular = sda.id_componente_curricular and registro_lancamento.data_referencia = sda.data and registro_lancamento.data_atualizacao > '2021-09-18 20:07:32.05')) r;
Date: 2021-09-20 09:07:23 Duration: 4s291ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
20 121 21s783ms 101ms 497ms 180ms select uf.nome as nome, uf.codigo as codigo, uf.id_unidade_funcional from unidade_funcional uf inner join unidade_interna ui on ui.id_unidade_funcional = uf.id_unidade_funcional where uf.id_nivel_unidade_funcional = ? and ui.id_unidade_interna_situacao <> ? and uf.id_unidade_funcional in ( select t.id_unidade_funcional from turma t inner join turma_professor tp on tp.id_turma = t.id_turma inner join cidadao_usuario on cidadao_usuario.id_cidadao = tp.id_cidadao where cidadao_usuario.id_usuario = ? union select tc.id_unidade_funcional from turma_componente tc inner join turma_componente_historico tch on tc.id_turma_componente = tch.id_turma_componente inner join cidadao_usuario cu on cu.id_cidadao = tch.id_cidadao where cu.id_usuario = ? and tch.id_atrib_motivo_disp = ? union all select tra.id_unidade_funcional from turma_regencia_atribuicao tra inner join turma_regencia_atrib_hist trah on tra.id_turma_regencia_atribuicao = trah.id_turma_regencia_atribuicao inner join cidadao_usuario cu on cu.id_cidadao = trah.id_cidadao where cu.id_usuario = ? and trah.id_atrib_motivo_disp = ?) union select uf.nome as nome, uf.codigo as codigo, uf.id_unidade_funcional from unidade_funcional uf inner join unidade_interna ui on ui.id_unidade_funcional = uf.id_unidade_funcional where uf.id_nivel_unidade_funcional = ? and ui.id_unidade_interna_situacao <> ? and exists ( select null from perfil_extendido pe inner join grupo_usuario gu on pe.id_grupo_usuario = gu.id_grupo_usuario inner join permissao_acesso pa on pa.id_grupo_usuario = gu.id_grupo_usuario and pa.id_recurso = ? where pe.id_usuario = ? and pe.id_unidade_funcional = uf.id_unidade_funcional and pe.id_assunto_hierarquia_unidade = ?) order by nome;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 20 09 121 21s783ms 180ms [ User: augeeducacional - Total duration: 21s783ms - Times executed: 121 ]
[ Application: augeeducacional - principal - Total duration: 21s783ms - Times executed: 121 ]
-
select uf.nome as nome, uf.codigo as codigo, uf.id_unidade_funcional from unidade_funcional uf inner join unidade_interna ui on ui.id_unidade_funcional = uf.id_unidade_funcional where uf.id_nivel_unidade_funcional = 3 and ui.id_unidade_interna_situacao <> 3 and uf.id_unidade_funcional in ( select t.id_unidade_funcional from turma t inner join turma_professor tp on tp.id_turma = t.id_turma inner join cidadao_usuario on cidadao_usuario.id_cidadao = tp.id_cidadao where cidadao_usuario.id_usuario = '57745' union select tc.id_unidade_funcional from turma_componente tc inner join turma_componente_historico tch on tc.id_turma_componente = tch.id_turma_componente inner join cidadao_usuario cu on cu.id_cidadao = tch.id_cidadao where cu.id_usuario = '57745' and tch.id_atrib_motivo_disp = 4 union all select tra.id_unidade_funcional from turma_regencia_atribuicao tra inner join turma_regencia_atrib_hist trah on tra.id_turma_regencia_atribuicao = trah.id_turma_regencia_atribuicao inner join cidadao_usuario cu on cu.id_cidadao = trah.id_cidadao where cu.id_usuario = '57745' and trah.id_atrib_motivo_disp = 4) union select uf.nome as nome, uf.codigo as codigo, uf.id_unidade_funcional from unidade_funcional uf inner join unidade_interna ui on ui.id_unidade_funcional = uf.id_unidade_funcional where uf.id_nivel_unidade_funcional = 3 and ui.id_unidade_interna_situacao <> 3 and exists ( select null from perfil_extendido pe inner join grupo_usuario gu on pe.id_grupo_usuario = gu.id_grupo_usuario inner join permissao_acesso pa on pa.id_grupo_usuario = gu.id_grupo_usuario and pa.id_recurso = '3083' where pe.id_usuario = '57745' and pe.id_unidade_funcional = uf.id_unidade_funcional and pe.id_assunto_hierarquia_unidade = '49') order by nome;
Date: 2021-09-20 09:03:35 Duration: 497ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select uf.nome as nome, uf.codigo as codigo, uf.id_unidade_funcional from unidade_funcional uf inner join unidade_interna ui on ui.id_unidade_funcional = uf.id_unidade_funcional where uf.id_nivel_unidade_funcional = 3 and ui.id_unidade_interna_situacao <> 3 and uf.id_unidade_funcional in ( select t.id_unidade_funcional from turma t inner join turma_professor tp on tp.id_turma = t.id_turma inner join cidadao_usuario on cidadao_usuario.id_cidadao = tp.id_cidadao where cidadao_usuario.id_usuario = '47458' union select tc.id_unidade_funcional from turma_componente tc inner join turma_componente_historico tch on tc.id_turma_componente = tch.id_turma_componente inner join cidadao_usuario cu on cu.id_cidadao = tch.id_cidadao where cu.id_usuario = '47458' and tch.id_atrib_motivo_disp = 4 union all select tra.id_unidade_funcional from turma_regencia_atribuicao tra inner join turma_regencia_atrib_hist trah on tra.id_turma_regencia_atribuicao = trah.id_turma_regencia_atribuicao inner join cidadao_usuario cu on cu.id_cidadao = trah.id_cidadao where cu.id_usuario = '47458' and trah.id_atrib_motivo_disp = 4) union select uf.nome as nome, uf.codigo as codigo, uf.id_unidade_funcional from unidade_funcional uf inner join unidade_interna ui on ui.id_unidade_funcional = uf.id_unidade_funcional where uf.id_nivel_unidade_funcional = 3 and ui.id_unidade_interna_situacao <> 3 and exists ( select null from perfil_extendido pe inner join grupo_usuario gu on pe.id_grupo_usuario = gu.id_grupo_usuario inner join permissao_acesso pa on pa.id_grupo_usuario = gu.id_grupo_usuario and pa.id_recurso = '3083' where pe.id_usuario = '47458' and pe.id_unidade_funcional = uf.id_unidade_funcional and pe.id_assunto_hierarquia_unidade = '49') order by nome;
Date: 2021-09-20 09:01:48 Duration: 492ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select uf.nome as nome, uf.codigo as codigo, uf.id_unidade_funcional from unidade_funcional uf inner join unidade_interna ui on ui.id_unidade_funcional = uf.id_unidade_funcional where uf.id_nivel_unidade_funcional = 3 and ui.id_unidade_interna_situacao <> 3 and uf.id_unidade_funcional in ( select t.id_unidade_funcional from turma t inner join turma_professor tp on tp.id_turma = t.id_turma inner join cidadao_usuario on cidadao_usuario.id_cidadao = tp.id_cidadao where cidadao_usuario.id_usuario = '56453' union select tc.id_unidade_funcional from turma_componente tc inner join turma_componente_historico tch on tc.id_turma_componente = tch.id_turma_componente inner join cidadao_usuario cu on cu.id_cidadao = tch.id_cidadao where cu.id_usuario = '56453' and tch.id_atrib_motivo_disp = 4 union all select tra.id_unidade_funcional from turma_regencia_atribuicao tra inner join turma_regencia_atrib_hist trah on tra.id_turma_regencia_atribuicao = trah.id_turma_regencia_atribuicao inner join cidadao_usuario cu on cu.id_cidadao = trah.id_cidadao where cu.id_usuario = '56453' and trah.id_atrib_motivo_disp = 4) union select uf.nome as nome, uf.codigo as codigo, uf.id_unidade_funcional from unidade_funcional uf inner join unidade_interna ui on ui.id_unidade_funcional = uf.id_unidade_funcional where uf.id_nivel_unidade_funcional = 3 and ui.id_unidade_interna_situacao <> 3 and exists ( select null from perfil_extendido pe inner join grupo_usuario gu on pe.id_grupo_usuario = gu.id_grupo_usuario inner join permissao_acesso pa on pa.id_grupo_usuario = gu.id_grupo_usuario and pa.id_recurso = '3083' where pe.id_usuario = '56453' and pe.id_unidade_funcional = uf.id_unidade_funcional and pe.id_assunto_hierarquia_unidade = '49') order by nome;
Date: 2021-09-20 09:03:42 Duration: 449ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 8m42s 8m42s 8m42s 1 8m42s copy aluno_lancamento.nota_aluno_atividade_legado (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, id_atividade_avaliativa, nota, nota_recuperacao, flg_nao_compareceu, flg_nao_compareceu_rp) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 20 04 1 8m42s 8m42s [ User: postgres - Total duration: 8m42s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 8m42s - Times executed: 1 ]
-
COPY aluno_lancamento.nota_aluno_atividade_legado (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, id_atividade_avaliativa, nota, nota_recuperacao, flg_nao_compareceu, flg_nao_compareceu_rp) TO stdout;
Date: 2021-09-20 04:07:08 Duration: 8m42s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
2 7m42s 7m42s 7m42s 1 7m42s copy public.planejamento_bimestral (id_turma, id_serie, id_disciplina, id_nota_periodo_aluno, aulas_previstas, aulas_dadas, justificativa, objetivo, conteudo_eixo_tematico, procedimento_metodologico, procedimento_avaliativo, flg_usa_calendario_oficial, flg_aprovacao_professor, flg_aprovacao_diretor, flg_aprovacao_secretario, habilidades_desenvolvidas, itinerario_formativo, data_inclusao, data_atualizacao, data_alteracao_planejamento, id_planejamento_unificado, uuid_pacote, bncc_competencia_especifica, bncc_unidade_tematica, bncc_objeto_conhecimento, bncc_conteudo, bncc_habilidade, bncc_procedimento_metodologico, bncc_procedimento_avaliativo) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 20 05 1 7m42s 7m42s [ User: postgres - Total duration: 7m42s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 7m42s - Times executed: 1 ]
-
COPY public.planejamento_bimestral (id_turma, id_serie, id_disciplina, id_nota_periodo_aluno, aulas_previstas, aulas_dadas, justificativa, objetivo, conteudo_eixo_tematico, procedimento_metodologico, procedimento_avaliativo, flg_usa_calendario_oficial, flg_aprovacao_professor, flg_aprovacao_diretor, flg_aprovacao_secretario, habilidades_desenvolvidas, itinerario_formativo, data_inclusao, data_atualizacao, data_alteracao_planejamento, id_planejamento_unificado, uuid_pacote, bncc_competencia_especifica, bncc_unidade_tematica, bncc_objeto_conhecimento, bncc_conteudo, bncc_habilidade, bncc_procedimento_metodologico, bncc_procedimento_avaliativo) TO stdout;
Date: 2021-09-20 05:45:25 Duration: 7m42s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
3 7m30s 7m30s 7m30s 1 7m30s copy aluno_lancamento.falta_aluno_disciplina_diario_2020 (id_falta_aluno_disciplina_diario, id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, data, id_horario_turma, flg_justificada, id_motivo_falta_justificada, descricao_motivo_falta_justificada) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 20 03 1 7m30s 7m30s [ User: postgres - Total duration: 7m30s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 7m30s - Times executed: 1 ]
-
COPY aluno_lancamento.falta_aluno_disciplina_diario_2020 (id_falta_aluno_disciplina_diario, id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, data, id_horario_turma, flg_justificada, id_motivo_falta_justificada, descricao_motivo_falta_justificada) TO stdout;
Date: 2021-09-20 03:31:09 Duration: 7m30s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
4 6m54s 6m54s 6m54s 1 6m54s select id_fila_trabalho, nome_fila, id_situacao_trabalho, (((regexp_replace(parametros::text, ?, ?, ?))::json) ->> ?)::integer as id_usuario from fila_trabalho.fila_trabalho where id_situacao_trabalho in (...) order by id_fila_trabalho;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 20 08 1 6m54s 6m54s [ User: augeeducacional - Total duration: 6m54s - Times executed: 1 ]
[ Application: augeeducacional - principal - Total duration: 6m54s - Times executed: 1 ]
-
select id_fila_trabalho, nome_fila, id_situacao_trabalho, (((regexp_replace(parametros::text, '\\u0000', '', 'g'))::json) ->> 'idUsuario')::integer as id_usuario from fila_trabalho.fila_trabalho where id_situacao_trabalho in ('1', '2') order by id_fila_trabalho;
Date: 2021-09-20 08:59:39 Duration: 6m54s Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
5 5m42s 5m42s 5m42s 1 5m42s copy public.conteudo_curricular_aula (id_conteudo_curricular_aula, id_situacao_didatica_aula, id_conteudo_curricular_componente, id_conteudo_analise_linguistica, id_situacao_didatica, descricao_situacao_didatica, conteudo_trab_situacao_didatica, data_realizacao, justificativa, complementacao_conteudo) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 20 05 1 5m42s 5m42s [ User: postgres - Total duration: 5m42s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 5m42s - Times executed: 1 ]
-
COPY public.conteudo_curricular_aula (id_conteudo_curricular_aula, id_situacao_didatica_aula, id_conteudo_curricular_componente, id_conteudo_analise_linguistica, id_situacao_didatica, descricao_situacao_didatica, conteudo_trab_situacao_didatica, data_realizacao, justificativa, complementacao_conteudo) TO stdout;
Date: 2021-09-20 05:30:46 Duration: 5m42s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
6 5m27s 5m27s 5m27s 1 5m27s copy indicador.consulta_dia (data, sql, media, min, max, execucoes) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 20 05 1 5m27s 5m27s [ User: postgres - Total duration: 5m27s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 5m27s - Times executed: 1 ]
-
COPY indicador.consulta_dia (data, sql, media, min, max, execucoes) TO stdout;
Date: 2021-09-20 05:02:18 Duration: 5m27s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
7 4m56s 4m56s 4m56s 1 4m56s copy public.registro_falta_disciplina_diario (id_turma, id_disciplina, data_inclusao, data_atualizacao, data_referencia, flg_concluido, flg_aplicativo_movel, data_ref_sincronizacao, id_usuario, uuid_pacote) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 20 05 1 4m56s 4m56s [ User: postgres - Total duration: 4m56s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 4m56s - Times executed: 1 ]
-
COPY public.registro_falta_disciplina_diario (id_turma, id_disciplina, data_inclusao, data_atualizacao, data_referencia, flg_concluido, flg_aplicativo_movel, data_ref_sincronizacao, id_usuario, uuid_pacote) TO stdout;
Date: 2021-09-20 05:51:28 Duration: 4m56s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
8 4m35s 4m35s 4m35s 1 4m35s copy public.situacao_didatica_aula (id_situacao_didatica_aula, id_turma, id_serie, id_componente_curricular, data, id_horario_turma, numero_aula, data_atualizacao, data_criacao, uuid_pacote) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 20 05 1 4m35s 4m35s [ User: postgres - Total duration: 4m35s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 4m35s - Times executed: 1 ]
-
COPY public.situacao_didatica_aula (id_situacao_didatica_aula, id_turma, id_serie, id_componente_curricular, data, id_horario_turma, numero_aula, data_atualizacao, data_criacao, uuid_pacote) TO stdout;
Date: 2021-09-20 05:58:33 Duration: 4m35s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
9 4m8s 4m8s 4m8s 1 4m8s copy aluno_lancamento.falta_aluno_disciplina_2017 (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, falta_justificada, falta_nao_justificada, qtd_faltas) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 20 03 1 4m8s 4m8s [ User: postgres - Total duration: 4m8s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 4m8s - Times executed: 1 ]
-
COPY aluno_lancamento.falta_aluno_disciplina_2017 (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, falta_justificada, falta_nao_justificada, qtd_faltas) TO stdout;
Date: 2021-09-20 03:08:43 Duration: 4m8s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
10 4m5s 4m5s 4m5s 1 4m5s copy fila_trabalho.fila_trabalho_2020_12 (id_fila_trabalho, nome_fila, descricao_metodo, descricao_parametros, prioridade, espera_maxima, recuperavel, nome_metodo, parametros, tipos_parametros, entrada_fila, inicio_execucao, fim_execucao, id_situacao_trabalho, id_recuperacao, resultado, atributos, tipos_atributos, id_instituicao, usuarios) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 20 04 1 4m5s 4m5s [ User: postgres - Total duration: 4m5s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 4m5s - Times executed: 1 ]
-
COPY fila_trabalho.fila_trabalho_2020_12 (id_fila_trabalho, nome_fila, descricao_metodo, descricao_parametros, prioridade, espera_maxima, recuperavel, nome_metodo, parametros, tipos_parametros, entrada_fila, inicio_execucao, fim_execucao, id_situacao_trabalho, id_recuperacao, resultado, atributos, tipos_atributos, id_instituicao, usuarios) TO stdout;
Date: 2021-09-20 04:44:12 Duration: 4m5s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
11 4m4s 4m4s 4m4s 1 4m4s copy aluno_lancamento.falta_aluno_disciplina_diario_2019 (id_falta_aluno_disciplina_diario, id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, data, id_horario_turma, flg_justificada, id_motivo_falta_justificada, descricao_motivo_falta_justificada) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 20 03 1 4m4s 4m4s [ User: postgres - Total duration: 4m4s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 4m4s - Times executed: 1 ]
-
COPY aluno_lancamento.falta_aluno_disciplina_diario_2019 (id_falta_aluno_disciplina_diario, id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, data, id_horario_turma, flg_justificada, id_motivo_falta_justificada, descricao_motivo_falta_justificada) TO stdout;
Date: 2021-09-20 03:23:39 Duration: 4m4s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
12 3m34s 3m34s 3m34s 1 3m34s copy aluno_lancamento.falta_aluno_disciplina_2016 (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, falta_justificada, falta_nao_justificada, qtd_faltas) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 20 03 1 3m34s 3m34s [ User: postgres - Total duration: 3m34s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 3m34s - Times executed: 1 ]
-
COPY aluno_lancamento.falta_aluno_disciplina_2016 (id_aluno_matricula, id_turma, id_disciplina, id_nota_periodo_aluno, falta_justificada, falta_nao_justificada, qtd_faltas) TO stdout;
Date: 2021-09-20 03:04:34 Duration: 3m34s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
13 3m32s 3m32s 3m32s 1 3m32s copy aluno_lancamento.nota_aluno_legado (nota, id_disciplina, id_aluno_matricula, id_turma, id_nota_periodo_aluno, id_conceito_avaliacao, flg_nao_compareceu, id_resultado_final_disciplina, nota_conselho, nota_continuidade_ciclo) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 20 04 1 3m32s 3m32s [ User: postgres - Total duration: 3m32s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 3m32s - Times executed: 1 ]
-
COPY aluno_lancamento.nota_aluno_legado (nota, id_disciplina, id_aluno_matricula, id_turma, id_nota_periodo_aluno, id_conceito_avaliacao, flg_nao_compareceu, id_resultado_final_disciplina, nota_conselho, nota_continuidade_ciclo) TO stdout;
Date: 2021-09-20 04:10:41 Duration: 3m32s Database: augeeducacional User: postgres Remote: [local] Application: pg_dump
14 2s847ms 27s15ms 3s630ms 1,184 1h11m38s select count(*) as fila from fila_trabalho.fila_trabalho where id_situacao_trabalho in (...) and entrada_fila > (now() - interval ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 20 01 108 6m7s 3s401ms 02 147 8m47s 3s590ms 03 148 12m2s 4s878ms 04 147 8m25s 3s438ms 05 146 8m8s 3s347ms 06 148 8m9s 3s306ms 07 145 8m13s 3s400ms 08 146 8m50s 3s636ms 09 49 2m53s 3s537ms [ User: zabbix - Total duration: 1h11m38s - Times executed: 1184 ]
[ Application: psql - Total duration: 1h11m38s - Times executed: 1184 ]
-
SELECT COUNT(*) as fila FROM fila_trabalho.fila_trabalho WHERE id_situacao_trabalho IN (1) and entrada_fila > (NOW() - interval '60 day');
Date: 2021-09-20 08:51:30 Duration: 27s15ms Database: augeeducacional User: zabbix Remote: [local] Application: psql
-
SELECT COUNT(*) as fila FROM fila_trabalho.fila_trabalho WHERE id_situacao_trabalho IN (1) and entrada_fila > (NOW() - interval '60 day');
Date: 2021-09-20 02:05:17 Duration: 14s68ms Database: augeeducacional User: zabbix Remote: [local] Application: psql
-
SELECT COUNT(*) as fila FROM fila_trabalho.fila_trabalho WHERE id_situacao_trabalho IN (1) and entrada_fila > (NOW() - interval '60 day');
Date: 2021-09-20 03:03:44 Duration: 12s188ms Database: augeeducacional User: zabbix Remote: [local] Application: psql
15 1s526ms 11s834ms 2s330ms 194 7m32s select count(*) from pg_buffercache where not isdirty;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 20 01 18 36s460ms 2s25ms 02 24 1m3s 2s632ms 03 24 1m42s 4s289ms 04 24 46s719ms 1s946ms 05 24 47s339ms 1s972ms 06 24 45s991ms 1s916ms 07 24 47s446ms 1s976ms 08 24 46s872ms 1s953ms 09 8 15s64ms 1s883ms [ User: zabbix - Total duration: 7m32s - Times executed: 194 ]
[ Application: psql - Total duration: 7m32s - Times executed: 194 ]
-
select count(*) from pg_buffercache where not isdirty;
Date: 2021-09-20 02:05:36 Duration: 11s834ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where not isdirty;
Date: 2021-09-20 03:06:10 Duration: 11s826ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where not isdirty;
Date: 2021-09-20 02:10:56 Duration: 8s58ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
16 1s785ms 3s367ms 2s188ms 283 10m19s select ts.id_turma, ts.id_modelo_avaliacao_desc, ts.id_modelo_acompanhamento_atitudinal, ts.id_modelo_observacao_estudante, null as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma on turma.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = turma.id_unidade_funcional where uf.id_instituicao = ? and (ts.id_modelo_avaliacao_desc is not null or ts.id_modelo_acompanhamento_atitudinal is not null or ts.id_modelo_observacao_estudante is not null) and turma.flg_organizada is true and turma.id_turma in ( select tp.id_turma from turma_professor tp where tp.id_turma = turma.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = ?) union all select ts.id_turma, null as id_modelo_avaliacao_desc, null as id_modelo_observacao_estudante, null as id_modelo_acompanhamento_atitudinal, tsm.id_modelo_avaliacao_desc as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma t on t.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = t.id_unidade_funcional inner join turma_serie_modelo_avaliacao_desc tsm on tsm.id_serie = ts.id_serie and tsm.id_turma = ts.id_turma and tsm.id_tipo_modelo_avaliacao_desc = ? inner join modelo_avaliacao_desc modelo_ficha_acompanhamento on modelo_ficha_acompanhamento.id_modelo_avaliacao_desc = tsm.id_modelo_avaliacao_desc where uf.id_instituicao = ? and t.flg_organizada is true and exists ( select null from turma_professor tp inner join componente_curricular on componente_curricular.id_componente_curricular = tp.id_componente_curricular where tp.id_turma = t.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = ? and componente_curricular.id_disciplina = modelo_ficha_acompanhamento.id_disciplina);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 20 09 283 10m19s 2s188ms [ User: augeeducacional - Total duration: 10m19s - Times executed: 283 ]
[ Application: augeeducacional - principal - Total duration: 10m19s - Times executed: 283 ]
-
select ts.id_turma, ts.id_modelo_avaliacao_desc, ts.id_modelo_acompanhamento_atitudinal, ts.id_modelo_observacao_estudante, null as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma on turma.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = turma.id_unidade_funcional where uf.id_instituicao = '60' and (ts.id_modelo_avaliacao_desc is not null or ts.id_modelo_acompanhamento_atitudinal is not null or ts.id_modelo_observacao_estudante is not null) and turma.flg_organizada is true and turma.id_turma in ( select tp.id_turma from turma_professor tp where tp.id_turma = turma.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = '2682309') union all select ts.id_turma, null as id_modelo_avaliacao_desc, null as id_modelo_observacao_estudante, null as id_modelo_acompanhamento_atitudinal, tsm.id_modelo_avaliacao_desc as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma t on t.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = t.id_unidade_funcional inner join turma_serie_modelo_avaliacao_desc tsm on tsm.id_serie = ts.id_serie and tsm.id_turma = ts.id_turma and tsm.id_tipo_modelo_avaliacao_desc = 4 inner join modelo_avaliacao_desc modelo_ficha_acompanhamento on modelo_ficha_acompanhamento.id_modelo_avaliacao_desc = tsm.id_modelo_avaliacao_desc where uf.id_instituicao = '60' and t.flg_organizada is true and exists ( select null from turma_professor tp inner join componente_curricular on componente_curricular.id_componente_curricular = tp.id_componente_curricular where tp.id_turma = t.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = '2682309' and componente_curricular.id_disciplina = modelo_ficha_acompanhamento.id_disciplina);
Date: 2021-09-20 09:05:34 Duration: 3s367ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select ts.id_turma, ts.id_modelo_avaliacao_desc, ts.id_modelo_acompanhamento_atitudinal, ts.id_modelo_observacao_estudante, null as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma on turma.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = turma.id_unidade_funcional where uf.id_instituicao = '60' and (ts.id_modelo_avaliacao_desc is not null or ts.id_modelo_acompanhamento_atitudinal is not null or ts.id_modelo_observacao_estudante is not null) and turma.flg_organizada is true and turma.id_turma in ( select tp.id_turma from turma_professor tp where tp.id_turma = turma.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = '7797887') union all select ts.id_turma, null as id_modelo_avaliacao_desc, null as id_modelo_observacao_estudante, null as id_modelo_acompanhamento_atitudinal, tsm.id_modelo_avaliacao_desc as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma t on t.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = t.id_unidade_funcional inner join turma_serie_modelo_avaliacao_desc tsm on tsm.id_serie = ts.id_serie and tsm.id_turma = ts.id_turma and tsm.id_tipo_modelo_avaliacao_desc = 4 inner join modelo_avaliacao_desc modelo_ficha_acompanhamento on modelo_ficha_acompanhamento.id_modelo_avaliacao_desc = tsm.id_modelo_avaliacao_desc where uf.id_instituicao = '60' and t.flg_organizada is true and exists ( select null from turma_professor tp inner join componente_curricular on componente_curricular.id_componente_curricular = tp.id_componente_curricular where tp.id_turma = t.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = '7797887' and componente_curricular.id_disciplina = modelo_ficha_acompanhamento.id_disciplina);
Date: 2021-09-20 09:04:12 Duration: 2s940ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select ts.id_turma, ts.id_modelo_avaliacao_desc, ts.id_modelo_acompanhamento_atitudinal, ts.id_modelo_observacao_estudante, null as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma on turma.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = turma.id_unidade_funcional where uf.id_instituicao = '60' and (ts.id_modelo_avaliacao_desc is not null or ts.id_modelo_acompanhamento_atitudinal is not null or ts.id_modelo_observacao_estudante is not null) and turma.flg_organizada is true and turma.id_turma in ( select tp.id_turma from turma_professor tp where tp.id_turma = turma.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = '7169818') union all select ts.id_turma, null as id_modelo_avaliacao_desc, null as id_modelo_observacao_estudante, null as id_modelo_acompanhamento_atitudinal, tsm.id_modelo_avaliacao_desc as id_modelo_ficha_acompanhamento from turma_serie ts inner join turma t on t.id_turma = ts.id_turma inner join unidade_funcional uf on uf.id_unidade_funcional = t.id_unidade_funcional inner join turma_serie_modelo_avaliacao_desc tsm on tsm.id_serie = ts.id_serie and tsm.id_turma = ts.id_turma and tsm.id_tipo_modelo_avaliacao_desc = 4 inner join modelo_avaliacao_desc modelo_ficha_acompanhamento on modelo_ficha_acompanhamento.id_modelo_avaliacao_desc = tsm.id_modelo_avaliacao_desc where uf.id_instituicao = '60' and t.flg_organizada is true and exists ( select null from turma_professor tp inner join componente_curricular on componente_curricular.id_componente_curricular = tp.id_componente_curricular where tp.id_turma = t.id_turma and tp.id_serie = ts.id_serie and tp.id_cidadao = '7169818' and componente_curricular.id_disciplina = modelo_ficha_acompanhamento.id_disciplina);
Date: 2021-09-20 09:01:31 Duration: 2s837ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
17 1s342ms 13s 2s57ms 194 6m39s select count(*) from pg_buffercache where isdirty;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 20 01 18 30s381ms 1s687ms 02 24 59s670ms 2s486ms 03 24 1m34s 3s918ms 04 24 41s633ms 1s734ms 05 24 40s353ms 1s681ms 06 24 39s265ms 1s636ms 07 24 40s82ms 1s670ms 08 24 40s19ms 1s667ms 09 8 13s666ms 1s708ms [ User: zabbix - Total duration: 6m39s - Times executed: 194 ]
[ Application: psql - Total duration: 6m39s - Times executed: 194 ]
-
select count(*) from pg_buffercache where isdirty;
Date: 2021-09-20 02:05:40 Duration: 13s Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where isdirty;
Date: 2021-09-20 03:06:11 Duration: 8s859ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where isdirty;
Date: 2021-09-20 02:10:56 Duration: 7s822ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
18 1s294ms 11s399ms 1s875ms 194 6m3s select count(*) from pg_buffercache;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 20 01 18 29s301ms 1s627ms 02 24 56s941ms 2s372ms 03 24 1m15s 3s137ms 04 24 37s370ms 1s557ms 05 24 38s196ms 1s591ms 06 24 38s473ms 1s603ms 07 24 38s980ms 1s624ms 08 24 37s93ms 1s545ms 09 8 12s153ms 1s519ms [ User: zabbix - Total duration: 6m3s - Times executed: 194 ]
[ Application: psql - Total duration: 6m3s - Times executed: 194 ]
-
select count(*) from pg_buffercache;
Date: 2021-09-20 02:05:41 Duration: 11s399ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache;
Date: 2021-09-20 02:10:56 Duration: 7s758ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache;
Date: 2021-09-20 03:06:56 Duration: 7s278ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
19 1s455ms 5s256ms 1s784ms 194 5m46s select count(*) from pg_buffercache where reldatabase is not null;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 20 01 18 31s130ms 1s729ms 02 24 45s376ms 1s890ms 03 24 49s889ms 2s78ms 04 24 40s554ms 1s689ms 05 24 42s813ms 1s783ms 06 24 40s976ms 1s707ms 07 24 41s598ms 1s733ms 08 24 40s439ms 1s684ms 09 8 13s488ms 1s686ms [ User: zabbix - Total duration: 5m46s - Times executed: 194 ]
[ Application: psql - Total duration: 5m46s - Times executed: 194 ]
-
select count(*) from pg_buffercache where reldatabase is not null;
Date: 2021-09-20 02:05:41 Duration: 5s256ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where reldatabase is not null;
Date: 2021-09-20 03:06:56 Duration: 4s331ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
-
select count(*) from pg_buffercache where reldatabase is not null;
Date: 2021-09-20 03:01:12 Duration: 4s114ms Database: postgres User: zabbix Remote: seedbm19 Application: psql
20 219ms 8s292ms 1s686ms 126 3m32s select json_agg(r.*)::text as r from ( select sda.id_situacao_didatica_aula, sda.id_turma, sda.id_serie, sda.id_componente_curricular, sda.data, sda.id_horario_turma, sda.numero_aula, sda.data_atualizacao from situacao_didatica_aula sda inner join componente_curricular on componente_curricular.id_componente_curricular = sda.id_componente_curricular where sda.id_turma in (...) and exists ( select null from turma_professor tp where tp.id_cidadao = ? and tp.id_turma = sda.id_turma and componente_curricular.id_componente_curricular = tp.id_componente_curricular) and exists ( select null from registro_lancamento_conteudo_diario registro_lancamento where registro_lancamento.id_turma = sda.id_turma and registro_lancamento.id_componente_curricular = sda.id_componente_curricular and registro_lancamento.data_referencia = sda.data and registro_lancamento.data_atualizacao > ?)) r;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 20 09 126 3m32s 1s686ms [ User: augeeducacional - Total duration: 3m32s - Times executed: 126 ]
[ Application: augeeducacional - principal - Total duration: 3m32s - Times executed: 126 ]
-
select json_agg(r.*)::text as r from ( select sda.id_situacao_didatica_aula, sda.id_turma, sda.id_serie, sda.id_componente_curricular, sda.data, sda.id_horario_turma, sda.numero_aula, sda.data_atualizacao from situacao_didatica_aula sda inner join componente_curricular on componente_curricular.id_componente_curricular = sda.id_componente_curricular where sda.id_turma in ('210007052', '210007053', '210007054', '210007055', '210007056', '210007057', '210007058', '210007059', '210007060', '210007061', '210007062', '210007617', '210007618', '210007619', '210007620', '210007621', '210007622', '210007623', '210007624', '210007626', '210007628', '210007629', '210007630', '210008977') and exists ( select null from turma_professor tp where tp.id_cidadao = '6369256' and tp.id_turma = sda.id_turma and componente_curricular.id_componente_curricular = tp.id_componente_curricular) and exists ( select null from registro_lancamento_conteudo_diario registro_lancamento where registro_lancamento.id_turma = sda.id_turma and registro_lancamento.id_componente_curricular = sda.id_componente_curricular and registro_lancamento.data_referencia = sda.data and registro_lancamento.data_atualizacao > '2021-09-18 15:45:45.604')) r;
Date: 2021-09-20 09:17:06 Duration: 8s292ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select json_agg(r.*)::text as r from ( select sda.id_situacao_didatica_aula, sda.id_turma, sda.id_serie, sda.id_componente_curricular, sda.data, sda.id_horario_turma, sda.numero_aula, sda.data_atualizacao from situacao_didatica_aula sda inner join componente_curricular on componente_curricular.id_componente_curricular = sda.id_componente_curricular where sda.id_turma in ('210000492', '210000493', '210000494', '210000495', '210000496', '210000497', '210000498', '210001210') and exists ( select null from turma_professor tp where tp.id_cidadao = '5006929' and tp.id_turma = sda.id_turma and componente_curricular.id_componente_curricular = tp.id_componente_curricular) and exists ( select null from registro_lancamento_conteudo_diario registro_lancamento where registro_lancamento.id_turma = sda.id_turma and registro_lancamento.id_componente_curricular = sda.id_componente_curricular and registro_lancamento.data_referencia = sda.data and registro_lancamento.data_atualizacao > '2021-09-17 15:42:44.552')) r;
Date: 2021-09-20 09:18:01 Duration: 4s581ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
-
select json_agg(r.*)::text as r from ( select sda.id_situacao_didatica_aula, sda.id_turma, sda.id_serie, sda.id_componente_curricular, sda.data, sda.id_horario_turma, sda.numero_aula, sda.data_atualizacao from situacao_didatica_aula sda inner join componente_curricular on componente_curricular.id_componente_curricular = sda.id_componente_curricular where sda.id_turma in ('210006933', '210006934', '210006935', '210006936', '210006937', '210006938', '210006939', '210006940', '210006942', '210006943', '210006945', '210006946', '210008001', '210008108', '210040250', '210040252', '210040253', '210041414') and exists ( select null from turma_professor tp where tp.id_cidadao = '2638887' and tp.id_turma = sda.id_turma and componente_curricular.id_componente_curricular = tp.id_componente_curricular) and exists ( select null from registro_lancamento_conteudo_diario registro_lancamento where registro_lancamento.id_turma = sda.id_turma and registro_lancamento.id_componente_curricular = sda.id_componente_curricular and registro_lancamento.data_referencia = sda.data and registro_lancamento.data_atualizacao > '2021-09-18 20:07:32.05')) r;
Date: 2021-09-20 09:07:23 Duration: 4s291ms Database: augeeducacional User: augeeducacional Remote: seeweb85 Application: augeeducacional - principal Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 426ms 1 426ms 426ms 426ms select ;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Sep 20 08 1 426ms 426ms [ User: augeeducacional - Total duration: 3s63ms - Times executed: 1 ]
[ Application: augeeducacional - fila - Total duration: 3s63ms - Times executed: 1 ]
-
select ;
Date: 2021-09-20 08:59:44 Duration: 426ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85
2 125ms 1 125ms 125ms 125ms select * from movel.sincronizacao_lancamento where id_sincronizacao_lancamento = $1;Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 07 1 125ms 125ms [ User: augeeducacional - Total duration: 832ms - Times executed: 1 ]
[ Application: augeeducacional - fila - Total duration: 832ms - Times executed: 1 ]
-
select * from movel.sincronizacao_lancamento where id_sincronizacao_lancamento = $1;
Date: 2021-09-20 08:59:42 Duration: 125ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85
3 119ms 1 119ms 119ms 119ms select count(*) as contagem from ( select ;Times Reported Time consuming prepare #3
Day Hour Count Duration Avg duration 08 1 119ms 119ms [ User: augeeducacional - Total duration: 1s631ms - Times executed: 1 ]
[ Application: augeeducacional - principal - Total duration: 1s631ms - Times executed: 1 ]
-
select count(*) as contagem from ( select ;
Date: 2021-09-20 09:00:31 Duration: 119ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 11s106ms 2 115ms 10s990ms 5s553ms update fila_trabalho.fila_trabalho set id_situacao_trabalho = $1, inicio_execucao = $2 where id_fila_trabalho = $3;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 20 08 1 10s990ms 10s990ms 09 1 115ms 115ms [ User: augeeducacional - Total duration: 1s702ms - Times executed: 2 ]
[ Application: augeeducacional - fila - Total duration: 1s702ms - Times executed: 2 ]
-
update fila_trabalho.fila_trabalho set id_situacao_trabalho = $1, inicio_execucao = $2 where id_fila_trabalho = $3;
Date: 2021-09-20 08:51:14 Duration: 10s990ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '2', $2 = '2021-09-20 08:51:03.41', $3 = '37658831'
-
update fila_trabalho.fila_trabalho set id_situacao_trabalho = $1, inicio_execucao = $2 where id_fila_trabalho = $3;
Date: 2021-09-20 09:01:47 Duration: 115ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '606099', $2 = '2021', $3 = '534'
2 7s548ms 44 100ms 296ms 171ms select distinct ;Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 08 44 7s548ms 171ms [ User: augeeducacional - Total duration: 15s195ms - Times executed: 44 ]
[ Application: augeeducacional - principal - Total duration: 15s195ms - Times executed: 44 ]
-
select distinct ;
Date: 2021-09-20 09:16:01 Duration: 296ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '210014934'
-
select distinct ;
Date: 2021-09-20 09:16:32 Duration: 275ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '1', $2 = '2', $3 = '3', $4 = '4', $5 = '1', $6 = '2', $7 = '3', $8 = '4', $9 = '5', $10 = '6', $11 = '9748208', $12 = '210002251'
-
select distinct ;
Date: 2021-09-20 09:03:12 Duration: 271ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '60', $2 = 'joyce.1234'
3 2s861ms 13 109ms 521ms 220ms select ;Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 07 5 1s539ms 307ms 08 8 1s322ms 165ms [ User: augeeducacional - Total duration: 8s483ms - Times executed: 13 ]
[ Application: augeeducacional - fila - Total duration: 5s567ms - Times executed: 6 ]
[ Application: augeeducacional - principal - Total duration: 2s916ms - Times executed: 7 ]
-
select ;
Date: 2021-09-20 08:59:48 Duration: 521ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '210039223', $2 = '1', $3 = '1131', $4 = '2021-08-10', $5 = '1131', $6 = '1'
-
select ;
Date: 2021-09-20 08:59:52 Duration: 382ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '2021', $2 = '210015309', $3 = '210015303', $4 = '210015300', $5 = '210015308', $6 = '210015304', $7 = '210015307', $8 = '210015306', $9 = '210015299', $10 = '210015310', $11 = '210040749', $12 = '210040748', $13 = '210040750', $14 = '210015302', $15 = '210015301', $16 = '210015305', $17 = '210041642', $18 = '1', $19 = '1', $20 = '1'
-
select ;
Date: 2021-09-20 08:59:49 Duration: 355ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '2021', $2 = '210015309', $3 = '210015303', $4 = '210015300', $5 = '210015308', $6 = '210015304', $7 = '210015307', $8 = '210015306', $9 = '210015299', $10 = '210015310', $11 = '210040749', $12 = '210040748', $13 = '210040750', $14 = '210015302', $15 = '210015301', $16 = '210015305', $17 = '210041642', $18 = '1', $19 = '1', $20 = '1', $21 = '1', $22 = '1'
4 2s735ms 1 2s735ms 2s735ms 2s735ms select max(ano * 10000 + mes * 100 + dia) as data from autocadastro_diario where id_instituicao = $1 and id_unidade_funcional = $2;Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 08 1 2s735ms 2s735ms [ User: augeeducacional - Total duration: 2s828ms - Times executed: 1 ]
[ Application: augeeducacional - principal - Total duration: 2s828ms - Times executed: 1 ]
-
select max(ano * 10000 + mes * 100 + dia) as data from autocadastro_diario where id_instituicao = $1 and id_unidade_funcional = $2;
Date: 2021-09-20 09:10:20 Duration: 2s735ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '60', $2 = '0'
5 1s850ms 4 102ms 1s337ms 462ms select ;Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 07 1 1s337ms 1s337ms 08 3 512ms 170ms [ User: augeeducacional - Total duration: 13s568ms - Times executed: 4 ]
[ Application: augeeducacional - principal - Total duration: 9s813ms - Times executed: 1 ]
[ Application: augeeducacional - fila - Total duration: 3s755ms - Times executed: 3 ]
-
select ;
Date: 2021-09-20 08:59:45 Duration: 1s337ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '605362', $2 = '2021'
-
select ;
Date: 2021-09-20 09:00:18 Duration: 299ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '2621799', $2 = '2021-09-17 11:40:35.143'
-
select ;
Date: 2021-09-20 09:04:13 Duration: 110ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '606143', $2 = '2021'
6 1s768ms 1 1s768ms 1s768ms 1s768ms select * from movel.sincronizacao_lancamento where id_sincronizacao_lancamento = $1;Times Reported Time consuming bind #6
Day Hour Count Duration Avg duration 07 1 1s768ms 1s768ms [ User: augeeducacional - Total duration: 832ms - Times executed: 1 ]
[ Application: augeeducacional - fila - Total duration: 832ms - Times executed: 1 ]
-
select * from movel.sincronizacao_lancamento where id_sincronizacao_lancamento = $1;
Date: 2021-09-20 08:59:56 Duration: 1s768ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '38216787'
7 1s644ms 2 399ms 1s245ms 822ms update movel.sincronizacao set versao_aplicativo = $1, plataforma_dispositivo = $2, fabricante_dispositivo = $3, versao_dispositivo = $4, data = $5, id_dispositivo = $6, id_usuario = $7, flg_expedicao = $8, modelo_dispositivo = $9, id_instituicao = $10 where id_sincronizacao = $11;Times Reported Time consuming bind #7
Day Hour Count Duration Avg duration 08 2 1s644ms 822ms [ User: augeeducacional - Total duration: 947ms - Times executed: 2 ]
[ Application: augeeducacional - principal - Total duration: 947ms - Times executed: 2 ]
-
update movel.sincronizacao set versao_aplicativo = $1, plataforma_dispositivo = $2, fabricante_dispositivo = $3, versao_dispositivo = $4, data = $5, id_dispositivo = $6, id_usuario = $7, flg_expedicao = $8, modelo_dispositivo = $9, id_instituicao = $10 where id_sincronizacao = $11;
Date: 2021-09-20 09:01:29 Duration: 1s245ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '1', $2 = '2', $3 = '3', $4 = '4', $5 = '1', $6 = '2', $7 = '3', $8 = '4', $9 = '5', $10 = '6', $11 = '10138048', $12 = '210011899'
-
update movel.sincronizacao set versao_aplicativo = $1, plataforma_dispositivo = $2, fabricante_dispositivo = $3, versao_dispositivo = $4, data = $5, id_dispositivo = $6, id_usuario = $7, flg_expedicao = $8, modelo_dispositivo = $9, id_instituicao = $10 where id_sincronizacao = $11;
Date: 2021-09-20 09:15:59 Duration: 399ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '2021.7.30', $2 = 'Android', $3 = '-', $4 = '7.0', $5 = '2021-09-20 09:15:54.218', $6 = '5fa8057c930e43c', $7 = '877910', $8 = 't', $9 = 'Moto G (4)', $10 = '60', $11 = '14482831'
8 1s404ms 7 104ms 677ms 200ms select count(*) as contagem from ((;Times Reported Time consuming bind #8
Day Hour Count Duration Avg duration 08 7 1s404ms 200ms [ User: augeeducacional - Total duration: 14s66ms - Times executed: 7 ]
[ Application: augeeducacional - principal - Total duration: 14s66ms - Times executed: 7 ]
-
select count(*) as contagem from ((;
Date: 2021-09-20 09:00:42 Duration: 677ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '7', $2 = '2021', $3 = '2021', $4 = '2021', $5 = '2021', $6 = '2021', $7 = 'NICOLLI', $8 = '605656', $9 = '60', $10 = '7', $11 = '2021', $12 = '2021', $13 = '2021', $14 = '2021', $15 = '2021', $16 = 'NICOLLI', $17 = '605656', $18 = '60'
-
select count(*) as contagem from ((;
Date: 2021-09-20 09:00:49 Duration: 151ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '7', $2 = '2021', $3 = '2021', $4 = '2021', $5 = '2021', $6 = '2021', $7 = '605237', $8 = '605237', $9 = '605237', $10 = '60', $11 = '7', $12 = '2021', $13 = '2021', $14 = '2021', $15 = '2021', $16 = '2021', $17 = '605237', $18 = '605237', $19 = '605237', $20 = '60'
-
select count(*) as contagem from ((;
Date: 2021-09-20 09:00:42 Duration: 132ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '7', $2 = '2021', $3 = '2021', $4 = '2021', $5 = '2021', $6 = '2021', $7 = '605237', $8 = '605237', $9 = '605237', $10 = '60', $11 = '7', $12 = '2021', $13 = '2021', $14 = '2021', $15 = '2021', $16 = '2021', $17 = '605237', $18 = '605237', $19 = '605237', $20 = '60'
9 1s47ms 6 100ms 507ms 174ms select distinct ;Times Reported Time consuming bind #9
Day Hour Count Duration Avg duration 07 1 507ms 507ms 08 5 539ms 107ms [ User: augeeducacional - Total duration: 6s841ms - Times executed: 6 ]
[ Application: augeeducacional - fila - Total duration: 5s350ms - Times executed: 1 ]
[ Application: augeeducacional - principal - Total duration: 1s490ms - Times executed: 5 ]
-
select distinct ;
Date: 2021-09-20 08:59:54 Duration: 507ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '210015299', $2 = '210015300', $3 = '210015301', $4 = '210015302', $5 = '210015303', $6 = '210015304', $7 = '210015305', $8 = '210015306', $9 = '210015307', $10 = '210015308', $11 = '210015309', $12 = '210015310', $13 = '210040748', $14 = '210040749', $15 = '210040750', $16 = '210041642', $17 = '1', $18 = '2', $19 = '4', $20 = '2', $21 = '4', $22 = '2', $23 = '4'
-
select distinct ;
Date: 2021-09-20 09:16:58 Duration: 116ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '2670856', $2 = '2021-09-20 09:07:32.768'
-
select distinct ;
Date: 2021-09-20 09:06:00 Duration: 113ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '210001915', $2 = '1143', $3 = '9736224'
10 841ms 5 167ms 169ms 168ms select ip.id_informe_portal, ip.titulo, ip.chamada, imagem.identificador || '.' || imagem.tipo as imagem_chamada, imagem.legenda as legenda_imagem, ipx.data_publicacao from informe_portal ip;Times Reported Time consuming bind #10
Day Hour Count Duration Avg duration 08 5 841ms 168ms [ User: augeeducacional - Total duration: 805ms - Times executed: 5 ]
[ Application: augeeducacional - principal - Total duration: 805ms - Times executed: 5 ]
-
select ip.id_informe_portal, ip.titulo, ip.chamada, imagem.identificador || '.' || imagem.tipo as imagem_chamada, imagem.legenda as legenda_imagem, ipx.data_publicacao from informe_portal ip;
Date: 2021-09-20 08:59:56 Duration: 169ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85
-
select ip.id_informe_portal, ip.titulo, ip.chamada, imagem.identificador || '.' || imagem.tipo as imagem_chamada, imagem.legenda as legenda_imagem, ipx.data_publicacao from informe_portal ip;
Date: 2021-09-20 08:59:56 Duration: 168ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = NULL, $2 = '2012-05-29 14:34:32.688', $3 = NULL, $4 = NULL, $5 = NULL, $6 = NULL, $7 = NULL, $8 = NULL, $9 = 'f', $10 = 'joaothiago', $11 = '0', $12 = NULL, $13 = NULL, $14 = NULL, $15 = NULL, $16 = NULL, $17 = '2020-06-15 13:58:15.417', $18 = NULL, $19 = NULL, $20 = NULL, $21 = NULL, $22 = 'f', $23 = NULL, $24 = NULL, $25 = '2021-09-20 09:00:00.099', $26 = 'colegionormalestadual@bol.com', $27 = NULL, $28 = NULL, $29 = NULL, $30 = NULL, $31 = '3bdd26c37c6d425888961f34dbf7aa7f', $32 = 'JOAO THIAGO DOS SANTOS SIQUEIRA', $33 = NULL, $34 = NULL, $35 = NULL, $36 = 'f', $37 = NULL, $38 = NULL, $39 = NULL, $40 = NULL, $41 = NULL, $42 = NULL, $43 = NULL, $44 = '56066'
-
select ip.id_informe_portal, ip.titulo, ip.chamada, imagem.identificador || '.' || imagem.tipo as imagem_chamada, imagem.legenda as legenda_imagem, ipx.data_publicacao from informe_portal ip;
Date: 2021-09-20 08:59:56 Duration: 168ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '18562', $2 = '210015983', $3 = '1198', $4 = '1', $5 = '1', $6 = '10122283', $7 = '210015983', $8 = '1'
11 589ms 1 589ms 589ms 589ms select exists ( select null from movel.professor_mudanca;Times Reported Time consuming bind #11
Day Hour Count Duration Avg duration 08 1 589ms 589ms [ User: augeeducacional - Total duration: 132ms - Times executed: 1 ]
[ Application: augeeducacional - principal - Total duration: 132ms - Times executed: 1 ]
-
select exists ( select null from movel.professor_mudanca;
Date: 2021-09-20 09:00:00 Duration: 589ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '18506', $2 = '210009976', $3 = '1197', $4 = '1', $5 = '1', $6 = '9975697', $7 = '210009976', $8 = '1'
12 575ms 1 575ms 575ms 575ms select * from planejamento_bimestral where id_turma = $1 and id_serie = $2 and id_nota_periodo_aluno = $3 and id_disciplina = $4;Times Reported Time consuming bind #12
Day Hour Count Duration Avg duration 08 1 575ms 575ms [ User: augeeducacional - Total duration: 474ms - Times executed: 1 ]
[ Application: augeeducacional - fila - Total duration: 474ms - Times executed: 1 ]
-
select * from planejamento_bimestral where id_turma = $1 and id_serie = $2 and id_nota_periodo_aluno = $3 and id_disciplina = $4;
Date: 2021-09-20 09:01:10 Duration: 575ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '210008140'
13 560ms 3 123ms 273ms 186ms select json_agg(r.*)::text as r from ( select ;Times Reported Time consuming bind #13
Day Hour Count Duration Avg duration 08 3 560ms 186ms [ User: augeeducacional - Total duration: 5s636ms - Times executed: 3 ]
[ Application: augeeducacional - principal - Total duration: 5s636ms - Times executed: 3 ]
-
select json_agg(r.*)::text as r from ( select ;
Date: 2021-09-20 09:01:20 Duration: 273ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '210004789', $2 = '210039574', $3 = '210004791', $4 = '210004785', $5 = '210004787', $6 = '210004796', $7 = '210004797', $8 = '210004782', $9 = '210004783', $10 = '210004793', $11 = '210004795', $12 = '5561510', $13 = '2021-09-17 11:25:18.719'
-
select json_agg(r.*)::text as r from ( select ;
Date: 2021-09-20 09:01:24 Duration: 163ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '210004782', $2 = '210004783', $3 = '210004785', $4 = '210004787', $5 = '210004789', $6 = '210004791', $7 = '210004793', $8 = '210004795', $9 = '210004796', $10 = '210004797', $11 = '210039574', $12 = '5561510', $13 = '2021-09-17 11:25:18.719'
-
select json_agg(r.*)::text as r from ( select ;
Date: 2021-09-20 09:00:29 Duration: 123ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '2621799', $2 = '2021-09-17 11:40:35.143', $3 = '2621799', $4 = '2021-09-17 11:40:35.143'
14 380ms 1 380ms 380ms 380ms select ;Times Reported Time consuming bind #14
Day Hour Count Duration Avg duration 08 1 380ms 380ms [ User: augeeducacional - Total duration: 1s382ms - Times executed: 1 ]
[ Application: augeeducacional - fila - Total duration: 1s382ms - Times executed: 1 ]
-
select ;
Date: 2021-09-20 08:59:59 Duration: 380ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '2021', $2 = '2021', $3 = '1', $4 = '210015299', $5 = '210015300', $6 = '210015301', $7 = '210015302', $8 = '210015303', $9 = '210015304', $10 = '210015305', $11 = '210015306', $12 = '210015307', $13 = '210015308', $14 = '210015309', $15 = '210015310', $16 = '210040748', $17 = '210040749', $18 = '210040750', $19 = '210041642'
15 360ms 3 100ms 153ms 120ms select ;Times Reported Time consuming bind #15
Day Hour Count Duration Avg duration 08 3 360ms 120ms [ User: augeeducacional - Total duration: 1s292ms - Times executed: 3 ]
[ Application: augeeducacional - fila - Total duration: 976ms - Times executed: 1 ]
[ Application: augeeducacional - principal - Total duration: 315ms - Times executed: 2 ]
-
select ;
Date: 2021-09-20 09:10:11 Duration: 153ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '16810', $2 = 'f', $3 = 'f', $4 = '200013730', $5 = '80317', $6 = 'f', $7 = 'f', $8 = '200013730', $9 = '80317', $10 = '16810', $11 = '200013730', $12 = '80317', $13 = '2020-02-03', $14 = '2020-12-30'
-
select ;
Date: 2021-09-20 09:02:33 Duration: 107ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '18991', $2 = '210011884', $3 = '1464', $4 = '1', $5 = '1', $6 = '10023737', $7 = '210011884', $8 = '1'
-
select ;
Date: 2021-09-20 09:08:47 Duration: 100ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '1128', $2 = '3', $3 = '1128', $4 = '3', $5 = '1128', $6 = '3', $7 = '210005411'
16 295ms 1 295ms 295ms 295ms select count(*) as contagem from ( select ;Times Reported Time consuming bind #16
Day Hour Count Duration Avg duration 08 1 295ms 295ms [ User: augeeducacional - Total duration: 1s631ms - Times executed: 1 ]
[ Application: augeeducacional - principal - Total duration: 1s631ms - Times executed: 1 ]
-
select count(*) as contagem from ( select ;
Date: 2021-09-20 09:00:32 Duration: 295ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = 'boletim', $2 = '60', $3 = 'pub', $4 = 'pub', $5 = 'pub'
17 271ms 1 271ms 271ms 271ms select c.nome as nome_aluno, ;Times Reported Time consuming bind #17
Day Hour Count Duration Avg duration 08 1 271ms 271ms [ User: augeeducacional - Total duration: 698ms - Times executed: 1 ]
[ Application: augeeducacional - principal - Total duration: 698ms - Times executed: 1 ]
-
select c.nome as nome_aluno, ;
Date: 2021-09-20 09:02:40 Duration: 271ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '50', $2 = '263', $3 = '2022', $4 = '1'
18 261ms 1 261ms 261ms 261ms SELECT cidadao.id_cidadao, am.id_aluno_matricula, ;Times Reported Time consuming bind #18
Day Hour Count Duration Avg duration 08 1 261ms 261ms [ User: augeeducacional - Total duration: 3s105ms - Times executed: 1 ]
[ Application: augeeducacional - principal - Total duration: 3s105ms - Times executed: 1 ]
-
SELECT cidadao.id_cidadao, am.id_aluno_matricula, ;
Date: 2021-09-20 09:00:59 Duration: 261ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = 'DOUGLAS & CLESLEY', $2 = '60', $3 = '606039', $4 = '2021'
19 224ms 1 224ms 224ms 224ms select exists (;Times Reported Time consuming bind #19
Day Hour Count Duration Avg duration 08 1 224ms 224ms [ User: augeeducacional - Total duration: 146ms - Times executed: 1 ]
[ Application: augeeducacional - principal - Total duration: 146ms - Times executed: 1 ]
-
select exists (;
Date: 2021-09-20 09:01:47 Duration: 224ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '210002222', $2 = '1130', $3 = '1130', $4 = '2021-09-20', $5 = '210002222'
20 221ms 1 221ms 221ms 221ms ( select ;Times Reported Time consuming bind #20
Day Hour Count Duration Avg duration 08 1 221ms 221ms [ User: augeeducacional - Total duration: 156ms - Times executed: 1 ]
[ Application: augeeducacional - principal - Total duration: 156ms - Times executed: 1 ]
-
( select ;
Date: 2021-09-20 09:00:15 Duration: 221ms Database: postgres User: augeeducacional Remote: augeeducacional Application: seeweb85 parameters: $1 = '449514'
-
Events
Log levels
Key values
- 20,265 Log entries
Events distribution
Key values
- 0 PANIC entries
- 1 FATAL entries
- 29 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 23 Max number of times the same event was reported
- 30 Total events found
Rank Times reported Error 1 23 ERROR: canceling statement due to statement timeout
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 20 09 23 - ERROR: canceling statement due to statement timeout
Statement: select exists(select null from movel.turma_mudanca where id_turma in ( select tp.id_turma from turma_professor tp where tp.id_cidadao = $1 ) and data between $2 and now() )
Date: 2021-09-20 09:00:10 Database: augeeducacional Application: augeeducacional - principal User: augeeducacional Remote: seeweb85
2 4 ERROR: new row for relation "..." violates check constraint "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 20 09 4 - ERROR: new row for relation "planejamento_matricula_vaga_localizacao" violates check constraint "ck_continuidade"
- ERROR: new row for relation "planejamento_matricula_vaga_localizacao" violates check constraint "ck_recepcao"
Detail: Failing row contains (605454, 605454, 1223, 251, 2022, 0, 151, 52, 0, 22, 22, 0, 0, 0, 22, 153, 33, 0, 0, 0, 0, 0, 0).
Statement: update planejamento_matricula_vaga_localizacao set renovacao = coalesce(pm.renovacao, 0), continuidade = coalesce(pm.continuidade, 0), recepcao = coalesce(pm.recepcao, 0), transferidos = coalesce(pm.transferidos, 0), remanescente = coalesce(pm.remanescente, 0), remanescente_disponiblizada = coalesce(pm.saldo_vagas_disp_novato, 0), novato = planejamento_matricula_vaga_localizacao.continuidade_disponiblizada + planejamento_matricula_vaga_localizacao.recepcao_disponiblizada + planejamento_matricula_vaga_localizacao.transferidos_disponiblizada + coalesce(pm.saldo_vagas_disp_novato, 0) from ( select sum(pm.renovacao) as renovacao, sum(pm.continuidade) as continuidade, sum(pm.recepcao) as recepcao, sum(pm.transferidos) as transferidos, sum(pm.vagas_remanescentes) as remanescente, sum(case pm.flg_disponibilizar_saldo_vagas_novato when true then pm.vagas_remanescentes else 0 end) as saldo_vagas_disp_novato from planejamento_matricula pm inner join ambiente on ambiente.id_ambiente = pm.id_ambiente where pm.id_unidade_funcional = $1 and ambiente.id_unidade_referencia = $2 and pm.id_serie = $3 and pm.id_turno = $4 and pm.ano = $5 ) as pm where planejamento_matricula_vaga_localizacao.id_escola = $6 and planejamento_matricula_vaga_localizacao.id_unidade_referencia = $7 and planejamento_matricula_vaga_localizacao.id_serie = $8 and planejamento_matricula_vaga_localizacao.id_turno = $9 and planejamento_matricula_vaga_localizacao.ano = $10Date: 2021-09-20 09:13:17 Database: augeeducacional Application: augeeducacional - principal User: augeeducacional Remote: seeweb85
Detail: Failing row contains (605454, 605454, 1223, 251, 2022, 0, 169, 31, 0, 25, 25, 0, 0, 0, 25, 153, 33, 0, 0, 0, 0, 0, 0).
Statement: update planejamento_matricula_vaga_localizacao set renovacao = coalesce(pm.renovacao, 0), continuidade = coalesce(pm.continuidade, 0), recepcao = coalesce(pm.recepcao, 0), transferidos = coalesce(pm.transferidos, 0), remanescente = coalesce(pm.remanescente, 0), remanescente_disponiblizada = coalesce(pm.saldo_vagas_disp_novato, 0), novato = planejamento_matricula_vaga_localizacao.continuidade_disponiblizada + planejamento_matricula_vaga_localizacao.recepcao_disponiblizada + planejamento_matricula_vaga_localizacao.transferidos_disponiblizada + coalesce(pm.saldo_vagas_disp_novato, 0) from ( select sum(pm.renovacao) as renovacao, sum(pm.continuidade) as continuidade, sum(pm.recepcao) as recepcao, sum(pm.transferidos) as transferidos, sum(pm.vagas_remanescentes) as remanescente, sum(case pm.flg_disponibilizar_saldo_vagas_novato when true then pm.vagas_remanescentes else 0 end) as saldo_vagas_disp_novato from planejamento_matricula pm inner join ambiente on ambiente.id_ambiente = pm.id_ambiente where pm.id_unidade_funcional = $1 and ambiente.id_unidade_referencia = $2 and pm.id_serie = $3 and pm.id_turno = $4 and pm.ano = $5 ) as pm where planejamento_matricula_vaga_localizacao.id_escola = $6 and planejamento_matricula_vaga_localizacao.id_unidade_referencia = $7 and planejamento_matricula_vaga_localizacao.id_serie = $8 and planejamento_matricula_vaga_localizacao.id_turno = $9 and planejamento_matricula_vaga_localizacao.ano = $10Date: 2021-09-20 09:15:09 Database: augeeducacional Application: augeeducacional - principal User: augeeducacional Remote: seeweb85
3 1 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 20 08 1 - FATAL: connection to client lost
Date: 2021-09-20 08:51:30 Database: augeeducacional Application: psql User: zabbix Remote: [local]
4 1 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 20 08 1 - ERROR: syntax error at or near "nul" at character 101
Statement: select * from fila_trabalho.fila_trabalho_2021_09 where inicio_execucao is null and fim_execucao is nul
Date: 2021-09-20 08:00:14 Database: augeeducacional Application: pgAdmin III - Query Tool User: sergio_veiga Remote: 10.81.1.92
5 1 ERROR: canceling statement due to user request
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 20 07 1 - ERROR: canceling statement due to user request
Statement: SELECT * FROM fila_trabalho.fila_trabalho_2021_09 ORDER BY id_fila_trabalho ASC
Date: 2021-09-20 07:55:51 Database: augeeducacional Application: pgAdmin III - Edit Grid User: sergio_veiga Remote: 10.81.1.92