pgBadger-
Global information
- Generated on Mon Jul 13 23:00:08 2026
- Log file: /var/log/postgresql/postgresql-14-main.log
- Parsed 93,116 log entries in 7s
- Log start from 2026-07-13 07:00:01 to 2026-07-13 22:00:00
-
Overview
Global Stats
- 3 Number of unique normalized queries
- 13 Number of queries
- 14s989ms Total query duration
- 2026-07-13 07:00:02 First query
- 2026-07-13 21:00:02 Last query
- 1 queries/s at 2026-07-13 08:00:02 Query peak
- 14s989ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 14s989ms Execute total duration
- 340 Number of events
- 8 Number of unique normalized events
- 325 Max number of times the same event was reported
- 0 Number of cancellation
- 75 Total number of automatic vacuums
- 103 Total number of automatic analyzes
- 1,080 Number temporary file
- 2.12 MiB Max size of temporary file
- 1.13 MiB Average size of temporary file
- 10,703 Total number of sessions
- 26 sessions at 2026-07-13 22:00:00 Session peak
- 2d22h32m43s Total duration of sessions
- 23s728ms Average duration of sessions
- 0 Average queries per session
- 1ms Average queries duration per session
- 23s726ms Average idle time per session
- 10,703 Total number of connections
- 9 connections/s at 2026-07-13 16:15:07 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-13 08:00:02 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-13 08:00:02 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 0 queries/s Query Peak
- Date
Queries duration
Key values
- 14s989ms 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) Jul 13 07 2 0ms 1s837ms 1s445ms 0ms 0ms 1s837ms 08 1 0ms 1s113ms 1s113ms 0ms 0ms 1s113ms 09 1 0ms 1s64ms 1s64ms 0ms 0ms 1s64ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 1 0ms 1s90ms 1s90ms 0ms 0ms 1s90ms 12 1 0ms 1s64ms 1s64ms 0ms 0ms 1s64ms 13 1 0ms 1s86ms 1s86ms 0ms 0ms 1s86ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 1 0ms 1s47ms 1s47ms 0ms 0ms 1s47ms 16 1 0ms 1s110ms 1s110ms 0ms 0ms 1s110ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 1 0ms 1s28ms 1s28ms 0ms 0ms 1s28ms 19 1 0ms 1s109ms 1s109ms 0ms 0ms 1s109ms 20 1 0ms 1s196ms 1s196ms 0ms 0ms 1s196ms 21 1 0ms 1s186ms 1s186ms 0ms 0ms 1s186ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 13 07 2 0 1s445ms 0ms 0ms 1s53ms 08 1 0 1s113ms 0ms 0ms 0ms 09 1 0 1s64ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 1 0 1s90ms 0ms 0ms 0ms 12 1 0 1s64ms 0ms 0ms 0ms 13 1 0 1s86ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 1 0 1s47ms 0ms 0ms 0ms 16 1 0 1s110ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 1 0 1s28ms 0ms 0ms 0ms 19 1 0 1s109ms 0ms 0ms 0ms 20 1 0 1s196ms 0ms 0ms 0ms 21 1 0 1s186ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 13 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 Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 13 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 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% Day Hour Count Average / Second Jul 13 07 710 0.20/s 08 718 0.20/s 09 713 0.20/s 10 712 0.20/s 11 714 0.20/s 12 713 0.20/s 13 712 0.20/s 14 714 0.20/s 15 713 0.20/s 16 713 0.20/s 17 713 0.20/s 18 712 0.20/s 19 714 0.20/s 20 713 0.20/s 21 713 0.20/s 22 6 0.00/s Day Hour Count Average Duration Average idle time Jul 13 07 716 23s9ms 23s5ms 08 718 23s400ms 23s399ms 09 713 25s166ms 25s165ms 10 712 25s202ms 25s202ms 11 714 22s611ms 22s609ms 12 713 21s380ms 21s379ms 13 712 22s675ms 22s673ms 14 714 27s653ms 27s653ms 15 713 18s856ms 18s855ms 16 713 28s955ms 28s954ms 17 713 20s119ms 20s119ms 18 712 22s676ms 22s674ms 19 714 21s353ms 21s351ms 20 713 31s481ms 31s479ms 21 713 21s383ms 21s381ms 22 0 0ms 0ms -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2026-07-13 16:15:07 Date
Connections per database
Key values
- etendo Main Database
- 10,703 connections Total
Connections per user
Key values
- postgres Main User
- 10,703 connections Total
-
Sessions
Simultaneous sessions
Key values
- 26 sessions Session Peak
- 2026-07-13 22:00:00 Date
Histogram of session times
Key values
- 10,426 0-500ms duration
Sessions per database
Key values
- etendo Main Database
- 10,703 sessions Total
Sessions per user
Key values
- postgres Main User
- 10,703 sessions Total
Sessions per host
Key values
- [local] Main Host
- 10,703 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 1,364 buffers Checkpoint Peak
- 2026-07-13 14:06:38 Date
- 136.197 seconds Highest write time
- 0.003 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-07-13 16:39:25 Date
Checkpoints distance
Key values
- 22.79 Mo Distance Peak
- 2026-07-13 07:06:19 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 13 07 1,609 159.304s 0.016s 159.358s 08 1,611 159.61s 0.016s 159.664s 09 1,490 147.362s 0.016s 147.416s 10 1,520 150.276s 0.016s 150.33s 11 1,552 153.363s 0.017s 153.413s 12 1,599 158.3s 0.019s 158.354s 13 1,581 156.49s 0.018s 156.547s 14 1,672 165.423s 0.016s 165.475s 15 1,552 153.894s 0.016s 153.946s 16 1,614 159.639s 0.015s 159.696s 17 1,618 160.506s 0.015s 160.561s 18 1,619 160.212s 0.015s 160.262s 19 1,595 157.787s 0.02s 157.841s 20 1,634 161.82s 0.014s 161.872s 21 1,624 160.692s 0.016s 160.752s 22 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 13 07 0 0 0 280 0.001s 0.012s 08 0 1 0 269 0.002s 0.012s 09 0 1 0 268 0.001s 0.012s 10 0 1 0 263 0.001s 0.012s 11 0 1 0 260 0.001s 0.012s 12 0 0 0 272 0.002s 0.012s 13 0 1 0 266 0.002s 0.012s 14 0 1 0 265 0.002s 0.012s 15 0 1 0 259 0.001s 0.012s 16 0 1 0 264 0.001s 0.012s 17 0 0 0 264 0.001s 0.012s 18 0 1 0 273 0.002s 0.012s 19 0 1 0 270 0.002s 0.012s 20 0 1 0 263 0.001s 0.012s 21 0 1 0 269 0.001s 0.012s 22 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jul 13 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 Day Hour Mean distance Mean estimate Jul 13 07 1,144.75 kB 35,777.58 kB 08 1,084.75 kB 10,878.67 kB 09 1,078.00 kB 6,631.50 kB 10 1,032.92 kB 6,555.08 kB 11 1,068.00 kB 6,701.08 kB 12 1,086.33 kB 6,704.00 kB 13 1,077.50 kB 6,585.42 kB 14 1,128.92 kB 7,004.08 kB 15 1,063.00 kB 6,731.33 kB 16 1,102.42 kB 6,801.67 kB 17 1,093.83 kB 6,690.83 kB 18 1,088.50 kB 6,707.83 kB 19 1,071.50 kB 6,763.50 kB 20 1,093.33 kB 6,864.08 kB 21 1,089.92 kB 6,728.58 kB 22 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 6.75 MiB Temp Files size Peak
- 2026-07-13 14:45:00 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2026-07-13 14:45:00 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 13 07 66 74.29 MiB 1.13 MiB 08 72 81.05 MiB 1.13 MiB 09 72 81.05 MiB 1.13 MiB 10 72 81.05 MiB 1.13 MiB 11 72 81.05 MiB 1.13 MiB 12 72 81.05 MiB 1.13 MiB 13 72 81.05 MiB 1.13 MiB 14 72 81.05 MiB 1.13 MiB 15 72 81.05 MiB 1.13 MiB 16 72 81.05 MiB 1.13 MiB 17 72 81.05 MiB 1.13 MiB 18 72 81.05 MiB 1.13 MiB 19 72 81.05 MiB 1.13 MiB 20 72 81.05 MiB 1.13 MiB 21 72 81.05 MiB 1.13 MiB 22 6 6.75 MiB 1.13 MiB Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 1,080 1.19 GiB 130.26 KiB 2.12 MiB 1.13 MiB select ord.c_order_id from c_order ord left join c_orderline ol on ord.c_order_id = ol.c_order_id where ord.docstatus = ? and ol.qtyordered <= ol.qtydelivered and ord.issotrx = ? and ord.ad_client_id = ? and ord.c_order_id not in ( select ord.c_order_id from c_orderline ol left join c_order ord on ord.c_order_id = ol.c_order_id left join m_product mp on ol.m_product_id = mp.m_product_id where ol.qtydelivered >= ? and ol.qtyordered <> ? and ol.qtydelivered < ol.qtyordered) group by ord.c_order_id;-
SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;
Date: 2026-07-13 07:05:00 Duration: 0ms
Queries generating the largest temporary files
Rank Size Query 1 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-13 07:05:00 ]
2 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-13 07:05:00 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
3 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-13 07:05:00 ]
4 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-13 07:10:00 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
5 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-13 07:10:00 ]
6 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-13 07:10:00 ]
7 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-13 07:15:00 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
8 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-13 07:15:00 ]
9 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-13 07:15:00 ]
10 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-13 07:20:00 ]
11 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-13 07:20:00 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
12 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-13 07:20:00 ]
13 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-13 07:25:00 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
14 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-13 07:25:00 ]
15 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-13 07:25:00 ]
16 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-13 07:30:00 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
17 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-13 07:30:00 ]
18 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-13 07:30:00 ]
19 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-13 07:35:00 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
20 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-13 07:35:00 ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.07 sec Highest CPU-cost vacuum
Table profile.sample_stat_indexes
Database etendo - 2026-07-13 18:00:42 Date
- 0 sec Highest CPU-cost analyze
Table
Database etendo - Date
Average Autovacuum Duration
Key values
- 0.07 sec Highest CPU-cost vacuum
Table profile.sample_stat_indexes
Database etendo - 2026-07-13 18:00:42 Date
Analyzes per table
Key values
- profile.last_stat_statements_srv1 (15) Main table analyzed (database etendo)
- 103 analyzes Total
Table Number of analyzes etendo.profile.last_stat_statements_srv1 15 etendo.profile.last_stat_tables_srv1 15 etendo.profile.last_stat_indexes_srv1 15 etendo.profile.last_stat_user_functions_srv1 15 etendo.public.ad_process_request 12 etendo.profile.tables_list 5 etendo.profile.last_extension_versions 4 etendo.profile.last_stat_activity_count_srv1 4 etendo.profile.stmt_list 4 etendo.profile.indexes_list 3 etendo.profile.last_stat_slru 2 etendo.profile.sample_stat_tables 1 etendo.profile.sample_stat_indexes_total 1 etendo.profile.sample_stat_user_functions 1 etendo.profile.sample_stat_slru 1 etendo.profile.sample_statements 1 etendo.profile.sample_stat_tables_total 1 etendo.public.advcrm2_configapp 1 etendo.profile.sample_stat_indexes 1 etendo.profile.sample_stat_database 1 Total 103 Vacuums per table
Key values
- profile.last_stat_statements_srv1 (15) Main table vacuumed on database etendo
- 75 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples etendo.profile.last_stat_statements_srv1 15 15 4,207 0 59 0 40 2,210 69 476,929 0 0 etendo.profile.last_stat_tables_srv1 15 15 15,397 0 231 0 0 11,413 241 1,637,078 0 0 etendo.profile.last_stat_indexes_srv1 15 15 19,451 0 352 0 0 14,526 361 2,287,756 0 0 etendo.profile.last_stat_user_functions_srv1 15 15 3,262 0 34 0 0 1,510 41 320,869 0 0 etendo.profile.tables_list 3 3 499 0 10 0 0 155 6 60,414 0 0 etendo.profile.stmt_list 3 3 469 0 13 0 0 188 8 67,223 0 0 etendo.profile.last_extension_versions 2 2 133 0 10 0 0 10 4 33,450 0 0 etendo.profile.last_stat_activity_count_srv1 2 0 65 0 10 0 0 12 4 31,030 0 0 etendo.profile.indexes_list 2 2 230 0 9 0 0 36 4 35,212 0 0 etendo.profile.sample_stat_indexes 1 1 400 0 253 0 0 288 27 92,164 0 0 etendo.profile.last_stat_database_srv1 1 1 61 0 6 0 0 6 3 23,822 0 0 etendo.profile.last_stat_slru 1 1 61 0 5 0 0 5 2 16,413 0 0 Total 75 73 44,235 1,148 992 0 40 30,359 770 5,082,360 0 0 Vacuum throughput per table
Key values
- profile.last_stat_indexes_srv1 (0.3) Max CPU elapsed for vacuum on database etendo
- unknown (0 ms) Max I/O read time for vacuum on database etendo
- unknown (0 ms) Max I/O write time for vacuum on database etendo
I/O timing (ms) CPU (s) Table read write elapsed etendo.profile.last_stat_statements_srv1 0 0 0.01 etendo.profile.last_stat_tables_srv1 0 0 0.17 etendo.profile.last_stat_indexes_srv1 0 0 0.3 etendo.profile.last_stat_user_functions_srv1 0 0 0 etendo.profile.tables_list 0 0 0 etendo.profile.stmt_list 0 0 0 etendo.profile.last_extension_versions 0 0 0 etendo.profile.last_stat_activity_count_srv1 0 0 0 etendo.profile.indexes_list 0 0 0 etendo.profile.sample_stat_indexes 0 0 0.07 etendo.profile.last_stat_database_srv1 0 0 0 etendo.profile.last_stat_slru 0 0 0 Total 0 0 0.55 Tuples removed per table
Key values
- profile.last_stat_indexes_srv1 (93370) Main table with removed tuples on database etendo
- 171651 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain etendo.profile.last_stat_indexes_srv1 15 15 93,370 46,080 0 0 5,580 etendo.profile.last_stat_tables_srv1 15 15 59,698 28,575 0 190 4,240 etendo.profile.last_stat_statements_srv1 15 15 9,189 5,926 0 71 659 etendo.profile.last_stat_user_functions_srv1 15 15 7,880 7,380 0 0 495 etendo.profile.sample_stat_indexes 1 1 780 13,570 0 0 225 etendo.profile.tables_list 3 3 273 1,803 0 0 54 etendo.profile.stmt_list 3 3 187 855 0 0 78 etendo.profile.last_extension_versions 2 2 112 16 0 0 2 etendo.profile.indexes_list 2 2 58 320 0 0 10 etendo.profile.last_stat_slru 1 1 52 4 0 0 1 etendo.profile.last_stat_activity_count_srv1 2 0 48 0 0 2 0 etendo.profile.last_stat_database_srv1 1 1 4 4 0 0 1 Total 75 73 171,651 104,533 0 263 11,345 Pages removed per table
Key values
- profile.last_stat_tables_srv1 (190) Main table with removed pages on database etendo
- 263 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed etendo.profile.last_stat_tables_srv1 15 15 59698 190 etendo.profile.last_stat_statements_srv1 15 15 9189 71 etendo.profile.last_stat_activity_count_srv1 2 0 48 2 etendo.profile.last_extension_versions 2 2 112 0 etendo.profile.last_stat_indexes_srv1 15 15 93370 0 etendo.profile.tables_list 3 3 273 0 etendo.profile.stmt_list 3 3 187 0 etendo.profile.sample_stat_indexes 1 1 780 0 etendo.profile.indexes_list 2 2 58 0 etendo.profile.last_stat_database_srv1 1 1 4 0 etendo.profile.last_stat_slru 1 1 52 0 etendo.profile.last_stat_user_functions_srv1 15 15 7880 0 Total 75 73 171,651 263 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 13 07 6 7 08 5 6 09 4 7 10 4 5 11 4 6 12 8 6 13 4 7 14 4 10 15 4 6 16 5 6 17 5 8 18 7 6 19 7 6 20 4 9 21 4 8 22 0 0 - 0.07 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
- 13 Total read queries
- 0 Total write queries
Queries by database
Key values
- etendo Main database
- 13 Requests
- 14s989ms (etendo)
- Main time consuming database
Queries by user
Key values
- postgres Main user
- 13 Requests
User Request type Count Duration postgres Total 13 14s989ms select 13 14s989ms Duration by user
Key values
- 14s989ms (postgres) Main time consuming user
User Request type Count Duration postgres Total 13 14s989ms select 13 14s989ms Queries by host
Key values
- [local] Main host
- 13 Requests
- 14s989ms ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 13 Requests
- 14s989ms (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-13 21:45:19 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 13 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 1s837ms SELECT string_agg(distinct prac_checkacct_config (ca.c_acctschema_id, ca."name"), ' \n ') from c_acctschema ca where 1 = 1;[ Date: 2026-07-13 07:16:29 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
2 1s196ms SELECT profile.take_sample ();[ Date: 2026-07-13 20:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
3 1s186ms SELECT profile.take_sample ();[ Date: 2026-07-13 21:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
4 1s113ms SELECT profile.take_sample ();[ Date: 2026-07-13 08:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
5 1s110ms SELECT profile.take_sample ();[ Date: 2026-07-13 16:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
6 1s109ms SELECT profile.take_sample ();[ Date: 2026-07-13 19:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
7 1s90ms SELECT profile.take_sample ();[ Date: 2026-07-13 11:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
8 1s86ms SELECT profile.take_sample ();[ Date: 2026-07-13 13:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
9 1s64ms SELECT profile.take_sample ();[ Date: 2026-07-13 12:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
10 1s64ms SELECT profile.take_sample ();[ Date: 2026-07-13 09:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
11 1s53ms SELECT profile.take_sample ();[ Date: 2026-07-13 07:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
12 1s47ms SELECT profile.take_sample ();[ Date: 2026-07-13 15:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
13 1s28ms SELECT profile.take_sample ();[ Date: 2026-07-13 18:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 13s151ms 12 1s28ms 1s196ms 1s95ms select profile.take_sample ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 13 07 1 1s53ms 1s53ms 08 1 1s113ms 1s113ms 09 1 1s64ms 1s64ms 11 1 1s90ms 1s90ms 12 1 1s64ms 1s64ms 13 1 1s86ms 1s86ms 15 1 1s47ms 1s47ms 16 1 1s110ms 1s110ms 18 1 1s28ms 1s28ms 19 1 1s109ms 1s109ms 20 1 1s196ms 1s196ms 21 1 1s186ms 1s186ms [ User: postgres - Total duration: 13s151ms - Times executed: 12 ]
[ Application: psql - Total duration: 13s151ms - Times executed: 12 ]
-
SELECT profile.take_sample ();
Date: 2026-07-13 20:00:02 Duration: 1s196ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-13 21:00:02 Duration: 1s186ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-13 08:00:02 Duration: 1s113ms Database: etendo User: postgres Remote: [local] Application: psql
2 1s837ms 1 1s837ms 1s837ms 1s837ms select string_agg(distinct prac_checkacct_config (ca.c_acctschema_id, ca."name"), ?) from c_acctschema ca where ? = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 13 07 1 1s837ms 1s837ms [ User: postgres - Total duration: 1s837ms - Times executed: 1 ]
[ Application: psql - Total duration: 1s837ms - Times executed: 1 ]
-
SELECT string_agg(distinct prac_checkacct_config (ca.c_acctschema_id, ca."name"), ' \n ') from c_acctschema ca where 1 = 1;
Date: 2026-07-13 07:16:29 Duration: 1s837ms Database: etendo User: postgres Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 12 13s151ms 1s28ms 1s196ms 1s95ms select profile.take_sample ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 13 07 1 1s53ms 1s53ms 08 1 1s113ms 1s113ms 09 1 1s64ms 1s64ms 11 1 1s90ms 1s90ms 12 1 1s64ms 1s64ms 13 1 1s86ms 1s86ms 15 1 1s47ms 1s47ms 16 1 1s110ms 1s110ms 18 1 1s28ms 1s28ms 19 1 1s109ms 1s109ms 20 1 1s196ms 1s196ms 21 1 1s186ms 1s186ms [ User: postgres - Total duration: 13s151ms - Times executed: 12 ]
[ Application: psql - Total duration: 13s151ms - Times executed: 12 ]
-
SELECT profile.take_sample ();
Date: 2026-07-13 20:00:02 Duration: 1s196ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-13 21:00:02 Duration: 1s186ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-13 08:00:02 Duration: 1s113ms Database: etendo User: postgres Remote: [local] Application: psql
2 1 1s837ms 1s837ms 1s837ms 1s837ms select string_agg(distinct prac_checkacct_config (ca.c_acctschema_id, ca."name"), ?) from c_acctschema ca where ? = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 13 07 1 1s837ms 1s837ms [ User: postgres - Total duration: 1s837ms - Times executed: 1 ]
[ Application: psql - Total duration: 1s837ms - Times executed: 1 ]
-
SELECT string_agg(distinct prac_checkacct_config (ca.c_acctschema_id, ca."name"), ' \n ') from c_acctschema ca where 1 = 1;
Date: 2026-07-13 07:16:29 Duration: 1s837ms Database: etendo User: postgres Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1s837ms 1s837ms 1s837ms 1 1s837ms select string_agg(distinct prac_checkacct_config (ca.c_acctschema_id, ca."name"), ?) from c_acctschema ca where ? = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 13 07 1 1s837ms 1s837ms [ User: postgres - Total duration: 1s837ms - Times executed: 1 ]
[ Application: psql - Total duration: 1s837ms - Times executed: 1 ]
-
SELECT string_agg(distinct prac_checkacct_config (ca.c_acctschema_id, ca."name"), ' \n ') from c_acctschema ca where 1 = 1;
Date: 2026-07-13 07:16:29 Duration: 1s837ms Database: etendo User: postgres Remote: [local] Application: psql
2 1s28ms 1s196ms 1s95ms 12 13s151ms select profile.take_sample ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 13 07 1 1s53ms 1s53ms 08 1 1s113ms 1s113ms 09 1 1s64ms 1s64ms 11 1 1s90ms 1s90ms 12 1 1s64ms 1s64ms 13 1 1s86ms 1s86ms 15 1 1s47ms 1s47ms 16 1 1s110ms 1s110ms 18 1 1s28ms 1s28ms 19 1 1s109ms 1s109ms 20 1 1s196ms 1s196ms 21 1 1s186ms 1s186ms [ User: postgres - Total duration: 13s151ms - Times executed: 12 ]
[ Application: psql - Total duration: 13s151ms - Times executed: 12 ]
-
SELECT profile.take_sample ();
Date: 2026-07-13 20:00:02 Duration: 1s196ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-13 21:00:02 Duration: 1s186ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-13 08:00:02 Duration: 1s113ms Database: etendo User: postgres Remote: [local] Application: psql
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 46,271 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 339 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 325 Max number of times the same event was reported
- 340 Total events found
Rank Times reported Error 1 325 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", no encryption
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 13 07 22 08 38 09 21 10 21 11 20 12 19 13 21 14 19 15 23 16 24 17 21 18 22 19 22 20 22 21 10 - FATAL: no pg_hba.conf entry for host "159.65.148.75", user "appuser", database "postgres", no encryption
- FATAL: no pg_hba.conf entry for host "159.65.148.75", user "appuser", database "postgres", no encryption
- FATAL: no pg_hba.conf entry for host "159.65.148.75", user "appuser", database "postgres", no encryption
Date: 2026-07-13 07:00:18 Database: postgres Application: [unknown] User: appuser Remote: 159.65.148.75
Date: 2026-07-13 07:03:15 Database: postgres Application: [unknown] User: appuser Remote: 159.65.148.75
Date: 2026-07-13 07:05:53 Database: postgres Application: [unknown] User: appuser Remote: 159.65.148.75
2 5 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 13 16 1 18 1 21 3 - FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Date: 2026-07-13 16:53:26 Database: [unknown] Application: [unknown] User: [unknown] Remote: 65.49.1.152
Date: 2026-07-13 18:31:28 Database: [unknown] Application: [unknown] User: [unknown] Remote: 66.132.172.187
Date: 2026-07-13 21:28:52 Database: [unknown] Application: [unknown] User: [unknown] Remote: 137.184.31.121
3 3 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 13 16 1 18 1 21 1 - FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Date: 2026-07-13 16:53:27 Database: [unknown] Application: [unknown] User: [unknown] Remote: 65.49.1.152
Date: 2026-07-13 18:31:29 Database: [unknown] Application: [unknown] User: [unknown] Remote: 66.132.172.187
Date: 2026-07-13 21:28:52 Database: [unknown] Application: [unknown] User: [unknown] Remote: 137.184.31.121
4 2 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 13 16 1 18 1 - FATAL: no PostgreSQL user name specified in startup packet
- FATAL: no PostgreSQL user name specified in startup packet
Date: 2026-07-13 16:53:27 Database: [unknown] Application: [unknown] User: [unknown] Remote: 65.49.1.152
Date: 2026-07-13 18:31:30 Database: [unknown] Application: [unknown] User: [unknown] Remote: 66.132.172.187
5 2 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL encryption
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 13 07 1 13 1 - FATAL: no pg_hba.conf entry for host "34.62.181.128", user "postgres", database "postgres", SSL encryption
- FATAL: no pg_hba.conf entry for host "64.89.163.133", user "postgres", database "postgres", SSL encryption
Date: 2026-07-13 07:46:58 Database: postgres Application: [unknown] User: postgres Remote: 34.62.181.128
Date: 2026-07-13 13:37:15 Database: postgres Application: [unknown] User: postgres Remote: 64.89.163.133
6 1 FATAL: unsupported frontend protocol 27265.28208: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 13 21 1 - FATAL: unsupported frontend protocol 27265.28208: server supports 3.0 to 3.0
Date: 2026-07-13 21:28:51 Database: [unknown] Application: [unknown] User: [unknown] Remote: 146.190.78.56
7 1 FATAL: unsupported frontend protocol 65363.19778: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 13 21 1 - FATAL: unsupported frontend protocol 65363.19778: server supports 3.0 to 3.0
Date: 2026-07-13 21:28:51 Database: [unknown] Application: [unknown] User: [unknown] Remote: 146.190.78.56
8 1 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 13 21 1 - LOG: could not receive data from client: Connection reset by peer
Date: 2026-07-13 21:28:43 Database: [unknown] Application: [unknown] User: [unknown] Remote: 146.190.78.56