pgBadger-
Global information
- Generated on Sun Sep 13 23:50:13 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 20,904 log entries in 11s
- Log start from 2026-09-13 00:00:29 to 2026-09-13 23:49:29
-
Overview
Global Stats
- 154 Number of unique normalized queries
- 929 Number of queries
- 3h58m19s Total query duration
- 2026-09-13 00:02:11 First query
- 2026-09-13 23:49:25 Last query
- 5 queries/s at 2026-09-13 23:42:25 Query peak
- 3h58m19s Total query duration
- 310ms Prepare/parse total duration
- 0ms Bind total duration
- 3h58m19s Execute total duration
- 4,002 Number of events
- 6 Number of unique normalized events
- 3,978 Max number of times the same event was reported
- 0 Number of cancellation
- 8 Total number of automatic vacuums
- 2 Total number of automatic analyzes
- 20 Number temporary file
- 245.55 MiB Max size of temporary file
- 66.84 MiB Average size of temporary file
- 442 Total number of sessions
- 7 sessions at 2026-09-13 06:52:31 Session peak
- 9d14h38m11s Total duration of sessions
- 31m18s Average duration of sessions
- 2 Average queries per session
- 32s352ms Average queries duration per session
- 30m46s Average idle time per session
- 448 Total number of connections
- 4 connections/s at 2026-09-13 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-13 23:42:25 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-09-13 14:14:23 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-13 23:42:25 Date
Queries duration
Key values
- 3h58m19s 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 13 00 22 0ms 16s333ms 3s693ms 2s251ms 2s550ms 56s672ms 01 10 0ms 2s163ms 1s326ms 2s152ms 2s226ms 2s272ms 02 9 0ms 2s225ms 1s501ms 2s172ms 2s225ms 2s365ms 03 10 0ms 2s597ms 1s232ms 407ms 2s326ms 2s781ms 04 10 0ms 2s544ms 1s443ms 2s120ms 2s387ms 2s751ms 05 16 0ms 10m29s 1m20s 2s660ms 2m49s 10m29s 06 18 0ms 10s237ms 2s973ms 2s513ms 2s794ms 27s99ms 07 15 0ms 9m 1m2s 2s463ms 1m44s 9m 08 20 0ms 5m4s 29s253ms 2s432ms 5s223ms 5m47s 09 21 0ms 5m 27s538ms 2s475ms 2s942ms 5m45s 10 22 0ms 5m10s 26s933ms 2s541ms 2s926ms 5m53s 11 23 0ms 5m5s 25s556ms 2s493ms 3s11ms 5m50s 12 22 0ms 5m4s 26s449ms 2s334ms 2s840ms 5m48s 13 22 0ms 4m59s 26s375ms 2s422ms 2s786ms 5m44s 14 41 0ms 5m3s 16s93ms 2s724ms 49s421ms 5m48s 15 21 0ms 5m4s 27s575ms 2s434ms 2s793ms 5m49s 16 23 0ms 4m56s 25s296ms 2s614ms 45s365ms 4m56s 17 22 0ms 5m9s 26s963ms 2s468ms 2s942ms 5m53s 18 26 0ms 4m57s 22s128ms 2s433ms 44s745ms 4m57s 19 21 0ms 5m 27s416ms 2s342ms 2s570ms 5m45s 20 130 0ms 10m30s 12s529ms 1m5s 2m25s 10m42s 21 23 0ms 6m4s 27s544ms 2s351ms 4s978ms 6m46s 22 21 0ms 4m58s 27s845ms 2s396ms 4s490ms 5m43s 23 361 0ms 1m2s 5s438ms 1m5s 1m10s 1m16s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 13 00 4 0 3s299ms 0ms 0ms 183ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 163ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 3 0 4s506ms 0ms 0ms 0ms 07 6 0 2m33s 0ms 0ms 4m7s 08 6 0 1m33s 0ms 0ms 3m34s 09 6 0 1m33s 0ms 0ms 3m33s 10 6 0 1m35s 0ms 0ms 3m38s 11 6 0 1m34s 0ms 0ms 3m37s 12 6 0 1m33s 0ms 0ms 3m34s 13 6 0 1m33s 0ms 0ms 3m36s 14 21 0 28s85ms 0ms 998ms 3m36s 15 6 0 1m33s 0ms 0ms 3m29s 16 6 0 1m33s 0ms 0ms 3m38s 17 6 0 1m35s 0ms 0ms 3m40s 18 9 0 1m1s 0ms 0ms 3m30s 19 6 0 1m32s 0ms 0ms 3m31s 20 24 81 15s76ms 42s775ms 1m2s 3m57s 21 7 0 1m27s 0ms 0ms 3m25s 22 6 0 1m33s 0ms 0ms 3m39s 23 38 323 5s438ms 1m2s 1m5s 1m13s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 13 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 13 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 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.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 3 3.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 2 2.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 1 12 12.00 0.28% Day Hour Count Average / Second Sep 13 00 27 0.01/s 01 15 0.00/s 02 18 0.01/s 03 21 0.01/s 04 17 0.00/s 05 15 0.00/s 06 24 0.01/s 07 23 0.01/s 08 18 0.01/s 09 17 0.00/s 10 19 0.01/s 11 17 0.00/s 12 19 0.01/s 13 17 0.00/s 14 18 0.01/s 15 17 0.00/s 16 18 0.01/s 17 17 0.00/s 18 18 0.01/s 19 21 0.01/s 20 20 0.01/s 21 17 0.00/s 22 15 0.00/s 23 20 0.01/s Day Hour Count Average Duration Average idle time Sep 13 00 17 23m43s 23m39s 01 20 44m52s 44m51s 02 18 33m31s 33m30s 03 22 16m47s 16m46s 04 17 32m42s 32m42s 05 14 38m4s 36m32s 06 18 34m52s 34m49s 07 28 31m55s 31m21s 08 18 32m59s 32m27s 09 18 29m49s 29m17s 10 18 26m42s 26m9s 11 17 30m18s 29m43s 12 19 27m48s 27m18s 13 16 33m14s 32m37s 14 15 37m8s 36m24s 15 20 39m10s 38m41s 16 18 30m3s 29m30s 17 16 34m3s 33m26s 18 19 32m3s 31m32s 19 21 26m3s 25m36s 20 19 28m55s 27m29s 21 17 34m53s 34m16s 22 15 36m12s 35m33s 23 22 22m38s 21m9s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-09-13 03:05:16 Date
Connections per database
Key values
- brasilia Main Database
- 448 connections Total
Connections per user
Key values
- etiquetas Main User
- 448 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-09-13 06:52:31 Date
Histogram of session times
Key values
- 197 3600000-28800000ms duration
Sessions per database
Key values
- brasilia Main Database
- 442 sessions Total
Sessions per user
Key values
- etiquetas Main User
- 442 sessions Total
Sessions per host
Key values
- [local] Main Host
- 442 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 10,064 buffers Checkpoint Peak
- 2026-09-13 03:05:01 Date
- 269.728 seconds Highest write time
- 0.274 seconds Sync time
Checkpoints Wal files
Key values
- 4 files Wal files usage Peak
- 2026-09-13 03:05:01 Date
Checkpoints distance
Key values
- 109.70 Mo Distance Peak
- 2026-09-13 03:05:01 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 13 00 5,657 269.728s 0.015s 269.748s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 10,064 0.23s 0.276s 0.529s 04 0 0s 0s 0s 05 6,567 664.117s 0.119s 664.323s 06 1,872 187.696s 0.006s 187.715s 07 739 130.66s 0.002s 130.666s 08 34 3.424s 0.021s 3.45s 09 25 2.523s 0.004s 2.535s 10 25 2.52s 0.006s 2.542s 11 26 2.621s 0.005s 2.632s 12 404 40.405s 0.009s 40.419s 13 37 3.723s 0.047s 3.777s 14 270 27.099s 0.011s 27.123s 15 25 2.527s 0.004s 2.539s 16 25 2.52s 0.005s 2.53s 17 24 2.422s 0.039s 2.486s 18 1,008 100.86s 0.065s 101.019s 19 24 2.421s 0.105s 2.541s 20 54 5.439s 0.023s 5.516s 21 72 7.237s 0.075s 7.341s 22 25 2.519s 0.051s 2.596s 23 37 3.72s 0.027s 3.773s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 13 00 0 0 1 33 0.010s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 4 27 0.247s 0.013s 04 0 0 0 0 0s 0s 05 0 0 3 145 0.062s 0.01s 06 0 0 0 10 0.004s 0.001s 07 0 0 1 14 0.002s 0.001s 08 0 0 0 6 0.014s 0.007s 09 0 0 0 5 0.002s 0.002s 10 0 0 0 4 0.002s 0.004s 11 0 0 0 5 0.002s 0.002s 12 0 0 0 9 0.005s 0.004s 13 0 0 0 7 0.036s 0.012s 14 0 0 1 142 0.002s 0.004s 15 0 0 0 5 0.002s 0.002s 16 0 0 0 5 0.002s 0.002s 17 0 0 0 5 0.019s 0.017s 18 0 0 0 78 0.032s 0.014s 19 0 0 0 5 0.039s 0.04s 20 0 0 0 17 0.010s 0.009s 21 0 0 0 20 0.065s 0.011s 22 0 0 0 5 0.034s 0.024s 23 0 0 0 5 0.023s 0.024s Day Hour Count Avg time (sec) Sep 13 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 13 00 31,648.00 kB 31,648.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 28,082.50 kB 28,082.50 kB 04 0.00 kB 0.00 kB 05 7,108.43 kB 10,827.43 kB 06 3,604.00 kB 11,066.00 kB 07 6,800.00 kB 10,640.00 kB 08 135.50 kB 9,115.00 kB 09 93.50 kB 7,402.00 kB 10 94.00 kB 6,012.00 kB 11 94.50 kB 4,889.00 kB 12 6,597.50 kB 8,662.50 kB 13 101.50 kB 11,253.00 kB 14 684.25 kB 8,374.75 kB 15 94.50 kB 6,209.50 kB 16 94.00 kB 5,050.00 kB 17 94.00 kB 4,105.00 kB 18 1,070.00 kB 3,362.50 kB 19 94.00 kB 2,475.00 kB 20 178.50 kB 1,854.50 kB 21 116.67 kB 1,330.00 kB 22 94.50 kB 1,041.00 kB 23 57.00 kB 852.00 kB -
Temporary Files
Size of temporary files
Key values
- 491.11 MiB Temp Files size Peak
- 2026-09-13 05:31:56 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-13 05:32:03 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 13 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.31 GiB 66.84 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.01 GiB 36.62 MiB 245.55 MiB 64.46 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-13 05:32:04 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-13 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 305.55 MiB 56.79 MiB 93.45 MiB 76.39 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-13 05:30:42 Duration: 39s487ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-13 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 245.55 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-13 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 245.55 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-13 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 93.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-13 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 93.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-13 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 61.86 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-13 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 56.79 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-13 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 40.60 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-13 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 40.54 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-13 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 40.53 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-13 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.53 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-13 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.52 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-13 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.52 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-13 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.52 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-13 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 36.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-13 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 36.64 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-13 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 36.63 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-13 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 36.63 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-13 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 36.62 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-13 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 36.62 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-13 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 36.62 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-13 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 3.99 sec Highest CPU-cost vacuum
Table public.logs
Database rio - 2026-09-13 12:11:12 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 3.99 sec Highest CPU-cost vacuum
Table public.logs
Database rio - 2026-09-13 12:11:12 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (1) Main table analyzed (database rio)
- 2 analyzes Total
Vacuums per table
Key values
- pg_catalog.pg_statistic (1) Main table vacuumed on database contagem
- 8 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,126 3 149,937 0 0 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 164 46 137,496 8 21 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,303 1,016 3,701,985 970 5,866 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,740 781 2,909,650 724 4,987 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 842 224 1,131,554 128 453 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 129 4 10,493 0 0 rio.pg_catalog.pg_constraint 1 1 0 0 0 0 0 20 10 18,121 1 1 rio.public.logs 1 0 0 0 0 0 0 11,191 10,951 13,240,141 113 2,818 Total 8 7 0 0 0 0 0 20,515 13,035 21,299,377 1,944 14,146 Vacuum throughput per table
Key values
- public.logs (3.99) 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 contagem.pg_catalog.pg_statistic 0 0 0.03 brasilia.pg_toast.pg_toast_2619 0 0 0.03 rio.pg_catalog.pg_statistic 0 0 0.23 brasilia.pg_catalog.pg_statistic 0 0 0.23 rio.pg_toast.pg_toast_2619 0 0 0.05 contagem.pg_toast.pg_toast_2619 0 0 0 rio.pg_catalog.pg_constraint 0 0 0.04 rio.public.logs 0 0 3.99 Total 0 0 4.6 Tuples removed per table
Key values
- pg_catalog.pg_statistic (4508) Main table with removed tuples on database rio
- 13511 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,508 7,464 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,339 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,826 7,360 0 0 1,072 rio.pg_toast.pg_toast_2619 1 1 616 672 0 70 202 brasilia.pg_toast.pg_toast_2619 1 1 112 137 0 29 39 contagem.pg_toast.pg_toast_2619 1 1 105 112 0 9 50 rio.pg_catalog.pg_constraint 1 1 5 1,372 0 0 37 rio.public.logs 1 0 0 16,609,283 0 0 663,674 Total 8 7 13,511 16,633,674 0 108 667,371 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (70) Main table with removed pages on database rio
- 108 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_toast.pg_toast_2619 1 1 616 70 brasilia.pg_toast.pg_toast_2619 1 1 112 29 contagem.pg_toast.pg_toast_2619 1 1 105 9 contagem.pg_catalog.pg_statistic 1 1 4339 0 rio.pg_catalog.pg_statistic 1 1 4508 0 brasilia.pg_catalog.pg_statistic 1 1 3826 0 rio.pg_catalog.pg_constraint 1 1 5 0 rio.public.logs 1 0 0 0 Total 8 7 13,511 108 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 13 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 0 0 11 0 0 12 1 0 13 0 0 14 1 1 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 1 22 0 0 23 0 0 - 3.99 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
- 179 Total read queries
- 407 Total write queries
Queries by database
Key values
- rio Main database
- 416 Requests
- 2h32m35s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 899 Requests
User Request type Count Duration etiquetas Total 21 13s921ms select 21 13s921ms intelifix Total 899 3h57m38s copy to 404 41m39s ddl 3 49s667ms others 343 29m57s select 149 2h45m11s lenon Total 9 27s503ms select 9 27s503ms Duration by user
Key values
- 3h57m38s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 21 13s921ms select 21 13s921ms intelifix Total 899 3h57m38s copy to 404 41m39s ddl 3 49s667ms others 343 29m57s select 149 2h45m11s lenon Total 9 27s503ms select 9 27s503ms Queries by host
Key values
- [local] Main host
- 929 Requests
- 3h58m19s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 449 Requests
- 3h14m58s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-13 02:35:03 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 347 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 10m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-13 20:15:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 10m29s analyze verbose;[ Date: 2026-09-13 05:10:31 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 9m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-13 07:14:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-13 21:11:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 5m54s analyze verbose;[ Date: 2026-09-13 05:16:26 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
6 5m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-13 10:10:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-13 17:10:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-13 11:10:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-13 15:10:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-13 12:10:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-13 08:10:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-13 14:10:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-13 09:10:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-13 19:10:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 4m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-13 13:10:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 4m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-13 22:10:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 4m57s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-13 18:09:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-13 16:09:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 3m59s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-09-13 07:20:17 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m56s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-09-13 20:21:53 - 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 1h36m3s 48 1s322ms 10m30s 2m select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 13 07 3 9m39s 3m13s 08 3 5m19s 1m46s 09 3 5m16s 1m45s 10 3 5m26s 1m48s 11 3 5m21s 1m47s 12 3 5m19s 1m46s 13 3 5m15s 1m45s 14 3 5m19s 1m46s 15 3 5m20s 1m46s 16 3 5m13s 1m44s 17 3 5m25s 1m48s 18 3 5m13s 1m44s 19 3 5m16s 1m45s 20 3 11m2s 3m40s 21 3 6m19s 2m6s 22 3 5m14s 1m44s [ User: intelifix - Total duration: 1h36m3s - Times executed: 48 ]
[ Application: psql - Total duration: 1h36m3s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-13 20:15:32 Duration: 10m30s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-13 07:14:01 Duration: 9m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-13 21:11:05 Duration: 6m4s Database: rio User: intelifix Remote: [local] Application: psql
2 1h8m26s 48 210ms 3m59s 1m25s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 13 07 3 5m44s 1m54s 08 3 4m2s 1m20s 09 3 4m2s 1m20s 10 3 4m6s 1m22s 11 3 4m6s 1m22s 12 3 4m2s 1m20s 13 3 4m5s 1m21s 14 3 4m4s 1m21s 15 3 3m58s 1m19s 16 3 4m6s 1m22s 17 3 4m8s 1m22s 18 3 3m59s 1m19s 19 3 4m 1m20s 20 3 5m59s 1m59s 21 3 3m52s 1m17s 22 3 4m7s 1m22s [ User: intelifix - Total duration: 1h8m26s - Times executed: 48 ]
[ Application: psql - Total duration: 1h8m26s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-13 07:20:17 Duration: 3m59s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-13 20:21:53 Duration: 3m56s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-13 17:14:33 Duration: 3m38s Database: brasilia User: intelifix Remote: [local] Application: psql
3 19m14s 3 2m49s 10m29s 6m24s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 13 05 3 19m14s 6m24s [ User: intelifix - Total duration: 19m14s - Times executed: 3 ]
[ Application: psql - Total duration: 19m14s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-13 05:10:31 Duration: 10m29s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-13 05:16:26 Duration: 5m54s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-13 05:19:16 Duration: 2m49s Database: contagem User: intelifix Remote: [local] Application: psql
4 6m12s 231 150ms 16s333ms 1s613ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 13 00 11 30s577ms 2s779ms 01 10 13s266ms 1s326ms 02 9 13s512ms 1s501ms 03 9 12s165ms 1s351ms 04 10 14s430ms 1s443ms 05 11 15s257ms 1s387ms 06 12 15s438ms 1s286ms 07 9 14s860ms 1s651ms 08 8 14s709ms 1s838ms 09 9 15s47ms 1s671ms 10 10 15s258ms 1s525ms 11 11 15s511ms 1s410ms 12 10 14s718ms 1s471ms 13 10 14s220ms 1s422ms 14 11 14s676ms 1s334ms 15 9 14s104ms 1s567ms 16 11 14s519ms 1s319ms 17 10 15s18ms 1s501ms 18 11 14s407ms 1s309ms 19 9 14s79ms 1s564ms 20 13 36s514ms 2s808ms 21 9 15s989ms 1s776ms 22 9 14s414ms 1s601ms [ User: intelifix - Total duration: 6m12s - Times executed: 231 ]
[ Application: psql - Total duration: 6m12s - Times executed: 231 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-13 00:05:18 Duration: 16s333ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-13 20:05:13 Duration: 11s156ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-13 20:15:11 Duration: 10s259ms Database: rio User: intelifix Remote: [local] Application: psql
5 2m17s 4 4s372ms 1m5s 34s379ms 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 13 20 2 1m10s 35s137ms 23 2 1m7s 33s620ms [ User: intelifix - Total duration: 2m17s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m17s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-13 20:08:46 Duration: 1m5s 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-13 23:16:39 Duration: 1m2s 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-13 20:10:48 Duration: 4s421ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 1m46s 6 3s133ms 39s894ms 17s717ms 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 13 20 3 53s430ms 17s810ms 23 3 52s871ms 17s623ms [ User: intelifix - Total duration: 1m46s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m46s - 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-13 20:06:28 Duration: 39s894ms 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-13 23:14:24 Duration: 39s209ms 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-13 23:33:27 Duration: 10s410ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 1m46s 4 328ms 53s841ms 26s551ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 13 20 2 54s181ms 27s90ms 23 2 52s24ms 26s12ms [ 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-13 20:05:45 Duration: 53s841ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-13 23:13:41 Duration: 51s696ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-13 20:10:14 Duration: 340ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 1m22s 6 2s138ms 32s9ms 13s829ms 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 13 20 3 42s77ms 14s25ms 23 3 40s901ms 13s633ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-13 20:07:03 Duration: 32s9ms 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-13 23:14:59 Duration: 31s176ms 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-13 20:10:32 Duration: 7s759ms 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 13 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-13 05:32:04 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-13 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
10 1m21s 6 2s969ms 32s344ms 13s653ms 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 13 20 3 42s35ms 14s11ms 23 3 39s883ms 13s294ms [ User: intelifix - Total duration: 1m21s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m21s - 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-13 20:09:19 Duration: 32s344ms 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-13 23:17:09 Duration: 30s638ms 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-13 20:10:55 Duration: 6s520ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 1m10s 6 2s418ms 23s225ms 11s762ms 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 13 20 3 35s528ms 11s842ms 23 3 35s48ms 11s682ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-13 20:02:49 Duration: 23s225ms 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-13 23:10:48 Duration: 23s96ms 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-13 20:09:41 Duration: 9s883ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 1m10s 6 2s190ms 23s865ms 11s683ms 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 13 20 3 35s261ms 11s753ms 23 3 34s836ms 11s612ms [ 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-13 20:03:30 Duration: 23s865ms 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-13 23:11:28 Duration: 23s655ms 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-13 20:09:53 Duration: 9s205ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1m3s 6 1s683ms 24s772ms 10s605ms 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 13 20 3 31s878ms 10s626ms 23 3 31s754ms 10s584ms [ User: intelifix - Total duration: 1m3s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m3s - 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-13 23:12:26 Duration: 24s772ms 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-13 20:04:27 Duration: 24s492ms 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-13 20:10:09 Duration: 5s597ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 59s666ms 6 7s138ms 13s725ms 9s944ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 13 00 3 35s103ms 11s701ms 06 3 24s562ms 8s187ms [ User: intelifix - Total duration: 59s666ms - Times executed: 6 ]
[ Application: psql - Total duration: 59s666ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-13 00:05:15 Duration: 13s725ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-13 00:05:37 Duration: 10s885ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-13 00:05:26 Duration: 10s492ms Database: brasilia User: intelifix Remote: [local] Application: psql
15 54s664ms 4 4s62ms 23s293ms 13s666ms 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 13 20 2 27s615ms 13s807ms 23 2 27s49ms 13s524ms [ User: intelifix - Total duration: 54s664ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 54s664ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-13 20:04:51 Duration: 23s293ms 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-13 23:12:49 Duration: 22s987ms 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-13 20:10:13 Duration: 4s321ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 51s155ms 6 1s782ms 16s659ms 8s525ms 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 13 20 3 25s770ms 8s590ms 23 3 25s384ms 8s461ms [ User: intelifix - Total duration: 51s155ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s155ms - 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-13 20:03:47 Duration: 16s659ms 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-13 23:11:45 Duration: 16s413ms 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-13 20:10:00 Duration: 7s327ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 48s645ms 1 48s645ms 48s645ms 48s645ms create table temp0000290893 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 13 14 1 48s645ms 48s645ms [ User: intelifix - Total duration: 48s645ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 48s645ms - Times executed: 1 ]
-
CREATE TABLE temp0000290893 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"08-09-2026", "ate" :"13-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-13 14:17:09 Duration: 48s645ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 46s899ms 52 559ms 3s799ms 901ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 13 08 3 2s377ms 792ms 09 4 2s984ms 746ms 10 4 2s982ms 745ms 11 3 2s208ms 736ms 12 3 1s945ms 648ms 13 3 2s313ms 771ms 14 3 3s322ms 1s107ms 15 4 4s185ms 1s46ms 16 4 5s345ms 1s336ms 17 3 2s241ms 747ms 18 3 2s406ms 802ms 19 4 2s934ms 733ms 20 3 2s542ms 847ms 21 4 3s141ms 785ms 22 4 5s965ms 1s491ms [ User: intelifix - Total duration: 46s899ms - Times executed: 52 ]
[ Application: psql - Total duration: 46s899ms - Times executed: 52 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-13 22:20:05 Duration: 3s799ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-13 16:20:04 Duration: 2s854ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-13 14:20:04 Duration: 1s892ms Database: brasilia User: intelifix Remote: [local] Application: psql
19 40s596ms 6 1s56ms 16s904ms 6s766ms 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 13 20 3 20s691ms 6s897ms 23 3 19s904ms 6s634ms [ User: intelifix - Total duration: 40s596ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 40s596ms - 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-13 20:03:06 Duration: 16s904ms 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-13 23:11:04 Duration: 16s377ms 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-13 20:09:44 Duration: 2s689ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 39s487ms 1 39s487ms 39s487ms 39s487ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 13 05 1 39s487ms 39s487ms [ User: intelifix - Total duration: 39s487ms - Times executed: 1 ]
[ Application: psql - Total duration: 39s487ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-13 05:30:42 Duration: 39s487ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-13 05:30:38 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 231 6m12s 150ms 16s333ms 1s613ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 13 00 11 30s577ms 2s779ms 01 10 13s266ms 1s326ms 02 9 13s512ms 1s501ms 03 9 12s165ms 1s351ms 04 10 14s430ms 1s443ms 05 11 15s257ms 1s387ms 06 12 15s438ms 1s286ms 07 9 14s860ms 1s651ms 08 8 14s709ms 1s838ms 09 9 15s47ms 1s671ms 10 10 15s258ms 1s525ms 11 11 15s511ms 1s410ms 12 10 14s718ms 1s471ms 13 10 14s220ms 1s422ms 14 11 14s676ms 1s334ms 15 9 14s104ms 1s567ms 16 11 14s519ms 1s319ms 17 10 15s18ms 1s501ms 18 11 14s407ms 1s309ms 19 9 14s79ms 1s564ms 20 13 36s514ms 2s808ms 21 9 15s989ms 1s776ms 22 9 14s414ms 1s601ms [ User: intelifix - Total duration: 6m12s - Times executed: 231 ]
[ Application: psql - Total duration: 6m12s - Times executed: 231 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-13 00:05:18 Duration: 16s333ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-13 20:05:13 Duration: 11s156ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-13 20:15:11 Duration: 10s259ms Database: rio User: intelifix Remote: [local] Application: psql
2 52 46s899ms 559ms 3s799ms 901ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 13 08 3 2s377ms 792ms 09 4 2s984ms 746ms 10 4 2s982ms 745ms 11 3 2s208ms 736ms 12 3 1s945ms 648ms 13 3 2s313ms 771ms 14 3 3s322ms 1s107ms 15 4 4s185ms 1s46ms 16 4 5s345ms 1s336ms 17 3 2s241ms 747ms 18 3 2s406ms 802ms 19 4 2s934ms 733ms 20 3 2s542ms 847ms 21 4 3s141ms 785ms 22 4 5s965ms 1s491ms [ User: intelifix - Total duration: 46s899ms - Times executed: 52 ]
[ Application: psql - Total duration: 46s899ms - Times executed: 52 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-13 22:20:05 Duration: 3s799ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-13 16:20:04 Duration: 2s854ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-13 14:20:04 Duration: 1s892ms Database: brasilia User: intelifix Remote: [local] Application: psql
3 48 1h36m3s 1s322ms 10m30s 2m select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 13 07 3 9m39s 3m13s 08 3 5m19s 1m46s 09 3 5m16s 1m45s 10 3 5m26s 1m48s 11 3 5m21s 1m47s 12 3 5m19s 1m46s 13 3 5m15s 1m45s 14 3 5m19s 1m46s 15 3 5m20s 1m46s 16 3 5m13s 1m44s 17 3 5m25s 1m48s 18 3 5m13s 1m44s 19 3 5m16s 1m45s 20 3 11m2s 3m40s 21 3 6m19s 2m6s 22 3 5m14s 1m44s [ User: intelifix - Total duration: 1h36m3s - Times executed: 48 ]
[ Application: psql - Total duration: 1h36m3s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-13 20:15:32 Duration: 10m30s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-13 07:14:01 Duration: 9m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-13 21:11:05 Duration: 6m4s Database: rio User: intelifix Remote: [local] Application: psql
4 48 1h8m26s 210ms 3m59s 1m25s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 13 07 3 5m44s 1m54s 08 3 4m2s 1m20s 09 3 4m2s 1m20s 10 3 4m6s 1m22s 11 3 4m6s 1m22s 12 3 4m2s 1m20s 13 3 4m5s 1m21s 14 3 4m4s 1m21s 15 3 3m58s 1m19s 16 3 4m6s 1m22s 17 3 4m8s 1m22s 18 3 3m59s 1m19s 19 3 4m 1m20s 20 3 5m59s 1m59s 21 3 3m52s 1m17s 22 3 4m7s 1m22s [ User: intelifix - Total duration: 1h8m26s - Times executed: 48 ]
[ Application: psql - Total duration: 1h8m26s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-13 07:20:17 Duration: 3m59s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-13 20:21:53 Duration: 3m56s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-13 17:14:33 Duration: 3m38s Database: brasilia User: intelifix Remote: [local] Application: psql
5 38 37s18ms 698ms 4s263ms 974ms 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 13 08 3 5s854ms 1s951ms 09 2 1s746ms 873ms 10 2 1s529ms 764ms 11 3 2s358ms 786ms 12 3 2s508ms 836ms 13 3 3s416ms 1s138ms 14 3 2s365ms 788ms 15 2 1s650ms 825ms 16 2 1s415ms 707ms 17 3 2s386ms 795ms 18 3 2s431ms 810ms 19 2 1s771ms 885ms 20 3 4s412ms 1s470ms 21 2 1s575ms 787ms 22 2 1s598ms 799ms [ User: intelifix - Total duration: 37s18ms - Times executed: 38 ]
[ Application: psql - Total duration: 37s18ms - Times executed: 38 ]
-
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-13 08:00:05 Duration: 4s263ms 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-13 20:20:04 Duration: 2s893ms 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-13 13:20:03 Duration: 1s896ms Database: rio User: intelifix Remote: [local] Application: psql
6 9 7s299ms 150ms 2s509ms 811ms select * from rs_etiqueta (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 13 20 1 1s256ms 1s256ms 23 8 6s43ms 755ms [ User: etiquetas - Total duration: 7s299ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 7s299ms - Times executed: 9 ]
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-09-13 23:14:04 Duration: 2s509ms Database: brasilia User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-09-13 23:23:16 Duration: 1s951ms Database: brasilia User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-09-13 20:13:50 Duration: 1s256ms Database: brasilia User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
7 7 3s236ms 169ms 699ms 462ms 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 #7
Day Hour Count Duration Avg duration Sep 13 20 3 1s228ms 409ms 23 4 2s7ms 501ms [ User: intelifix - Total duration: 3s236ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 3s236ms - 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-13 20:02:03 Duration: 699ms 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-13 23:17:12 Duration: 571ms 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-13 23:32:26 Duration: 519ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 7 3s6ms 166ms 1s55ms 429ms call rs_giga_tecnicos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 13 00 3 1s679ms 559ms 20 4 1s327ms 331ms [ User: intelifix - Total duration: 3s6ms - Times executed: 7 ]
[ Application: psql - Total duration: 3s6ms - Times executed: 7 ]
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-09-13 00:05:02 Duration: 1s55ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-09-13 00:05:03 Duration: 427ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-09-13 20:35:02 Duration: 412ms Database: rio User: intelifix Remote: [local] Application: psql
9 7 2s563ms 312ms 441ms 366ms 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 #9
Day Hour Count Duration Avg duration Sep 13 20 3 1s118ms 372ms 23 4 1s444ms 361ms [ User: intelifix - Total duration: 2s563ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 2s563ms - 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-13 20:02:02 Duration: 441ms 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-13 23:10:02 Duration: 405ms 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-13 23:17:11 Duration: 377ms Database: rio User: intelifix Remote: [local] Application: pg_dump
10 6 1m46s 3s133ms 39s894ms 17s717ms 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 #10
Day Hour Count Duration Avg duration Sep 13 20 3 53s430ms 17s810ms 23 3 52s871ms 17s623ms [ User: intelifix - Total duration: 1m46s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m46s - 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-13 20:06:28 Duration: 39s894ms 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-13 23:14:24 Duration: 39s209ms 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-13 23:33:27 Duration: 10s410ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 6 1m22s 2s138ms 32s9ms 13s829ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 13 20 3 42s77ms 14s25ms 23 3 40s901ms 13s633ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-13 20:07:03 Duration: 32s9ms 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-13 23:14:59 Duration: 31s176ms 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-13 20:10:32 Duration: 7s759ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 6 1m21s 2s969ms 32s344ms 13s653ms 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 #12
Day Hour Count Duration Avg duration Sep 13 20 3 42s35ms 14s11ms 23 3 39s883ms 13s294ms [ User: intelifix - Total duration: 1m21s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m21s - 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-13 20:09:19 Duration: 32s344ms 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-13 23:17:09 Duration: 30s638ms 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-13 20:10:55 Duration: 6s520ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 6 1m10s 2s418ms 23s225ms 11s762ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 13 20 3 35s528ms 11s842ms 23 3 35s48ms 11s682ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-13 20:02:49 Duration: 23s225ms 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-13 23:10:48 Duration: 23s96ms 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-13 20:09:41 Duration: 9s883ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 6 1m10s 2s190ms 23s865ms 11s683ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 13 20 3 35s261ms 11s753ms 23 3 34s836ms 11s612ms [ 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-13 20:03:30 Duration: 23s865ms 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-13 23:11:28 Duration: 23s655ms 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-13 20:09:53 Duration: 9s205ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 6 1m3s 1s683ms 24s772ms 10s605ms 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 #15
Day Hour Count Duration Avg duration Sep 13 20 3 31s878ms 10s626ms 23 3 31s754ms 10s584ms [ User: intelifix - Total duration: 1m3s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m3s - 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-13 23:12:26 Duration: 24s772ms 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-13 20:04:27 Duration: 24s492ms 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-13 20:10:09 Duration: 5s597ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 6 59s666ms 7s138ms 13s725ms 9s944ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 13 00 3 35s103ms 11s701ms 06 3 24s562ms 8s187ms [ User: intelifix - Total duration: 59s666ms - Times executed: 6 ]
[ Application: psql - Total duration: 59s666ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-13 00:05:15 Duration: 13s725ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-13 00:05:37 Duration: 10s885ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-13 00:05:26 Duration: 10s492ms Database: brasilia User: intelifix Remote: [local] Application: psql
17 6 51s155ms 1s782ms 16s659ms 8s525ms 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 #17
Day Hour Count Duration Avg duration Sep 13 20 3 25s770ms 8s590ms 23 3 25s384ms 8s461ms [ User: intelifix - Total duration: 51s155ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s155ms - 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-13 20:03:47 Duration: 16s659ms 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-13 23:11:45 Duration: 16s413ms 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-13 20:10:00 Duration: 7s327ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 6 40s596ms 1s56ms 16s904ms 6s766ms 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 13 20 3 20s691ms 6s897ms 23 3 19s904ms 6s634ms [ User: intelifix - Total duration: 40s596ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 40s596ms - 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-13 20:03:06 Duration: 16s904ms 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-13 23:11:04 Duration: 16s377ms 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-13 20:09:44 Duration: 2s689ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 6 28s379ms 851ms 12s475ms 4s729ms 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 13 20 3 14s102ms 4s700ms 23 3 14s276ms 4s758ms [ User: intelifix - Total duration: 28s379ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 28s379ms - 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-13 23:12:01 Duration: 12s475ms 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-13 20:04:03 Duration: 12s227ms 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-13 20:10:03 Duration: 970ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 6 27s448ms 2s777ms 5s975ms 4s574ms 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 13 20 3 14s127ms 4s709ms 23 3 13s320ms 4s440ms [ User: intelifix - Total duration: 27s448ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s448ms - 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-13 20:07:28 Duration: 5s975ms 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-13 23:15:23 Duration: 5s519ms 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-13 20:10:42 Duration: 5s324ms 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 2m49s 10m29s 6m24s 3 19m14s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 13 05 3 19m14s 6m24s [ User: intelifix - Total duration: 19m14s - Times executed: 3 ]
[ Application: psql - Total duration: 19m14s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-13 05:10:31 Duration: 10m29s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-13 05:16:26 Duration: 5m54s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-13 05:19:16 Duration: 2m49s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s322ms 10m30s 2m 48 1h36m3s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 13 07 3 9m39s 3m13s 08 3 5m19s 1m46s 09 3 5m16s 1m45s 10 3 5m26s 1m48s 11 3 5m21s 1m47s 12 3 5m19s 1m46s 13 3 5m15s 1m45s 14 3 5m19s 1m46s 15 3 5m20s 1m46s 16 3 5m13s 1m44s 17 3 5m25s 1m48s 18 3 5m13s 1m44s 19 3 5m16s 1m45s 20 3 11m2s 3m40s 21 3 6m19s 2m6s 22 3 5m14s 1m44s [ User: intelifix - Total duration: 1h36m3s - Times executed: 48 ]
[ Application: psql - Total duration: 1h36m3s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-13 20:15:32 Duration: 10m30s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-13 07:14:01 Duration: 9m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-13 21:11:05 Duration: 6m4s Database: rio User: intelifix Remote: [local] Application: psql
3 210ms 3m59s 1m25s 48 1h8m26s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 13 07 3 5m44s 1m54s 08 3 4m2s 1m20s 09 3 4m2s 1m20s 10 3 4m6s 1m22s 11 3 4m6s 1m22s 12 3 4m2s 1m20s 13 3 4m5s 1m21s 14 3 4m4s 1m21s 15 3 3m58s 1m19s 16 3 4m6s 1m22s 17 3 4m8s 1m22s 18 3 3m59s 1m19s 19 3 4m 1m20s 20 3 5m59s 1m59s 21 3 3m52s 1m17s 22 3 4m7s 1m22s [ User: intelifix - Total duration: 1h8m26s - Times executed: 48 ]
[ Application: psql - Total duration: 1h8m26s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-13 07:20:17 Duration: 3m59s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-13 20:21:53 Duration: 3m56s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-13 17:14:33 Duration: 3m38s Database: brasilia User: intelifix Remote: [local] Application: psql
4 1m22s 1m22s 1m22s 1 1m22s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 13 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-13 05:32:04 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-13 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
5 48s645ms 48s645ms 48s645ms 1 48s645ms create table temp0000290893 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 13 14 1 48s645ms 48s645ms [ User: intelifix - Total duration: 48s645ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 48s645ms - Times executed: 1 ]
-
CREATE TABLE temp0000290893 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"08-09-2026", "ate" :"13-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-13 14:17:09 Duration: 48s645ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 39s487ms 39s487ms 39s487ms 1 39s487ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 13 05 1 39s487ms 39s487ms [ User: intelifix - Total duration: 39s487ms - Times executed: 1 ]
[ Application: psql - Total duration: 39s487ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-13 05:30:42 Duration: 39s487ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-13 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
7 4s372ms 1m5s 34s379ms 4 2m17s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 13 20 2 1m10s 35s137ms 23 2 1m7s 33s620ms [ User: intelifix - Total duration: 2m17s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m17s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-13 20:08:46 Duration: 1m5s 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-13 23:16:39 Duration: 1m2s 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-13 20:10:48 Duration: 4s421ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 328ms 53s841ms 26s551ms 4 1m46s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 13 20 2 54s181ms 27s90ms 23 2 52s24ms 26s12ms [ 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-13 20:05:45 Duration: 53s841ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-13 23:13:41 Duration: 51s696ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-13 20:10:14 Duration: 340ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 3s133ms 39s894ms 17s717ms 6 1m46s 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 #9
Day Hour Count Duration Avg duration Sep 13 20 3 53s430ms 17s810ms 23 3 52s871ms 17s623ms [ User: intelifix - Total duration: 1m46s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m46s - 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-13 20:06:28 Duration: 39s894ms 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-13 23:14:24 Duration: 39s209ms 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-13 23:33:27 Duration: 10s410ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 2s138ms 32s9ms 13s829ms 6 1m22s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 13 20 3 42s77ms 14s25ms 23 3 40s901ms 13s633ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-13 20:07:03 Duration: 32s9ms 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-13 23:14:59 Duration: 31s176ms 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-13 20:10:32 Duration: 7s759ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 4s62ms 23s293ms 13s666ms 4 54s664ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 13 20 2 27s615ms 13s807ms 23 2 27s49ms 13s524ms [ User: intelifix - Total duration: 54s664ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 54s664ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-13 20:04:51 Duration: 23s293ms 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-13 23:12:49 Duration: 22s987ms 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-13 20:10:13 Duration: 4s321ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 2s969ms 32s344ms 13s653ms 6 1m21s 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 #12
Day Hour Count Duration Avg duration Sep 13 20 3 42s35ms 14s11ms 23 3 39s883ms 13s294ms [ User: intelifix - Total duration: 1m21s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m21s - 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-13 20:09:19 Duration: 32s344ms 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-13 23:17:09 Duration: 30s638ms 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-13 20:10:55 Duration: 6s520ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 2s418ms 23s225ms 11s762ms 6 1m10s copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 13 20 3 35s528ms 11s842ms 23 3 35s48ms 11s682ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-13 20:02:49 Duration: 23s225ms 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-13 23:10:48 Duration: 23s96ms 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-13 20:09:41 Duration: 9s883ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 2s190ms 23s865ms 11s683ms 6 1m10s copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 13 20 3 35s261ms 11s753ms 23 3 34s836ms 11s612ms [ 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-13 20:03:30 Duration: 23s865ms 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-13 23:11:28 Duration: 23s655ms 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-13 20:09:53 Duration: 9s205ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 1s683ms 24s772ms 10s605ms 6 1m3s 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 #15
Day Hour Count Duration Avg duration Sep 13 20 3 31s878ms 10s626ms 23 3 31s754ms 10s584ms [ User: intelifix - Total duration: 1m3s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m3s - 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-13 23:12:26 Duration: 24s772ms 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-13 20:04:27 Duration: 24s492ms 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-13 20:10:09 Duration: 5s597ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 7s138ms 13s725ms 9s944ms 6 59s666ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 13 00 3 35s103ms 11s701ms 06 3 24s562ms 8s187ms [ User: intelifix - Total duration: 59s666ms - Times executed: 6 ]
[ Application: psql - Total duration: 59s666ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-13 00:05:15 Duration: 13s725ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-13 00:05:37 Duration: 10s885ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-13 00:05:26 Duration: 10s492ms Database: brasilia User: intelifix Remote: [local] Application: psql
17 1s782ms 16s659ms 8s525ms 6 51s155ms 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 #17
Day Hour Count Duration Avg duration Sep 13 20 3 25s770ms 8s590ms 23 3 25s384ms 8s461ms [ User: intelifix - Total duration: 51s155ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s155ms - 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-13 20:03:47 Duration: 16s659ms 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-13 23:11:45 Duration: 16s413ms 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-13 20:10:00 Duration: 7s327ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 1s56ms 16s904ms 6s766ms 6 40s596ms 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 13 20 3 20s691ms 6s897ms 23 3 19s904ms 6s634ms [ User: intelifix - Total duration: 40s596ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 40s596ms - 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-13 20:03:06 Duration: 16s904ms 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-13 23:11:04 Duration: 16s377ms 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-13 20:09:44 Duration: 2s689ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 851ms 12s475ms 4s729ms 6 28s379ms 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 13 20 3 14s102ms 4s700ms 23 3 14s276ms 4s758ms [ User: intelifix - Total duration: 28s379ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 28s379ms - 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-13 23:12:01 Duration: 12s475ms 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-13 20:04:03 Duration: 12s227ms 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-13 20:10:03 Duration: 970ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 2s777ms 5s975ms 4s574ms 6 27s448ms 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 13 20 3 14s127ms 4s709ms 23 3 13s320ms 4s440ms [ User: intelifix - Total duration: 27s448ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s448ms - 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-13 20:07:28 Duration: 5s975ms 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-13 23:15:23 Duration: 5s519ms 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-13 20:10:42 Duration: 5s324ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 310ms 1 310ms 310ms 310ms select * from rs_caixa_qr ();Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Sep 13 23 1 310ms 310ms [ User: etiquetas - Total duration: 387ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 387ms - Times executed: 1 ]
-
select * from rs_caixa_qr ();
Date: 2026-09-13 23:20:17 Duration: 310ms Database: postgres User: rio Remote: etiquetas Application: [local] Queryid: [unknown]
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 7 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 13 16 1 0ms 0ms 17 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 2 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 7m20s - Times executed: 7 ]
[ Application: psql - Total duration: 7m20s - Times executed: 7 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 10,892 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 19 FATAL entries
- 3982 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,978 Max number of times the same event was reported
- 4,002 Total events found
Rank Times reported Error 1 3,978 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 13 00 164 01 171 02 168 03 160 04 167 05 169 06 169 07 162 08 169 09 168 10 169 11 167 12 167 13 166 14 171 15 168 16 165 17 172 18 165 19 164 20 164 21 169 22 167 23 137 - ERROR: prepared statement "_PLAN00000000569C9DE0" does not exist
- ERROR: prepared statement "_PLAN0000000029D8A2F0" does not exist
- ERROR: prepared statement "_PLAN0000000029DEBFC0" does not exist
Statement: DEALLOCATE "_PLAN00000000569C9DE0"
Date: 2026-09-13 00:00:29 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029D8A2F0"
Date: 2026-09-13 00:00:45 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029DEBFC0"
Date: 2026-09-13 00:00:45 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 10 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 13 03 10 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-13 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-13 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-13 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
3 6 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 13 00 2 06 1 08 1 13 1 21 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-09-13 00:02:15 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-13 00:14:53 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-13 06:02:15 Database: testes Application: [unknown] User: lenon Remote: [local]
4 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 13 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-13 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-13 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-13 05:32:05 Database: contagem Application: psql User: intelifix Remote: [local]
5 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 13 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-09-13 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-13 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-13 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
6 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 13 03 1 - LOG: database system was shut down at 2026-09-13 03:05:01 -03
Date: 2026-09-13 03:05:02