pgBadger-
Global information
- Generated on Sun Sep 27 23:50:13 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 8,939 log entries in 10s
- Log start from 2026-09-27 00:00:25 to 2026-09-27 23:49:50
-
Overview
Global Stats
- 152 Number of unique normalized queries
- 831 Number of queries
- 4h42s Total query duration
- 2026-09-27 00:02:24 First query
- 2026-09-27 23:48:49 Last query
- 6 queries/s at 2026-09-27 23:43:08 Query peak
- 4h42s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h42s Execute total duration
- 1,454 Number of events
- 6 Number of unique normalized events
- 1,422 Max number of times the same event was reported
- 0 Number of cancellation
- 7 Total number of automatic vacuums
- 1 Total number of automatic analyzes
- 20 Number temporary file
- 247.60 MiB Max size of temporary file
- 67.39 MiB Average size of temporary file
- 208 Total number of sessions
- 8 sessions at 2026-09-27 06:05:01 Session peak
- 7d19h27m10s Total duration of sessions
- 54m4s Average duration of sessions
- 3 Average queries per session
- 1m9s Average queries duration per session
- 52m54s Average idle time per session
- 227 Total number of connections
- 3 connections/s at 2026-09-27 23:45:05 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-09-27 23:43:08 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-09-27 23:42:14 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 6 queries/s Query Peak
- 2026-09-27 23:43:08 Date
Queries duration
Key values
- 4h42s 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 27 00 19 0ms 21s283ms 4s983ms 3s160ms 3s597ms 48s580ms 01 6 0ms 3s463ms 3s208ms 3s36ms 3s182ms 3s463ms 02 6 0ms 3s537ms 3s251ms 3s96ms 3s241ms 3s537ms 03 6 0ms 3s522ms 3s208ms 2s946ms 3s161ms 3s522ms 04 6 0ms 3s313ms 3s135ms 2s974ms 3s114ms 3s313ms 05 12 0ms 11m18s 2m2s 3s620ms 3m6s 11m18s 06 12 0ms 20s382ms 5s538ms 3s73ms 3s135ms 28s477ms 07 19 0ms 8m52s 50s910ms 3s180ms 1m52s 8m52s 08 22 0ms 5m9s 26s649ms 3s242ms 5s982ms 5m54s 09 22 0ms 5m16s 26s822ms 3s78ms 14s458ms 5m46s 10 21 0ms 5m11s 29s350ms 3s105ms 3s450ms 5m55s 11 18 0ms 5m6s 32s106ms 3s52ms 3s121ms 5m51s 12 18 0ms 5m8s 32s234ms 3s189ms 3s501ms 5m52s 13 18 0ms 5m10s 32s353ms 3s72ms 3s266ms 5m54s 14 18 0ms 5m13s 32s595ms 3s53ms 15s300ms 5m43s 15 18 0ms 5m6s 32s136ms 3s57ms 3s502ms 5m51s 16 18 0ms 5m7s 32s112ms 3s71ms 3s343ms 5m51s 17 18 0ms 5m10s 32s454ms 3s100ms 3s251ms 5m56s 18 20 0ms 5m7s 28s946ms 3s84ms 3s484ms 5m51s 19 18 0ms 5m13s 32s703ms 3s118ms 3s267ms 5m57s 20 120 0ms 8m52s 12s634ms 1m6s 2m6s 8m52s 21 21 0ms 6m12s 31s34ms 3s121ms 14s667ms 6m45s 22 18 0ms 5m11s 32s717ms 3s171ms 3s264ms 5m55s 23 357 0ms 1m3s 5s567ms 1m5s 1m6s 1m8s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 27 00 4 0 7s426ms 0ms 0ms 291ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 3 0 9s492ms 0ms 0ms 0ms 07 13 0 1m12s 0ms 1s232ms 4m12s 08 10 0 55s848ms 0ms 0ms 3m23s 09 10 0 56s698ms 0ms 0ms 3m25s 10 8 0 1m9s 0ms 0ms 3m23s 11 6 0 1m32s 0ms 0ms 3m24s 12 6 0 1m32s 0ms 0ms 3m23s 13 6 0 1m33s 0ms 0ms 3m24s 14 6 0 1m33s 0ms 0ms 3m23s 15 6 0 1m32s 0ms 0ms 3m23s 16 6 0 1m32s 0ms 0ms 3m23s 17 6 0 1m33s 0ms 0ms 3m24s 18 8 0 1m9s 0ms 0ms 3m23s 19 6 0 1m34s 0ms 0ms 3m27s 20 22 79 14s570ms 42s564ms 1m2s 3m54s 21 7 0 1m29s 0ms 0ms 3m26s 22 6 0 1m34s 0ms 0ms 3m29s 23 34 322 5s582ms 1m2s 1m5s 1m8s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 27 00 0 0 0 0 0ms 0ms 0ms 0ms 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 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 27 00 0 1 1.00 0.00% 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 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 2 2.00 0.00% 08 0 1 1.00 0.00% 09 0 2 2.00 0.00% 10 0 1 1.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 4 4.00 0.00% Day Hour Count Average / Second Sep 27 00 14 0.00/s 01 7 0.00/s 02 6 0.00/s 03 15 0.00/s 04 7 0.00/s 05 9 0.00/s 06 13 0.00/s 07 11 0.00/s 08 10 0.00/s 09 12 0.00/s 10 9 0.00/s 11 7 0.00/s 12 9 0.00/s 13 8 0.00/s 14 8 0.00/s 15 8 0.00/s 16 7 0.00/s 17 8 0.00/s 18 8 0.00/s 19 7 0.00/s 20 11 0.00/s 21 9 0.00/s 22 8 0.00/s 23 16 0.00/s Day Hour Count Average Duration Average idle time Sep 27 00 7 1h27s 1h14s 01 12 1h45s 1h43s 02 7 1h26s 1h23s 03 14 14m34s 14m32s 04 7 1h2m9s 1h2m6s 05 7 1h8s 56m38s 06 9 57m33s 57m25s 07 11 1h49s 59m21s 08 10 55m18s 54m19s 09 10 55m18s 54m19s 10 8 1h1m2s 59m45s 11 9 1h1m16s 1h11s 12 6 1h52s 59m15s 13 9 54m46s 53m42s 14 7 54m17s 52m53s 15 8 1h1m1s 59m49s 16 8 1h1m26s 1h13s 17 7 1h44s 59m21s 18 6 1h4s 58m28s 19 7 1h 58m36s 20 10 42m57s 40m25s 21 8 1h47s 59m25s 22 8 1h22s 59m9s 23 13 35m5s 32m32s -
Connections
Established Connections
Key values
- 3 connections Connection Peak
- 2026-09-27 23:45:05 Date
Connections per database
Key values
- rio Main Database
- 227 connections Total
Connections per user
Key values
- intelifix Main User
- 227 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-09-27 06:05:01 Date
Histogram of session times
Key values
- 180 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 208 sessions Total
Sessions per user
Key values
- intelifix Main User
- 208 sessions Total
Sessions per host
Key values
- [local] Main Host
- 208 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 11,291 buffers Checkpoint Peak
- 2026-09-27 00:09:50 Date
- 269.743 seconds Highest write time
- 0.131 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2026-09-27 00:09:50 Date
Checkpoints distance
Key values
- 115.14 Mo Distance Peak
- 2026-09-27 00:09:50 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 27 00 11,291 269.743s 0.065s 269.83s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 6,897 0.173s 0.132s 0.34s 04 0 0s 0s 0s 05 7,366 737.241s 0.097s 737.371s 06 3,294 269.696s 0.005s 269.705s 07 952 114.762s 0.081s 114.86s 08 25 2.52s 0.013s 2.54s 09 23 2.313s 0.008s 2.324s 10 149 14.941s 0.003s 14.946s 11 26 2.62s 0.067s 2.721s 12 26 2.62s 0.008s 2.636s 13 24 2.412s 0.063s 2.479s 14 25 2.519s 0.007s 2.534s 15 26 2.621s 0.003s 2.63s 16 25 2.519s 0.011s 2.536s 17 26 2.62s 0.02s 2.652s 18 292 29.286s 0.135s 29.491s 19 25 2.52s 0.06s 2.588s 20 67 6.741s 0.01s 6.764s 21 51 5.131s 0.128s 5.268s 22 25 2.519s 0.013s 2.595s 23 120 12.052s 0.009s 12.07s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 27 00 0 0 3 38 0.062s 0.002s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 3 25 0.130s 0.007s 04 0 0 0 0 0s 0s 05 0 0 3 175 0.061s 0.011s 06 0 0 0 10 0.003s 0.001s 07 0 0 1 41 0.062s 0.01s 08 0 0 0 5 0.011s 0.005s 09 0 0 0 3 0.007s 0.003s 10 0 0 0 38 0.002s 0.001s 11 0 0 0 5 0.062s 0.024s 12 0 0 0 5 0.006s 0.004s 13 0 0 0 3 0.062s 0.021s 14 0 0 0 5 0.005s 0.003s 15 0 0 0 5 0.002s 0.002s 16 0 0 0 5 0.007s 0.005s 17 0 0 0 5 0.015s 0.01s 18 0 0 0 30 0.063s 0.017s 19 0 0 0 5 0.031s 0.023s 20 0 0 0 28 0.003s 0.004s 21 0 0 0 19 0.063s 0.031s 22 0 0 0 5 0.006s 0.006s 23 0 0 0 70 0.004s 0.004s Day Hour Count Avg time (sec) Sep 27 00 0 0s 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 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Sep 27 00 58,954.00 kB 58,954.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 20,001.50 kB 28,529.50 kB 04 0.00 kB 0.00 kB 05 5,928.88 kB 10,120.25 kB 06 7,988.00 kB 10,187.00 kB 07 1,313.40 kB 8,040.00 kB 08 98.50 kB 5,533.00 kB 09 189.00 kB 4,737.00 kB 10 927.00 kB 4,356.00 kB 11 96.00 kB 3,734.50 kB 12 95.50 kB 3,043.00 kB 13 190.00 kB 2,622.00 kB 14 95.00 kB 2,260.00 kB 15 95.50 kB 1,842.00 kB 16 95.50 kB 1,510.50 kB 17 96.00 kB 1,240.50 kB 18 446.33 kB 1,072.67 kB 19 95.00 kB 845.00 kB 20 209.25 kB 673.50 kB 21 87.00 kB 511.00 kB 22 95.50 kB 407.00 kB 23 168.00 kB 365.00 kB -
Temporary Files
Size of temporary files
Key values
- 495.20 MiB Temp Files size Peak
- 2026-09-27 05:31:56 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-27 05:32:03 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 27 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.32 GiB 67.39 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.02 GiB 36.92 MiB 247.60 MiB 64.99 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-27 05:32:05 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-27 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 307.90 MiB 57.22 MiB 94.17 MiB 76.98 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-27 05:30:42 Duration: 39s298ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-27 05:30:39 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 247.60 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-27 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 247.60 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-27 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 94.17 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-27 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 94.17 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-27 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 62.33 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-27 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 57.22 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-27 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 40.94 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-27 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 40.87 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-27 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 40.87 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-27 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.87 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-27 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.86 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-27 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.86 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-27 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.86 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-27 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 37.00 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-27 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 36.94 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-27 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 36.94 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-27 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 36.93 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-27 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 36.93 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-27 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 36.92 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-27 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 36.92 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-27 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.31 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-09-27 05:11:34 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.31 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-09-27 05:11:34 Date
Analyzes per table
Key values
- public.temp0000292598 (1) Main table analyzed (database rio)
- 1 analyzes Total
Vacuums per table
Key values
- pg_toast.pg_toast_2619 (1) Main table vacuumed on database rio
- 7 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 868 198 1,169,764 138 484 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,540 259 1,199,339 237 1,651 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,463 767 3,355,929 717 4,436 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,118 9 165,150 3 29 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 129 7 25,406 2 9 rio.public.temp0000292598 1 0 0 0 0 0 0 82 6 5,743 0 0 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 164 27 71,967 10 20 Total 7 6 0 0 0 0 0 9,364 1,273 5,993,298 1,107 6,629 Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.31) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_toast.pg_toast_2619 0 0 0.07 brasilia.pg_catalog.pg_statistic 0 0 0.19 rio.pg_catalog.pg_statistic 0 0 0.31 contagem.pg_catalog.pg_statistic 0 0 0.06 contagem.pg_toast.pg_toast_2619 0 0 0.01 rio.public.temp0000292598 0 0 0 brasilia.pg_toast.pg_toast_2619 0 0 0.01 Total 0 0 0.65 Tuples removed per table
Key values
- pg_catalog.pg_statistic (4642) Main table with removed tuples on database rio
- 13861 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,642 7,464 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,404 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,962 7,360 0 0 1,072 rio.pg_toast.pg_toast_2619 1 1 641 677 0 19 260 brasilia.pg_toast.pg_toast_2619 1 1 107 136 0 11 56 contagem.pg_toast.pg_toast_2619 1 1 105 117 0 11 47 rio.public.temp0000292598 1 0 0 1,249 0 54 74 Total 7 6 13,861 24,277 0 95 3,806 Pages removed per table
Key values
- public.temp0000292598 (54) Main table with removed pages on database rio
- 95 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000292598 1 0 0 54 rio.pg_toast.pg_toast_2619 1 1 641 19 contagem.pg_toast.pg_toast_2619 1 1 105 11 brasilia.pg_toast.pg_toast_2619 1 1 107 11 brasilia.pg_catalog.pg_statistic 1 1 3962 0 rio.pg_catalog.pg_statistic 1 1 4642 0 contagem.pg_catalog.pg_statistic 1 1 4404 0 Total 7 6 13,861 95 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 27 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 0 0 08 0 0 09 0 0 10 1 1 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0.31 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
- 173 Total read queries
- 402 Total write queries
Queries by database
Key values
- rio Main database
- 413 Requests
- 2h35m15s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 809 Requests
User Request type Count Duration etiquetas Total 10 7s495ms others 1 266ms select 9 7s228ms intelifix Total 809 3h59m35s copy to 401 42m5s ddl 1 33s414ms others 255 34m2s select 152 2h42m54s lenon Total 12 59s716ms select 12 59s716ms Duration by user
Key values
- 3h59m35s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 10 7s495ms others 1 266ms select 9 7s228ms intelifix Total 809 3h59m35s copy to 401 42m5s ddl 1 33s414ms others 255 34m2s select 152 2h42m54s lenon Total 12 59s716ms select 12 59s716ms Queries by host
Key values
- [local] Main host
- 831 Requests
- 4h42s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 440 Requests
- 3h17m39s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-27 09:10:47 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 341 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 11m18s analyze verbose;[ Date: 2026-09-27 05:11:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-27 20:13:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-27 07:13:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 7m38s analyze verbose;[ Date: 2026-09-27 05:18:58 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
5 6m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-27 21:11:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-27 09:10:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-27 14:10:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-27 19:10:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-27 22:10:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-27 10:10:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-27 13:10:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-27 17:10:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-27 08:10:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-27 12:10:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-27 18:10:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-27 16:10:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-27 11:10:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-27 15:10:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 4m2s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-09-27 07:20:35 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m43s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-09-27 20:20:02 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h36m42s 48 2s79ms 8m52s 2m select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 27 07 3 9m50s 3m16s 08 3 5m26s 1m48s 09 3 5m32s 1m50s 10 3 5m28s 1m49s 11 3 5m23s 1m47s 12 3 5m25s 1m48s 13 3 5m27s 1m49s 14 3 5m31s 1m50s 15 3 5m24s 1m48s 16 3 5m24s 1m48s 17 3 5m27s 1m49s 18 3 5m24s 1m48s 19 3 5m30s 1m50s 20 3 9m27s 3m9s 21 3 6m29s 2m9s 22 3 5m28s 1m49s [ User: intelifix - Total duration: 1h36m42s - Times executed: 48 ]
[ Application: psql - Total duration: 1h36m42s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-27 20:13:54 Duration: 8m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-27 07:13:53 Duration: 8m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-27 21:11:13 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: psql
2 1h5m50s 48 215ms 4m2s 1m22s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 27 07 3 5m54s 1m58s 08 3 3m51s 1m17s 09 3 3m52s 1m17s 10 3 3m50s 1m16s 11 3 3m51s 1m17s 12 3 3m50s 1m16s 13 3 3m51s 1m17s 14 3 3m51s 1m17s 15 3 3m50s 1m16s 16 3 3m49s 1m16s 17 3 3m53s 1m17s 18 3 3m50s 1m16s 19 3 3m54s 1m18s 20 3 5m43s 1m54s 21 3 3m57s 1m19s 22 3 3m56s 1m18s [ User: intelifix - Total duration: 1h5m50s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m50s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-27 07:20:35 Duration: 4m2s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-27 20:20:02 Duration: 3m43s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-27 22:14:24 Duration: 3m27s Database: brasilia User: intelifix Remote: [local] Application: psql
3 22m3s 3 3m6s 11m18s 7m21s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 27 05 3 22m3s 7m21s [ User: intelifix - Total duration: 22m3s - Times executed: 3 ]
[ Application: psql - Total duration: 22m3s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-27 05:11:20 Duration: 11m18s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-27 05:18:58 Duration: 7m38s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-27 05:22:04 Duration: 3m6s Database: contagem User: intelifix Remote: [local] Application: psql
4 7m44s 145 188ms 14s332ms 3s205ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 27 00 8 32s814ms 4s101ms 01 6 19s252ms 3s208ms 02 6 19s509ms 3s251ms 03 6 19s249ms 3s208ms 04 6 18s811ms 3s135ms 05 6 19s22ms 3s170ms 06 6 18s614ms 3s102ms 07 6 18s886ms 3s147ms 08 6 18s779ms 3s129ms 09 6 18s605ms 3s100ms 10 6 19s11ms 3s168ms 11 6 18s311ms 3s51ms 12 6 19s268ms 3s211ms 13 6 18s680ms 3s113ms 14 6 18s449ms 3s74ms 15 6 18s821ms 3s136ms 16 6 18s717ms 3s119ms 17 6 18s683ms 3s113ms 18 6 18s861ms 3s143ms 19 6 18s948ms 3s158ms 20 10 35s49ms 3s504ms 21 7 19s423ms 2s774ms 22 6 18s974ms 3s162ms [ User: intelifix - Total duration: 7m44s - Times executed: 145 ]
[ Application: psql - Total duration: 7m44s - Times executed: 145 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-27 00:05:16 Duration: 14s332ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-27 20:05:13 Duration: 10s653ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-27 20:15:09 Duration: 8s142ms Database: rio User: intelifix Remote: [local] Application: psql
5 2m19s 4 4s820ms 1m6s 34s955ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 27 20 2 1m11s 35s525ms 23 2 1m8s 34s384ms [ User: intelifix - Total duration: 2m19s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m19s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-27 20:08:48 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-27 23:16:44 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-27 23:34:08 Duration: 4s999ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 1m47s 6 3s408ms 40s41ms 17s971ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 27 20 3 53s968ms 17s989ms 23 3 53s858ms 17s952ms [ User: intelifix - Total duration: 1m47s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-27 20:06:31 Duration: 40s41ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-27 23:14:29 Duration: 39s776ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-27 23:33:42 Duration: 10s616ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 1m46s 4 349ms 53s55ms 26s590ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 27 20 2 53s404ms 26s702ms 23 2 52s957ms 26s478ms [ User: intelifix - Total duration: 1m46s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-27 20:05:46 Duration: 53s55ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-27 23:13:45 Duration: 52s594ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-27 23:33:31 Duration: 363ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 1m23s 6 2s265ms 31s895ms 13s967ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 27 20 3 41s962ms 13s987ms 23 3 41s842ms 13s947ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-27 20:07:05 Duration: 31s895ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-27 23:15:04 Duration: 31s740ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-27 23:33:51 Duration: 7s836ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 1m22s 1 1m22s 1m22s 1m22s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 27 05 1 1m22s 1m22s [ User: intelifix - Total duration: 1m22s - Times executed: 1 ]
[ Application: psql - Total duration: 1m22s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-27 05:32:05 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-27 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
10 1m22s 6 3s77ms 31s806ms 13s778ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 27 20 3 41s257ms 13s752ms 23 3 41s415ms 13s805ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-27 23:17:16 Duration: 31s806ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-27 20:09:20 Duration: 31s644ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-27 23:34:14 Duration: 6s531ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 1m11s 6 2s467ms 23s570ms 11s923ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 27 20 3 35s793ms 11s931ms 23 3 35s747ms 11s915ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-27 23:10:49 Duration: 23s570ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-27 20:02:50 Duration: 23s464ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-27 20:09:41 Duration: 9s861ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 1m10s 6 2s257ms 24s149ms 11s829ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 27 20 3 35s370ms 11s790ms 23 3 35s607ms 11s869ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-27 23:11:30 Duration: 24s149ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-27 20:03:31 Duration: 23s938ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-27 23:33:11 Duration: 9s200ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1m5s 6 1s747ms 25s355ms 10s838ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 27 20 3 32s356ms 10s785ms 23 3 32s676ms 10s892ms [ User: intelifix - Total duration: 1m5s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m5s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-27 23:12:29 Duration: 25s355ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-27 20:04:29 Duration: 25s28ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-27 23:33:27 Duration: 5s573ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 57s893ms 6 3s152ms 21s283ms 9s648ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 27 00 3 29s415ms 9s805ms 06 3 28s477ms 9s492ms [ User: lenon - Total duration: 57s893ms - Times executed: 6 ]
[ Application: psql - Total duration: 57s893ms - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-27 00:02:24 Duration: 21s283ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-27 06:02:22 Duration: 20s382ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-27 00:02:29 Duration: 4s979ms Database: brasilia User: lenon Remote: [local] Application: psql
15 55s774ms 4 4s226ms 23s782ms 13s943ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 27 20 2 28s132ms 14s66ms 23 2 27s642ms 13s821ms [ User: intelifix - Total duration: 55s774ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s774ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-27 20:04:53 Duration: 23s782ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-27 23:12:53 Duration: 23s415ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-27 20:10:13 Duration: 4s350ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 51s687ms 6 1s826ms 16s944ms 8s614ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 27 20 3 25s684ms 8s561ms 23 3 26s2ms 8s667ms [ User: intelifix - Total duration: 51s687ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s687ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-27 23:11:47 Duration: 16s944ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-27 20:03:48 Duration: 16s668ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-27 23:33:18 Duration: 7s197ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 48s736ms 6 6s87ms 10s941ms 8s122ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 27 00 3 29s372ms 9s790ms 06 3 19s364ms 6s454ms [ User: intelifix - Total duration: 48s736ms - Times executed: 6 ]
[ Application: psql - Total duration: 48s736ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-27 00:05:12 Duration: 10s941ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-27 00:05:31 Duration: 9s674ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-27 00:05:21 Duration: 8s757ms Database: brasilia User: intelifix Remote: [local] Application: psql
18 48s465ms 61 568ms 1s483ms 794ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 27 08 4 3s688ms 922ms 09 4 2s846ms 711ms 10 4 3s251ms 812ms 11 4 2s922ms 730ms 12 4 3s192ms 798ms 13 4 2s808ms 702ms 14 4 3s942ms 985ms 15 4 3s1ms 750ms 16 4 3s441ms 860ms 17 4 3s279ms 819ms 18 5 3s951ms 790ms 19 4 2s753ms 688ms 20 4 3s224ms 806ms 21 4 3s85ms 771ms 22 4 3s74ms 768ms [ User: intelifix - Total duration: 48s465ms - Times executed: 61 ]
[ Application: psql - Total duration: 48s465ms - Times executed: 61 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-27 08:00:07 Duration: 1s483ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-27 14:00:03 Duration: 1s417ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-27 16:20:02 Duration: 1s57ms Database: rio User: intelifix Remote: [local] Application: psql
19 41s398ms 6 1s80ms 17s49ms 6s899ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 27 20 3 20s769ms 6s923ms 23 3 20s628ms 6s876ms [ User: intelifix - Total duration: 41s398ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s398ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-27 20:03:07 Duration: 17s49ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-27 23:11:06 Duration: 16s843ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-27 20:09:44 Duration: 2s639ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 39s298ms 1 39s298ms 39s298ms 39s298ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 27 05 1 39s298ms 39s298ms [ User: intelifix - Total duration: 39s298ms - Times executed: 1 ]
[ Application: psql - Total duration: 39s298ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-27 05:30:42 Duration: 39s298ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-27 05:30:39 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 145 7m44s 188ms 14s332ms 3s205ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 27 00 8 32s814ms 4s101ms 01 6 19s252ms 3s208ms 02 6 19s509ms 3s251ms 03 6 19s249ms 3s208ms 04 6 18s811ms 3s135ms 05 6 19s22ms 3s170ms 06 6 18s614ms 3s102ms 07 6 18s886ms 3s147ms 08 6 18s779ms 3s129ms 09 6 18s605ms 3s100ms 10 6 19s11ms 3s168ms 11 6 18s311ms 3s51ms 12 6 19s268ms 3s211ms 13 6 18s680ms 3s113ms 14 6 18s449ms 3s74ms 15 6 18s821ms 3s136ms 16 6 18s717ms 3s119ms 17 6 18s683ms 3s113ms 18 6 18s861ms 3s143ms 19 6 18s948ms 3s158ms 20 10 35s49ms 3s504ms 21 7 19s423ms 2s774ms 22 6 18s974ms 3s162ms [ User: intelifix - Total duration: 7m44s - Times executed: 145 ]
[ Application: psql - Total duration: 7m44s - Times executed: 145 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-27 00:05:16 Duration: 14s332ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-27 20:05:13 Duration: 10s653ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-27 20:15:09 Duration: 8s142ms Database: rio User: intelifix Remote: [local] Application: psql
2 61 48s465ms 568ms 1s483ms 794ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 27 08 4 3s688ms 922ms 09 4 2s846ms 711ms 10 4 3s251ms 812ms 11 4 2s922ms 730ms 12 4 3s192ms 798ms 13 4 2s808ms 702ms 14 4 3s942ms 985ms 15 4 3s1ms 750ms 16 4 3s441ms 860ms 17 4 3s279ms 819ms 18 5 3s951ms 790ms 19 4 2s753ms 688ms 20 4 3s224ms 806ms 21 4 3s85ms 771ms 22 4 3s74ms 768ms [ User: intelifix - Total duration: 48s465ms - Times executed: 61 ]
[ Application: psql - Total duration: 48s465ms - Times executed: 61 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-27 08:00:07 Duration: 1s483ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-27 14:00:03 Duration: 1s417ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-27 16:20:02 Duration: 1s57ms Database: rio User: intelifix Remote: [local] Application: psql
3 48 1h36m42s 2s79ms 8m52s 2m select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 27 07 3 9m50s 3m16s 08 3 5m26s 1m48s 09 3 5m32s 1m50s 10 3 5m28s 1m49s 11 3 5m23s 1m47s 12 3 5m25s 1m48s 13 3 5m27s 1m49s 14 3 5m31s 1m50s 15 3 5m24s 1m48s 16 3 5m24s 1m48s 17 3 5m27s 1m49s 18 3 5m24s 1m48s 19 3 5m30s 1m50s 20 3 9m27s 3m9s 21 3 6m29s 2m9s 22 3 5m28s 1m49s [ User: intelifix - Total duration: 1h36m42s - Times executed: 48 ]
[ Application: psql - Total duration: 1h36m42s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-27 20:13:54 Duration: 8m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-27 07:13:53 Duration: 8m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-27 21:11:13 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: psql
4 48 1h5m50s 215ms 4m2s 1m22s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 27 07 3 5m54s 1m58s 08 3 3m51s 1m17s 09 3 3m52s 1m17s 10 3 3m50s 1m16s 11 3 3m51s 1m17s 12 3 3m50s 1m16s 13 3 3m51s 1m17s 14 3 3m51s 1m17s 15 3 3m50s 1m16s 16 3 3m49s 1m16s 17 3 3m53s 1m17s 18 3 3m50s 1m16s 19 3 3m54s 1m18s 20 3 5m43s 1m54s 21 3 3m57s 1m19s 22 3 3m56s 1m18s [ User: intelifix - Total duration: 1h5m50s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m50s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-27 07:20:35 Duration: 4m2s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-27 20:20:02 Duration: 3m43s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-27 22:14:24 Duration: 3m27s Database: brasilia User: intelifix Remote: [local] Application: psql
5 29 28s319ms 695ms 4s499ms 976ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 27 08 2 5s324ms 2s662ms 09 2 1s658ms 829ms 10 2 1s540ms 770ms 11 2 1s483ms 741ms 12 2 1s612ms 806ms 13 2 1s572ms 786ms 14 2 1s638ms 819ms 15 2 1s632ms 816ms 16 2 1s608ms 804ms 17 2 1s560ms 780ms 18 1 863ms 863ms 19 2 1s599ms 799ms 20 2 2s798ms 1s399ms 21 2 1s672ms 836ms 22 2 1s754ms 877ms [ User: intelifix - Total duration: 28s319ms - Times executed: 29 ]
[ Application: psql - Total duration: 28s319ms - Times executed: 29 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-27 08:00:06 Duration: 4s499ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-27 20:20:02 Duration: 1s946ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-27 22:40:02 Duration: 910ms Database: rio User: intelifix Remote: [local] Application: psql
6 7 3s151ms 297ms 601ms 450ms select p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault(?, p.proowner) as acldefault, p.pronamespace, p.proowner from pg_proc p left join pg_init_privs pip on (p.oid = pip.objoid and pip.classoid = ?::regclass and pip.objsubid = ?) where p.prokind <> ? and not exists ( select ? from pg_depend where classid = ?::regclass and objid = p.oid and deptype = ?) and (pronamespace != ( select oid from pg_namespace where nspname = ?) or exists ( select ? from pg_cast where pg_cast.oid > ? and p.oid = pg_cast.castfunc) or exists ( select ? from pg_transform where pg_transform.oid > ? and (p.oid = pg_transform.trffromsql or p.oid = pg_transform.trftosql)) or p.proacl is distinct from pip.initprivs);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 27 20 3 1s411ms 470ms 23 4 1s739ms 434ms [ User: intelifix - Total duration: 3s151ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 3s151ms - Times executed: 7 ]
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-09-27 20:02:04 Duration: 601ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-09-27 23:17:18 Duration: 577ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-09-27 20:09:22 Duration: 512ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 7 2s479ms 221ms 565ms 354ms select c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( case when c.relkind = ? then ?::"char" else ?::"char" end, c.relowner) as acldefault, case when c.relkind = ? then ( select ftserver from pg_catalog.pg_foreign_table where ftrelid = c.oid) else ? end as foreignserver, c.relfrozenxid, tc.relfrozenxid as tfrozenxid, tc.oid as toid, tc.relpages as toastpages, tc.reloptions as toast_reloptions, d.refobjid as owning_tab, d.refobjsubid as owning_col, tsp.spcname as reltablespace, false as relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid as tminmxid, array_remove(array_remove(c.reloptions, ?), ?) as reloptions, case when ? = any (c.reloptions) then ?::text when ? = any (c.reloptions) then ?::text else null end as checkoption, am.amname, (d.deptype = ?) is true as is_identity_sequence, c.relispartition as ispartition from pg_class c left join pg_depend d on (c.relkind = ? and d.classid = ?::regclass and d.objid = c.oid and d.objsubid = ? and d.refclassid = ?::regclass and d.deptype in (...)) left join pg_tablespace tsp on (tsp.oid = c.reltablespace) left join pg_am am on (c.relam = am.oid) left join pg_class tc on (c.reltoastrelid = tc.oid and tc.relkind = ? and c.relkind <> ?) where c.relkind in (...) order by c.oid;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 27 20 3 901ms 300ms 23 4 1s577ms 394ms [ User: intelifix - Total duration: 2s479ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 2s479ms - Times executed: 7 ]
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-09-27 23:10:02 Duration: 565ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-09-27 20:09:21 Duration: 408ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-09-27 23:17:18 Duration: 365ms Database: rio User: intelifix Remote: [local] Application: pg_dump
8 6 1m47s 3s408ms 40s41ms 17s971ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 27 20 3 53s968ms 17s989ms 23 3 53s858ms 17s952ms [ User: intelifix - Total duration: 1m47s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-27 20:06:31 Duration: 40s41ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-27 23:14:29 Duration: 39s776ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-27 23:33:42 Duration: 10s616ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 6 1m23s 2s265ms 31s895ms 13s967ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 27 20 3 41s962ms 13s987ms 23 3 41s842ms 13s947ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-27 20:07:05 Duration: 31s895ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-27 23:15:04 Duration: 31s740ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-27 23:33:51 Duration: 7s836ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 6 1m22s 3s77ms 31s806ms 13s778ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 27 20 3 41s257ms 13s752ms 23 3 41s415ms 13s805ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-27 23:17:16 Duration: 31s806ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-27 20:09:20 Duration: 31s644ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-27 23:34:14 Duration: 6s531ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 6 1m11s 2s467ms 23s570ms 11s923ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 27 20 3 35s793ms 11s931ms 23 3 35s747ms 11s915ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-27 23:10:49 Duration: 23s570ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-27 20:02:50 Duration: 23s464ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-27 20:09:41 Duration: 9s861ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 6 1m10s 2s257ms 24s149ms 11s829ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 27 20 3 35s370ms 11s790ms 23 3 35s607ms 11s869ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-27 23:11:30 Duration: 24s149ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-27 20:03:31 Duration: 23s938ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-27 23:33:11 Duration: 9s200ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 6 1m5s 1s747ms 25s355ms 10s838ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 27 20 3 32s356ms 10s785ms 23 3 32s676ms 10s892ms [ User: intelifix - Total duration: 1m5s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m5s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-27 23:12:29 Duration: 25s355ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-27 20:04:29 Duration: 25s28ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-27 23:33:27 Duration: 5s573ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 6 57s893ms 3s152ms 21s283ms 9s648ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 27 00 3 29s415ms 9s805ms 06 3 28s477ms 9s492ms [ User: lenon - Total duration: 57s893ms - Times executed: 6 ]
[ Application: psql - Total duration: 57s893ms - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-27 00:02:24 Duration: 21s283ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-27 06:02:22 Duration: 20s382ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-27 00:02:29 Duration: 4s979ms Database: brasilia User: lenon Remote: [local] Application: psql
15 6 51s687ms 1s826ms 16s944ms 8s614ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 27 20 3 25s684ms 8s561ms 23 3 26s2ms 8s667ms [ User: intelifix - Total duration: 51s687ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s687ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-27 23:11:47 Duration: 16s944ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-27 20:03:48 Duration: 16s668ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-27 23:33:18 Duration: 7s197ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 6 48s736ms 6s87ms 10s941ms 8s122ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 27 00 3 29s372ms 9s790ms 06 3 19s364ms 6s454ms [ User: intelifix - Total duration: 48s736ms - Times executed: 6 ]
[ Application: psql - Total duration: 48s736ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-27 00:05:12 Duration: 10s941ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-27 00:05:31 Duration: 9s674ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-27 00:05:21 Duration: 8s757ms Database: brasilia User: intelifix Remote: [local] Application: psql
17 6 41s398ms 1s80ms 17s49ms 6s899ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 27 20 3 20s769ms 6s923ms 23 3 20s628ms 6s876ms [ User: intelifix - Total duration: 41s398ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s398ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-27 20:03:07 Duration: 17s49ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-27 23:11:06 Duration: 16s843ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-27 20:09:44 Duration: 2s639ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 6 28s778ms 871ms 12s580ms 4s796ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 27 20 3 14s357ms 4s785ms 23 3 14s421ms 4s807ms [ User: intelifix - Total duration: 28s778ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 28s778ms - Times executed: 6 ]
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-09-27 23:12:04 Duration: 12s580ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-09-27 20:04:04 Duration: 12s462ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-09-27 20:10:03 Duration: 999ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 6 27s476ms 1s 10s488ms 4s579ms copy public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 27 20 3 13s734ms 4s578ms 23 3 13s741ms 4s580ms [ User: intelifix - Total duration: 27s476ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s476ms - Times executed: 6 ]
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-09-27 23:10:21 Duration: 10s488ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-09-27 20:02:22 Duration: 10s389ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-09-27 20:09:31 Duration: 2s334ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 6 27s472ms 2s816ms 5s586ms 4s578ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 27 20 3 13s645ms 4s548ms 23 3 13s827ms 4s609ms [ User: intelifix - Total duration: 27s472ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s472ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-09-27 20:07:29 Duration: 5s586ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-09-27 23:15:28 Duration: 5s564ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-09-27 20:10:42 Duration: 5s242ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m6s 11m18s 7m21s 3 22m3s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 27 05 3 22m3s 7m21s [ User: intelifix - Total duration: 22m3s - Times executed: 3 ]
[ Application: psql - Total duration: 22m3s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-27 05:11:20 Duration: 11m18s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-27 05:18:58 Duration: 7m38s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-27 05:22:04 Duration: 3m6s Database: contagem User: intelifix Remote: [local] Application: psql
2 2s79ms 8m52s 2m 48 1h36m42s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 27 07 3 9m50s 3m16s 08 3 5m26s 1m48s 09 3 5m32s 1m50s 10 3 5m28s 1m49s 11 3 5m23s 1m47s 12 3 5m25s 1m48s 13 3 5m27s 1m49s 14 3 5m31s 1m50s 15 3 5m24s 1m48s 16 3 5m24s 1m48s 17 3 5m27s 1m49s 18 3 5m24s 1m48s 19 3 5m30s 1m50s 20 3 9m27s 3m9s 21 3 6m29s 2m9s 22 3 5m28s 1m49s [ User: intelifix - Total duration: 1h36m42s - Times executed: 48 ]
[ Application: psql - Total duration: 1h36m42s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-27 20:13:54 Duration: 8m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-27 07:13:53 Duration: 8m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-27 21:11:13 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: psql
3 1m22s 1m22s 1m22s 1 1m22s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 27 05 1 1m22s 1m22s [ User: intelifix - Total duration: 1m22s - Times executed: 1 ]
[ Application: psql - Total duration: 1m22s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-27 05:32:05 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-27 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 215ms 4m2s 1m22s 48 1h5m50s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 27 07 3 5m54s 1m58s 08 3 3m51s 1m17s 09 3 3m52s 1m17s 10 3 3m50s 1m16s 11 3 3m51s 1m17s 12 3 3m50s 1m16s 13 3 3m51s 1m17s 14 3 3m51s 1m17s 15 3 3m50s 1m16s 16 3 3m49s 1m16s 17 3 3m53s 1m17s 18 3 3m50s 1m16s 19 3 3m54s 1m18s 20 3 5m43s 1m54s 21 3 3m57s 1m19s 22 3 3m56s 1m18s [ User: intelifix - Total duration: 1h5m50s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m50s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-27 07:20:35 Duration: 4m2s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-27 20:20:02 Duration: 3m43s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-27 22:14:24 Duration: 3m27s Database: brasilia User: intelifix Remote: [local] Application: psql
5 39s298ms 39s298ms 39s298ms 1 39s298ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 27 05 1 39s298ms 39s298ms [ User: intelifix - Total duration: 39s298ms - Times executed: 1 ]
[ Application: psql - Total duration: 39s298ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-27 05:30:42 Duration: 39s298ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-27 05:30:39 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
6 4s820ms 1m6s 34s955ms 4 2m19s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 27 20 2 1m11s 35s525ms 23 2 1m8s 34s384ms [ User: intelifix - Total duration: 2m19s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m19s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-27 20:08:48 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-27 23:16:44 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-27 23:34:08 Duration: 4s999ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 349ms 53s55ms 26s590ms 4 1m46s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 27 20 2 53s404ms 26s702ms 23 2 52s957ms 26s478ms [ User: intelifix - Total duration: 1m46s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-27 20:05:46 Duration: 53s55ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-27 23:13:45 Duration: 52s594ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-27 23:33:31 Duration: 363ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 3s408ms 40s41ms 17s971ms 6 1m47s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 27 20 3 53s968ms 17s989ms 23 3 53s858ms 17s952ms [ User: intelifix - Total duration: 1m47s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-27 20:06:31 Duration: 40s41ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-27 23:14:29 Duration: 39s776ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-27 23:33:42 Duration: 10s616ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 2s265ms 31s895ms 13s967ms 6 1m23s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 27 20 3 41s962ms 13s987ms 23 3 41s842ms 13s947ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-27 20:07:05 Duration: 31s895ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-27 23:15:04 Duration: 31s740ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-27 23:33:51 Duration: 7s836ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 4s226ms 23s782ms 13s943ms 4 55s774ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 27 20 2 28s132ms 14s66ms 23 2 27s642ms 13s821ms [ User: intelifix - Total duration: 55s774ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s774ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-27 20:04:53 Duration: 23s782ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-27 23:12:53 Duration: 23s415ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-27 20:10:13 Duration: 4s350ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 3s77ms 31s806ms 13s778ms 6 1m22s copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 27 20 3 41s257ms 13s752ms 23 3 41s415ms 13s805ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-27 23:17:16 Duration: 31s806ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-27 20:09:20 Duration: 31s644ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-27 23:34:14 Duration: 6s531ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 2s467ms 23s570ms 11s923ms 6 1m11s copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 27 20 3 35s793ms 11s931ms 23 3 35s747ms 11s915ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-27 23:10:49 Duration: 23s570ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-27 20:02:50 Duration: 23s464ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-27 20:09:41 Duration: 9s861ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 2s257ms 24s149ms 11s829ms 6 1m10s copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 27 20 3 35s370ms 11s790ms 23 3 35s607ms 11s869ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-27 23:11:30 Duration: 24s149ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-27 20:03:31 Duration: 23s938ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-27 23:33:11 Duration: 9s200ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1s747ms 25s355ms 10s838ms 6 1m5s copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 27 20 3 32s356ms 10s785ms 23 3 32s676ms 10s892ms [ User: intelifix - Total duration: 1m5s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m5s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-27 23:12:29 Duration: 25s355ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-27 20:04:29 Duration: 25s28ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-27 23:33:27 Duration: 5s573ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 3s152ms 21s283ms 9s648ms 6 57s893ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 27 00 3 29s415ms 9s805ms 06 3 28s477ms 9s492ms [ User: lenon - Total duration: 57s893ms - Times executed: 6 ]
[ Application: psql - Total duration: 57s893ms - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-27 00:02:24 Duration: 21s283ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-27 06:02:22 Duration: 20s382ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-27 00:02:29 Duration: 4s979ms Database: brasilia User: lenon Remote: [local] Application: psql
16 1s826ms 16s944ms 8s614ms 6 51s687ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 27 20 3 25s684ms 8s561ms 23 3 26s2ms 8s667ms [ User: intelifix - Total duration: 51s687ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s687ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-27 23:11:47 Duration: 16s944ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-27 20:03:48 Duration: 16s668ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-27 23:33:18 Duration: 7s197ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 6s87ms 10s941ms 8s122ms 6 48s736ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 27 00 3 29s372ms 9s790ms 06 3 19s364ms 6s454ms [ User: intelifix - Total duration: 48s736ms - Times executed: 6 ]
[ Application: psql - Total duration: 48s736ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-27 00:05:12 Duration: 10s941ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-27 00:05:31 Duration: 9s674ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-27 00:05:21 Duration: 8s757ms Database: brasilia User: intelifix Remote: [local] Application: psql
18 1s80ms 17s49ms 6s899ms 6 41s398ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 27 20 3 20s769ms 6s923ms 23 3 20s628ms 6s876ms [ User: intelifix - Total duration: 41s398ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s398ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-27 20:03:07 Duration: 17s49ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-27 23:11:06 Duration: 16s843ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-27 20:09:44 Duration: 2s639ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 871ms 12s580ms 4s796ms 6 28s778ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 27 20 3 14s357ms 4s785ms 23 3 14s421ms 4s807ms [ User: intelifix - Total duration: 28s778ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 28s778ms - Times executed: 6 ]
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-09-27 23:12:04 Duration: 12s580ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-09-27 20:04:04 Duration: 12s462ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-09-27 20:10:03 Duration: 999ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 1s 10s488ms 4s579ms 6 27s476ms copy public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 27 20 3 13s734ms 4s578ms 23 3 13s741ms 4s580ms [ User: intelifix - Total duration: 27s476ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s476ms - Times executed: 6 ]
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-09-27 23:10:21 Duration: 10s488ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-09-27 20:02:22 Duration: 10s389ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-09-27 20:09:31 Duration: 2s334ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 17 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 27 09 1 0ms 0ms 10 2 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 2 0ms 0ms 19 2 0ms 0ms 20 2 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 12m38s - Times executed: 17 ]
[ Application: psql - Total duration: 12m38s - Times executed: 17 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 4,792 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 27 FATAL entries
- 1426 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,422 Max number of times the same event was reported
- 1,454 Total events found
Rank Times reported Error 1 1,422 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 27 00 60 01 59 02 60 03 60 04 59 05 60 06 60 07 59 08 60 09 60 10 59 11 60 12 60 13 59 14 60 15 59 16 60 17 60 18 59 19 60 20 60 21 59 22 60 23 50 - ERROR: prepared statement "_PLAN0000000029DE76C0" does not exist
- ERROR: prepared statement "_PLAN0000000029DEB210" does not exist
- ERROR: prepared statement "_PLAN0000000029DEBFC0" does not exist
Statement: DEALLOCATE "_PLAN0000000029DE76C0"
Date: 2026-09-27 00:00:25 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029DEB210"
Date: 2026-09-27 00:01:26 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029DEBFC0"
Date: 2026-09-27 00:02:26 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 18 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 27 00 2 06 2 07 2 09 3 11 1 12 1 17 2 18 1 21 1 22 1 23 2 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-09-27 00:02:32 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-27 00:42:40 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-27 06:02:30 Database: testes Application: [unknown] User: lenon Remote: [local]
3 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 27 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-27 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-27 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-27 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
4 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 27 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-27 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-27 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-27 05:32:05 Database: contagem Application: psql User: intelifix Remote: [local]
5 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 27 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-09-27 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-27 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
6 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 27 03 1 - LOG: database system was shut down at 2026-09-27 03:05:02 -03
Date: 2026-09-27 03:05:02