pgBadger-
Global information
- Generated on Sun Jun 8 23:00:04 2025
- Log file: /var/lib/pgsql/16/data/log/postgresql-2025-06-08.log
- Parsed 40,373 log entries in 2s
- Log start from 2025-06-08 07:53:28 to 2025-06-08 22:24:37
-
Overview
Global Stats
- 32 Number of unique normalized queries
- 143 Number of queries
- 67ms Total query duration
- 2025-06-08 07:53:52 First query
- 2025-06-08 15:00:55 Last query
- 13 queries/s at 2025-06-08 10:27:05 Query peak
- 67ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 67ms Execute total duration
- 26 Number of events
- 9 Number of unique normalized events
- 11 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 34 Total number of sessions
- 7 sessions at 2025-06-08 22:24:37 Session peak
- 4h35m19s Total duration of sessions
- 8m5s Average duration of sessions
- 4 Average queries per session
- 1ms Average queries duration per session
- 8m5s Average idle time per session
- 34 Total number of connections
- 2 connections/s at 2025-06-08 10:27:05 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 13 queries/s Query Peak
- 2025-06-08 10:27:05 Date
SELECT Traffic
Key values
- 11 queries/s Query Peak
- 2025-06-08 10:27:05 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2025-06-08 10:41:27 Date
Queries duration
Key values
- 67ms 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) Jun 08 07 4 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 135 0ms 12ms 0ms 1ms 14ms 42ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 15 4 0ms 6ms 2ms 8ms 8ms 8ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 08 07 1 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 69 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 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) Jun 08 07 3 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 9 3 10 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 15 2 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 Jun 08 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% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 15 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 Jun 08 07 4 0.00/s 08 0 0.00/s 09 0 0.00/s 10 28 0.01/s 12 0 0.00/s 13 0 0.00/s 15 2 0.00/s 21 0 0.00/s 22 0 0.00/s Day Hour Count Average Duration Average idle time Jun 08 07 3 48ms 48ms 08 1 24m28s 24m28s 09 0 0ms 0ms 10 27 4m15s 4m15s 12 0 0ms 0ms 13 1 2h15m38s 2h15m38s 15 2 76ms 71ms 21 0 0ms 0ms 22 0 0ms 0ms -
Connections
Established Connections
Key values
- 2 connections Connection Peak
- 2025-06-08 10:27:05 Date
Connections per database
Key values
- ycvannadb Main Database
- 34 connections Total
Connections per user
Key values
- ycvanna Main User
- 34 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2025-06-08 22:24:37 Date
Histogram of session times
Key values
- 14 0-500ms duration
Sessions per database
Key values
- ycvannadb Main Database
- 34 sessions Total
Sessions per user
Key values
- ycvanna Main User
- 34 sessions Total
Sessions per host
Key values
- 117.173.225.27 Main Host
- 34 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 6 buffers Checkpoint Peak
- 2025-06-08 07:58:28 Date
- 0.302 seconds Highest write time
- 0.004 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2025-06-08 10:28:20 Date
Checkpoints distance
Key values
- 0.02 Mo Distance Peak
- 2025-06-08 10:33:21 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 08 07 6 0.302s 0.004s 0.317s 08 3 0.003s 0.004s 0.017s 09 0 0s 0s 0s 10 18 0.71s 0.018s 0.763s 12 0 0s 0s 0s 13 0 0s 0s 0s 15 4 0.302s 0.003s 0.309s 21 0 0s 0s 0s 22 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 08 07 0 0 0 5 0.002s 0.001s 08 0 0 0 2 0.002s 0.002s 09 0 0 0 0 0s 0s 10 0 0 0 16 0.002s 0.008s 12 0 0 0 0 0s 0s 13 0 0 0 0 0s 0s 15 0 0 0 4 0.002s 0.001s 21 0 0 0 0 0s 0s 22 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jun 08 07 0 0s 08 0 0s 09 0 0s 10 0 0s 12 0 0s 13 0 0s 15 0 0s 21 0 0s 22 0 0s Day Hour Mean distance Mean estimate Jun 08 07 6.00 kB 6.00 kB 08 0.00 kB 3.00 kB 09 0.00 kB 0.00 kB 10 4.71 kB 6.00 kB 12 0.00 kB 0.00 kB 13 0.00 kB 0.00 kB 15 7.00 kB 7.00 kB 21 0.00 kB 0.00 kB 22 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 08 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 12 0 0 0 13 0 0 0 15 0 0 0 21 0 0 0 22 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Vacuum throughput per table
Key values
- unknown (0) Max CPU elapsed for vacuum on database
- unknown (0 ms) Max I/O read time for vacuum on database
- unknown (0 ms) Max I/O write time for vacuum on database
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 08 07 0 0 08 0 0 09 0 0 10 0 0 12 0 0 13 0 0 15 0 0 21 0 0 22 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 70 Total read queries
- 27 Total write queries
Queries by database
Key values
- ycvannadb Main database
- 130 Requests
- 67ms (ycvannadb)
- Main time consuming database
Queries by user
Key values
- ycvanna Main user
- 141 Requests
User Request type Count Duration postgres Total 2 1ms select 1 0ms ycvanna Total 141 66ms delete 10 0ms insert 14 0ms others 22 0ms select 69 0ms update 3 0ms Duration by user
Key values
- 66ms (ycvanna) Main time consuming user
User Request type Count Duration postgres Total 2 1ms select 1 0ms ycvanna Total 141 66ms delete 10 0ms insert 14 0ms others 22 0ms select 69 0ms update 3 0ms Queries by host
Key values
- 117.173.225.27 Main host
- 116 Requests
- 56ms (117.173.225.27)
- Main time consuming host
Queries by application
Key values
- Navicat Main application
- 116 Requests
- 56ms (Navicat)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-06-08 10:41:27 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 14 1-5ms duration
Slowest individual queries
Rank Duration Query NO DATASET
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 2 0ms 0ms 0ms select n.nspname, c.relname, c.relkind from pg_class c left join pg_namespace n on n.oid = c.relnamespace where c.relkind = any (?::char[]) order by n.nspname, c.relkind, c.relname;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 08 10 2 0ms 0ms 2 0ms 3 0ms 0ms 0ms update "public"."employees" set "name" = ? where "id" = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 08 10 3 0ms 0ms 3 0ms 3 0ms 0ms 0ms show log_statement;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 08 10 3 0ms 0ms 4 0ms 2 0ms 0ms 0ms select e.extname as name, e.extversion as version, aev.version as available_version from "pg_catalog"."pg_extension" e inner join pg_available_extension_versions() aev on e.extname = aev.name order by name, available_version;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 08 10 2 0ms 0ms 5 0ms 11 0ms 0ms 0ms select c.oid, n.nspname as schemaname, c.relname as tablename, c.relacl, pg_get_userbyid(c.relowner) as tableowner, obj_description(c.oid) as description, c.relkind, ci.relname as cluster, c.relhasindex as hasindexes, c.relhasrules as hasrules, t.spcname as tablespace, c.reloptions as param, c.relhastriggers as hastriggers, c.relpersistence as unlogged, ft.ftoptions, fs.srvname, c.relispartition, pg_get_expr(c.relpartbound, c.oid) as relpartbound, c.reltuples, (( select count(*) from pg_inherits where inhparent = c.oid) > ?) as inhtable, i2.nspname as inhschemaname, i2.relname as inhtablename from pg_class c left join pg_namespace n on n.oid = c.relnamespace left join pg_tablespace t on t.oid = c.reltablespace left join (pg_inherits i inner join pg_class c2 on i.inhparent = c2.oid left join pg_namespace n2 on n2.oid = c2.relnamespace) i2 on i2.inhrelid = c.oid left join pg_index ind on (ind.indrelid = c.oid) and (ind.indisclustered = ?) left join pg_class ci on ci.oid = ind.indexrelid left join pg_foreign_table ft on ft.ftrelid = c.oid left join pg_foreign_server fs on ft.ftserver = fs.oid where ((c.relkind = ?::"char") or (c.relkind = ?::"char") or (c.relkind = ?::"char")) and n.nspname = ? order by schemaname, tablename;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 08 10 11 0ms 0ms 6 0ms 1 0ms 0ms 0ms select t.oid, n.nspname, t.typname from pg_type t left join pg_namespace n on t.typnamespace = n.oid;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 08 10 1 0ms 0ms 7 0ms 2 0ms 0ms 0ms select oid, nspname as schemaname, nspacl, pg_get_userbyid(nspowner) as schemaowner, obj_description(oid) as description from pg_namespace;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 08 10 2 0ms 0ms 8 0ms 1 0ms 0ms 0ms select * from "public"."employees";Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 08 10 1 0ms 0ms 9 0ms 2 0ms 0ms 0ms select * from employees;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 08 07 1 0ms 0ms 10 1 0ms 0ms 10 0ms 6 0ms 0ms 0ms select opr.oid, opr.oprname, nsp.nspname from pg_operator opr, pg_namespace nsp where opr.oprnamespace = nsp.oid;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 08 10 6 0ms 0ms 11 0ms 4 0ms 0ms 0ms select i.indrelid as oid, ci.relname as indexname, ct.relname as tablename, am.amname, con.conexclop, i.indkey, i.indclass, i.indnatts, i.indoption, i.indexrelid from pg_index i left join pg_class ct on ct.oid = i.indrelid left join pg_class ci on ci.oid = i.indexrelid left join pg_namespace tns on tns.oid = ct.relnamespace left join pg_namespace ins on ins.oid = ci.relnamespace left join pg_tablespace ts on ci.reltablespace = ts.oid left join pg_am am on ci.relam = am.oid left join pg_depend dep on dep.classid = ci.tableoid and dep.objid = ci.oid and dep.refobjsubid = ? left join pg_constraint con on con.tableoid = dep.refclassid and con.oid = dep.refobjid and con.contype = ? where tns.nspname = ? and ct.relname = ? and conname is not null;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 08 10 4 0ms 0ms 12 0ms 2 0ms 0ms 0ms select cl.column_name, ty.typtype, ty.typname from information_schema.columns cl left join pg_type ty on ty.typname = cl.udt_name where cl.table_schema = ? and cl.table_name = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 08 10 2 0ms 0ms 13 0ms 4 0ms 0ms 0ms select t.relname as tablename, fns.nspname as foreign_schema, f.relname as foreign_table, c.conname, c.confkey, a.attname as foreign_field, a.attnum from pg_constraint c left join pg_namespace ns on (c.connamespace = ns.oid) left join pg_class t on (c.conrelid = t.oid) inner join pg_class f on (c.confrelid = f.oid) left join pg_namespace fns on (f.relnamespace = fns.oid) inner join pg_attribute a on (a.attrelid = f.oid) where a.attnum > ? and ns.nspname = ? and t.relname = ? order by t.relname, c.conname, a.attnum;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 08 10 4 0ms 0ms 14 0ms 10 0ms 0ms 0ms delete from "public"."employees" where "id" = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 08 10 10 0ms 0ms 15 0ms 4 0ms 0ms 0ms select c.oid, c.conname, c.contype, c.condeferrable, c.condeferred, c.conkey, c.confupdtype, c.confdeltype, c.confmatchtype, pg_get_constraintdef(c.oid, true) as consrc12, t.relname as tablename, fns.nspname as foreign_schema, f.relname as foreign_table, obj_description(c.oid) as comment, ts.spcname, i.reloptions as param, c.conindid, am.amname, pg_get_expr(ci.indpred, ci.indrelid, true) where_predicate, t.relkind, connoinherit from pg_constraint c left join pg_namespace ns on (c.connamespace = ns.oid) left join pg_class t on (c.conrelid = t.oid) left join pg_class i on (c.conname = i.relname) and (c.connamespace = i.relnamespace) left join pg_class f on (c.confrelid = f.oid) left join pg_namespace fns on (f.relnamespace = fns.oid) left join pg_tablespace ts on (i.reltablespace = ts.oid) left join pg_am am on (i.relam = am.oid) left join pg_index ci on (c.conindid = ci.indexrelid) where ns.nspname = ? and t.relname = ? order by t.relname, i.oid;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 08 10 4 0ms 0ms 16 0ms 1 0ms 0ms 0ms select n.nspname as schema, p.oid as oid, p.proname as functionname, p.proargtypes as params, p.proacl as acl, typ.typname as rettype, p.prosecdef as securitydefiner, p.proisstrict as strict, p.proretset as returnset, p.provolatile as volatile, coalesce(pg_catalog.pg_get_function_sqlbody (p.oid), p.prosrc) as definition, p.probin as objfile, p.proargnames as paramnames, p.proargmodes as parammodes, p.proallargtypes as paramalltypes, p.procost as estimcost, p.prorows as estimrows, p.proconfig as configparams, pg_get_expr(p.proargdefaults, ?::regclass) as defaultvalues, p.proparallel as proparallel, p.prokind as prokind, obj_description(p.oid) as comment, pg_get_userbyid(p.proowner) as funcowner, typ.typname as typname, typns.nspname as rettypeschema, l.lanname as lang from pg_proc p left join pg_type typ on typ.oid = p.prorettype left join pg_namespace typns on typns.oid = typ.typnamespace left join pg_namespace n on n.oid = p.pronamespace left join pg_language l on l.oid = p.prolang left join pg_database d on d.datname = current_database() where p.prokind <> ? and n.nspname = ? order by p.proname asc;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 08 10 1 0ms 0ms 17 0ms 1 0ms 0ms 0ms select t.oid as oid, (n.nspname)::information_schema.sql_identifier as trigger_schema, (t.tgname)::information_schema.sql_identifier as trigger_name, (c.relname)::information_schema.sql_identifier as trigger_table_name, (em.text)::information_schema.character_data as event_manipulation, (c.relkind)::information_schema.sql_identifier as trigger_table_type, (nsp.nspname)::information_schema.sql_identifier as referenced_table_schema, (cs.relname)::information_schema.sql_identifier as referenced_table, t.tgdeferrable as is_deferrable, t.tginitdeferred as is_deferred, (np.nspname)::information_schema.sql_identifier as function_schema, (p.proname)::information_schema.sql_identifier as function_name, ("substring" (pg_get_triggerdef(t.oid), ("position" ("substring" (pg_get_triggerdef(t.oid), ?), ?::text) + ?)))::information_schema.character_data as action_statement, ( case when (((t.tgtype)::integer & ?) = ?) then ?::text else ?::text end)::information_schema.character_data as for_each, ( case when (((t.tgtype)::integer & ?) = ?) then ?::text else ?::text end)::information_schema.character_data as fire_time, t.tgenabled as enabled, ( case when pg_has_role(c.relowner, ?::text) then ( select rm.m[?] as m from regexp_matches(pg_get_triggerdef(t.oid), (e ?::text)) rm (m) limit ?) else null::text end)::information_schema.character_data as condition, tc.event_object_column as update_columns, (t.tgconstraint > ?) as is_constraint, t.tgisinternal as is_internal, obj_description(t.oid) as comment from pg_trigger t inner join pg_class c on t.tgrelid = c.oid left join pg_namespace n on c.relnamespace = n.oid left join pg_proc p on t.tgfoid = p.oid left join pg_namespace np on p.pronamespace = np.oid left join ((( select ?, ? union all select ?, ?) union all select ?, ?) union all select ?, ?) em (num, text) on ((t.tgtype)::integer & em.num) <> ? left outer join ( select oid, relnamespace, relname from pg_class) cs on (t.tgconstrrelid = cs.oid) left outer join ( select oid, nspname from pg_namespace) nsp on (cs.relnamespace = nsp.oid) left join information_schema.triggered_update_columns tc on (tc.trigger_schema = n.nspname) and (tc.trigger_name = t.tgname) and (tc.event_object_schema = n.nspname) and (tc.event_object_table = c.relname) where (n.nspname)::information_schema.sql_identifier = ? and (c.relname)::information_schema.sql_identifier = ? order by c.relname, t.tgname asc;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 08 10 1 0ms 0ms 18 0ms 2 0ms 0ms 0ms select c.oid, n.nspname as schemaname, c.relname as viewname, c.relacl, pg_get_userbyid(c.relowner) as viewowner, obj_description(c.oid) as description, pg_get_viewdef(c.oid, true) as definition, c.reloptions as options from pg_class c left join pg_namespace n on c.relnamespace = n.oid where c.relkind = ?::"char" and n.nspname = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 08 10 2 0ms 0ms 19 0ms 2 0ms 0ms 0ms select n.nspname, c.relname, a.attname, tp.typname from pg_attribute a join pg_class c on a.attrelid = c.oid join pg_namespace n on c.relnamespace = n.oid join pg_type tp on tp.oid = a.atttypid where a.attnum > ? order by nspname, relname;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 08 10 2 0ms 0ms 20 0ms 15 0ms 0ms 0ms set client_encoding to ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 08 10 15 0ms 0ms Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 15 0ms 0ms 0ms 0ms set client_encoding to ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 08 10 15 0ms 0ms 2 14 0ms 0ms 0ms 0ms insert into employees (name, age) values (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 08 07 3 0ms 0ms 10 9 0ms 0ms 15 2 0ms 0ms 3 11 0ms 0ms 0ms 0ms select c.oid, n.nspname as schemaname, c.relname as tablename, c.relacl, pg_get_userbyid(c.relowner) as tableowner, obj_description(c.oid) as description, c.relkind, ci.relname as cluster, c.relhasindex as hasindexes, c.relhasrules as hasrules, t.spcname as tablespace, c.reloptions as param, c.relhastriggers as hastriggers, c.relpersistence as unlogged, ft.ftoptions, fs.srvname, c.relispartition, pg_get_expr(c.relpartbound, c.oid) as relpartbound, c.reltuples, (( select count(*) from pg_inherits where inhparent = c.oid) > ?) as inhtable, i2.nspname as inhschemaname, i2.relname as inhtablename from pg_class c left join pg_namespace n on n.oid = c.relnamespace left join pg_tablespace t on t.oid = c.reltablespace left join (pg_inherits i inner join pg_class c2 on i.inhparent = c2.oid left join pg_namespace n2 on n2.oid = c2.relnamespace) i2 on i2.inhrelid = c.oid left join pg_index ind on (ind.indrelid = c.oid) and (ind.indisclustered = ?) left join pg_class ci on ci.oid = ind.indexrelid left join pg_foreign_table ft on ft.ftrelid = c.oid left join pg_foreign_server fs on ft.ftserver = fs.oid where ((c.relkind = ?::"char") or (c.relkind = ?::"char") or (c.relkind = ?::"char")) and n.nspname = ? order by schemaname, tablename;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 08 10 11 0ms 0ms 4 10 0ms 0ms 0ms 0ms delete from "public"."employees" where "id" = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 08 10 10 0ms 0ms 5 6 0ms 0ms 0ms 0ms select opr.oid, opr.oprname, nsp.nspname from pg_operator opr, pg_namespace nsp where opr.oprnamespace = nsp.oid;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 08 10 6 0ms 0ms 6 5 0ms 0ms 0ms 0ms select col.table_schema as schema_name, col.table_name, col.column_name, col.character_maximum_length, col.is_nullable, col.numeric_precision, col.numeric_scale, col.datetime_precision, col.ordinal_position, b.atttypmod, b.attndims, col.data_type as col_type, et.typelem, et.typlen, et.typtype, nbt.nspname as elem_schema, bt.typname as elem_name, b.atttypid, col.udt_schema, col.udt_name, col.domain_catalog, col.domain_schema, col.domain_name, col_description(c.oid, col.ordinal_position) as comment, col.column_default as col_default, col.is_identity, col.identity_generation, col.identity_start, col.identity_increment, col.identity_maximum, col.identity_minimum, seq.seqcache::information_schema.character_data as identity_cache, col.identity_cycle, col.is_generated, col.generation_expression, b.attacl, colnsp.nspname as collation_schema_name, coll.collname, c.relkind, b.attfdwoptions as foreign_options from information_schema.columns as col left join pg_namespace ns on ns.nspname = col.table_schema left join pg_class c on col.table_name = c.relname and c.relnamespace = ns.oid left join pg_attrdef a on c.oid = a.adrelid and col.ordinal_position = a.adnum left join pg_attribute b on b.attrelid = c.oid and b.attname = col.column_name left join pg_type et on et.oid = b.atttypid left join pg_collation coll on coll.oid = b.attcollation left join pg_namespace colnsp on coll.collnamespace = colnsp.oid left join (pg_depend dep join pg_sequence seq on dep.classid = ?::regclass::oid and dep.objid = seq.seqrelid and dep.deptype = ?::"char") on dep.refclassid = ?::regclass::oid and dep.refobjid = c.oid and dep.refobjsubid = b.attnum left join pg_type bt on et.typelem = bt.oid left join pg_namespace nbt on bt.typnamespace = nbt.oid where col.table_schema = ? and col.table_name = ? order by col.table_schema, col.table_name, col.ordinal_position;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 08 10 5 0ms 0ms 7 4 0ms 0ms 0ms 0ms select i.indrelid as oid, ci.relname as indexname, ct.relname as tablename, am.amname, con.conexclop, i.indkey, i.indclass, i.indnatts, i.indoption, i.indexrelid from pg_index i left join pg_class ct on ct.oid = i.indrelid left join pg_class ci on ci.oid = i.indexrelid left join pg_namespace tns on tns.oid = ct.relnamespace left join pg_namespace ins on ins.oid = ci.relnamespace left join pg_tablespace ts on ci.reltablespace = ts.oid left join pg_am am on ci.relam = am.oid left join pg_depend dep on dep.classid = ci.tableoid and dep.objid = ci.oid and dep.refobjsubid = ? left join pg_constraint con on con.tableoid = dep.refclassid and con.oid = dep.refobjid and con.contype = ? where tns.nspname = ? and ct.relname = ? and conname is not null;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 08 10 4 0ms 0ms 8 4 0ms 0ms 0ms 0ms select t.relname as tablename, fns.nspname as foreign_schema, f.relname as foreign_table, c.conname, c.confkey, a.attname as foreign_field, a.attnum from pg_constraint c left join pg_namespace ns on (c.connamespace = ns.oid) left join pg_class t on (c.conrelid = t.oid) inner join pg_class f on (c.confrelid = f.oid) left join pg_namespace fns on (f.relnamespace = fns.oid) inner join pg_attribute a on (a.attrelid = f.oid) where a.attnum > ? and ns.nspname = ? and t.relname = ? order by t.relname, c.conname, a.attnum;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 08 10 4 0ms 0ms 9 4 0ms 0ms 0ms 0ms select c.oid, c.conname, c.contype, c.condeferrable, c.condeferred, c.conkey, c.confupdtype, c.confdeltype, c.confmatchtype, pg_get_constraintdef(c.oid, true) as consrc12, t.relname as tablename, fns.nspname as foreign_schema, f.relname as foreign_table, obj_description(c.oid) as comment, ts.spcname, i.reloptions as param, c.conindid, am.amname, pg_get_expr(ci.indpred, ci.indrelid, true) where_predicate, t.relkind, connoinherit from pg_constraint c left join pg_namespace ns on (c.connamespace = ns.oid) left join pg_class t on (c.conrelid = t.oid) left join pg_class i on (c.conname = i.relname) and (c.connamespace = i.relnamespace) left join pg_class f on (c.confrelid = f.oid) left join pg_namespace fns on (f.relnamespace = fns.oid) left join pg_tablespace ts on (i.reltablespace = ts.oid) left join pg_am am on (i.relam = am.oid) left join pg_index ci on (c.conindid = ci.indexrelid) where ns.nspname = ? and t.relname = ? order by t.relname, i.oid;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 08 10 4 0ms 0ms 10 4 0ms 0ms 0ms 0ms select opc.oid, opc.opcname, nsp.nspname from pg_opclass opc, pg_namespace nsp where opc.opcnamespace = nsp.oid;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 08 10 4 0ms 0ms 11 3 0ms 0ms 0ms 0ms update "public"."employees" set "name" = ? where "id" = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 08 10 3 0ms 0ms 12 3 0ms 0ms 0ms 0ms show log_statement;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 08 10 3 0ms 0ms 13 3 0ms 0ms 0ms 0ms show log_min_duration_statement;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 08 10 3 0ms 0ms 14 3 0ms 0ms 0ms 0ms select * from "public"."employees" where "id" = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 08 10 3 0ms 0ms 15 3 0ms 0ms 0ms 0ms select * from "public"."employees" limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 08 10 3 0ms 0ms 16 2 0ms 0ms 0ms 0ms select n.nspname, c.relname, c.relkind from pg_class c left join pg_namespace n on n.oid = c.relnamespace where c.relkind = any (?::char[]) order by n.nspname, c.relkind, c.relname;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 08 10 2 0ms 0ms 17 2 0ms 0ms 0ms 0ms select e.extname as name, e.extversion as version, aev.version as available_version from "pg_catalog"."pg_extension" e inner join pg_available_extension_versions() aev on e.extname = aev.name order by name, available_version;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 08 10 2 0ms 0ms 18 2 0ms 0ms 0ms 0ms select oid, nspname as schemaname, nspacl, pg_get_userbyid(nspowner) as schemaowner, obj_description(oid) as description from pg_namespace;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 08 10 2 0ms 0ms 19 2 0ms 0ms 0ms 0ms select * from employees;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 08 07 1 0ms 0ms 10 1 0ms 0ms 20 2 0ms 0ms 0ms 0ms select cl.column_name, ty.typtype, ty.typname from information_schema.columns cl left join pg_type ty on ty.typname = cl.udt_name where cl.table_schema = ? and cl.table_name = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 08 10 2 0ms 0ms Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 0ms 0ms 0ms 2 0ms select n.nspname, c.relname, c.relkind from pg_class c left join pg_namespace n on n.oid = c.relnamespace where c.relkind = any (?::char[]) order by n.nspname, c.relkind, c.relname;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 08 10 2 0ms 0ms 2 0ms 0ms 0ms 3 0ms update "public"."employees" set "name" = ? where "id" = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 08 10 3 0ms 0ms 3 0ms 0ms 0ms 3 0ms show log_statement;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 08 10 3 0ms 0ms 4 0ms 0ms 0ms 2 0ms select e.extname as name, e.extversion as version, aev.version as available_version from "pg_catalog"."pg_extension" e inner join pg_available_extension_versions() aev on e.extname = aev.name order by name, available_version;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 08 10 2 0ms 0ms 5 0ms 0ms 0ms 11 0ms select c.oid, n.nspname as schemaname, c.relname as tablename, c.relacl, pg_get_userbyid(c.relowner) as tableowner, obj_description(c.oid) as description, c.relkind, ci.relname as cluster, c.relhasindex as hasindexes, c.relhasrules as hasrules, t.spcname as tablespace, c.reloptions as param, c.relhastriggers as hastriggers, c.relpersistence as unlogged, ft.ftoptions, fs.srvname, c.relispartition, pg_get_expr(c.relpartbound, c.oid) as relpartbound, c.reltuples, (( select count(*) from pg_inherits where inhparent = c.oid) > ?) as inhtable, i2.nspname as inhschemaname, i2.relname as inhtablename from pg_class c left join pg_namespace n on n.oid = c.relnamespace left join pg_tablespace t on t.oid = c.reltablespace left join (pg_inherits i inner join pg_class c2 on i.inhparent = c2.oid left join pg_namespace n2 on n2.oid = c2.relnamespace) i2 on i2.inhrelid = c.oid left join pg_index ind on (ind.indrelid = c.oid) and (ind.indisclustered = ?) left join pg_class ci on ci.oid = ind.indexrelid left join pg_foreign_table ft on ft.ftrelid = c.oid left join pg_foreign_server fs on ft.ftserver = fs.oid where ((c.relkind = ?::"char") or (c.relkind = ?::"char") or (c.relkind = ?::"char")) and n.nspname = ? order by schemaname, tablename;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 08 10 11 0ms 0ms 6 0ms 0ms 0ms 1 0ms select t.oid, n.nspname, t.typname from pg_type t left join pg_namespace n on t.typnamespace = n.oid;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 08 10 1 0ms 0ms 7 0ms 0ms 0ms 2 0ms select oid, nspname as schemaname, nspacl, pg_get_userbyid(nspowner) as schemaowner, obj_description(oid) as description from pg_namespace;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 08 10 2 0ms 0ms 8 0ms 0ms 0ms 1 0ms select * from "public"."employees";Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 08 10 1 0ms 0ms 9 0ms 0ms 0ms 2 0ms select * from employees;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 08 07 1 0ms 0ms 10 1 0ms 0ms 10 0ms 0ms 0ms 6 0ms select opr.oid, opr.oprname, nsp.nspname from pg_operator opr, pg_namespace nsp where opr.oprnamespace = nsp.oid;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 08 10 6 0ms 0ms 11 0ms 0ms 0ms 4 0ms select i.indrelid as oid, ci.relname as indexname, ct.relname as tablename, am.amname, con.conexclop, i.indkey, i.indclass, i.indnatts, i.indoption, i.indexrelid from pg_index i left join pg_class ct on ct.oid = i.indrelid left join pg_class ci on ci.oid = i.indexrelid left join pg_namespace tns on tns.oid = ct.relnamespace left join pg_namespace ins on ins.oid = ci.relnamespace left join pg_tablespace ts on ci.reltablespace = ts.oid left join pg_am am on ci.relam = am.oid left join pg_depend dep on dep.classid = ci.tableoid and dep.objid = ci.oid and dep.refobjsubid = ? left join pg_constraint con on con.tableoid = dep.refclassid and con.oid = dep.refobjid and con.contype = ? where tns.nspname = ? and ct.relname = ? and conname is not null;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 08 10 4 0ms 0ms 12 0ms 0ms 0ms 2 0ms select cl.column_name, ty.typtype, ty.typname from information_schema.columns cl left join pg_type ty on ty.typname = cl.udt_name where cl.table_schema = ? and cl.table_name = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 08 10 2 0ms 0ms 13 0ms 0ms 0ms 4 0ms select t.relname as tablename, fns.nspname as foreign_schema, f.relname as foreign_table, c.conname, c.confkey, a.attname as foreign_field, a.attnum from pg_constraint c left join pg_namespace ns on (c.connamespace = ns.oid) left join pg_class t on (c.conrelid = t.oid) inner join pg_class f on (c.confrelid = f.oid) left join pg_namespace fns on (f.relnamespace = fns.oid) inner join pg_attribute a on (a.attrelid = f.oid) where a.attnum > ? and ns.nspname = ? and t.relname = ? order by t.relname, c.conname, a.attnum;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 08 10 4 0ms 0ms 14 0ms 0ms 0ms 10 0ms delete from "public"."employees" where "id" = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 08 10 10 0ms 0ms 15 0ms 0ms 0ms 4 0ms select c.oid, c.conname, c.contype, c.condeferrable, c.condeferred, c.conkey, c.confupdtype, c.confdeltype, c.confmatchtype, pg_get_constraintdef(c.oid, true) as consrc12, t.relname as tablename, fns.nspname as foreign_schema, f.relname as foreign_table, obj_description(c.oid) as comment, ts.spcname, i.reloptions as param, c.conindid, am.amname, pg_get_expr(ci.indpred, ci.indrelid, true) where_predicate, t.relkind, connoinherit from pg_constraint c left join pg_namespace ns on (c.connamespace = ns.oid) left join pg_class t on (c.conrelid = t.oid) left join pg_class i on (c.conname = i.relname) and (c.connamespace = i.relnamespace) left join pg_class f on (c.confrelid = f.oid) left join pg_namespace fns on (f.relnamespace = fns.oid) left join pg_tablespace ts on (i.reltablespace = ts.oid) left join pg_am am on (i.relam = am.oid) left join pg_index ci on (c.conindid = ci.indexrelid) where ns.nspname = ? and t.relname = ? order by t.relname, i.oid;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 08 10 4 0ms 0ms 16 0ms 0ms 0ms 1 0ms select n.nspname as schema, p.oid as oid, p.proname as functionname, p.proargtypes as params, p.proacl as acl, typ.typname as rettype, p.prosecdef as securitydefiner, p.proisstrict as strict, p.proretset as returnset, p.provolatile as volatile, coalesce(pg_catalog.pg_get_function_sqlbody (p.oid), p.prosrc) as definition, p.probin as objfile, p.proargnames as paramnames, p.proargmodes as parammodes, p.proallargtypes as paramalltypes, p.procost as estimcost, p.prorows as estimrows, p.proconfig as configparams, pg_get_expr(p.proargdefaults, ?::regclass) as defaultvalues, p.proparallel as proparallel, p.prokind as prokind, obj_description(p.oid) as comment, pg_get_userbyid(p.proowner) as funcowner, typ.typname as typname, typns.nspname as rettypeschema, l.lanname as lang from pg_proc p left join pg_type typ on typ.oid = p.prorettype left join pg_namespace typns on typns.oid = typ.typnamespace left join pg_namespace n on n.oid = p.pronamespace left join pg_language l on l.oid = p.prolang left join pg_database d on d.datname = current_database() where p.prokind <> ? and n.nspname = ? order by p.proname asc;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 08 10 1 0ms 0ms 17 0ms 0ms 0ms 1 0ms select t.oid as oid, (n.nspname)::information_schema.sql_identifier as trigger_schema, (t.tgname)::information_schema.sql_identifier as trigger_name, (c.relname)::information_schema.sql_identifier as trigger_table_name, (em.text)::information_schema.character_data as event_manipulation, (c.relkind)::information_schema.sql_identifier as trigger_table_type, (nsp.nspname)::information_schema.sql_identifier as referenced_table_schema, (cs.relname)::information_schema.sql_identifier as referenced_table, t.tgdeferrable as is_deferrable, t.tginitdeferred as is_deferred, (np.nspname)::information_schema.sql_identifier as function_schema, (p.proname)::information_schema.sql_identifier as function_name, ("substring" (pg_get_triggerdef(t.oid), ("position" ("substring" (pg_get_triggerdef(t.oid), ?), ?::text) + ?)))::information_schema.character_data as action_statement, ( case when (((t.tgtype)::integer & ?) = ?) then ?::text else ?::text end)::information_schema.character_data as for_each, ( case when (((t.tgtype)::integer & ?) = ?) then ?::text else ?::text end)::information_schema.character_data as fire_time, t.tgenabled as enabled, ( case when pg_has_role(c.relowner, ?::text) then ( select rm.m[?] as m from regexp_matches(pg_get_triggerdef(t.oid), (e ?::text)) rm (m) limit ?) else null::text end)::information_schema.character_data as condition, tc.event_object_column as update_columns, (t.tgconstraint > ?) as is_constraint, t.tgisinternal as is_internal, obj_description(t.oid) as comment from pg_trigger t inner join pg_class c on t.tgrelid = c.oid left join pg_namespace n on c.relnamespace = n.oid left join pg_proc p on t.tgfoid = p.oid left join pg_namespace np on p.pronamespace = np.oid left join ((( select ?, ? union all select ?, ?) union all select ?, ?) union all select ?, ?) em (num, text) on ((t.tgtype)::integer & em.num) <> ? left outer join ( select oid, relnamespace, relname from pg_class) cs on (t.tgconstrrelid = cs.oid) left outer join ( select oid, nspname from pg_namespace) nsp on (cs.relnamespace = nsp.oid) left join information_schema.triggered_update_columns tc on (tc.trigger_schema = n.nspname) and (tc.trigger_name = t.tgname) and (tc.event_object_schema = n.nspname) and (tc.event_object_table = c.relname) where (n.nspname)::information_schema.sql_identifier = ? and (c.relname)::information_schema.sql_identifier = ? order by c.relname, t.tgname asc;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 08 10 1 0ms 0ms 18 0ms 0ms 0ms 2 0ms select c.oid, n.nspname as schemaname, c.relname as viewname, c.relacl, pg_get_userbyid(c.relowner) as viewowner, obj_description(c.oid) as description, pg_get_viewdef(c.oid, true) as definition, c.reloptions as options from pg_class c left join pg_namespace n on c.relnamespace = n.oid where c.relkind = ?::"char" and n.nspname = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 08 10 2 0ms 0ms 19 0ms 0ms 0ms 2 0ms select n.nspname, c.relname, a.attname, tp.typname from pg_attribute a join pg_class c on a.attrelid = c.oid join pg_namespace n on c.relnamespace = n.oid join pg_type tp on tp.oid = a.atttypid where a.attnum > ? order by nspname, relname;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 08 10 2 0ms 0ms 20 0ms 0ms 0ms 15 0ms set client_encoding to ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 08 10 15 0ms 0ms Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 2 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 08 10 2 0ms 0ms -
;
Date: Duration: 0ms Database: postgres User: ycvannadb Remote: ycvanna Application: 117.173.225.27 Queryid: Navicat
-
Events
Log levels
Key values
- 7,235 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 18 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 8 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 11 Max number of times the same event was reported
- 26 Total events found
Rank Times reported Error 1 11 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 08 08 1 10 10 2 4 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 08 07 1 08 1 10 2 3 3 FATAL: password authentication failed for user "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 08 10 3 - FATAL: password authentication failed for user "postgres"
Detail: Connection matched file "/var/lib/pgsql/16/data/pg_hba.conf" line 112: "local all all md5"
Date: 2025-06-08 10:43:38 Database: postgres Application: [unknown] User: postgres Remote: [local]
4 3 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 08 10 3 5 1 FATAL: unsupported frontend protocol 65363.19778: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 08 21 1 6 1 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 08 13 1 7 1 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 08 22 1 8 1 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 08 22 1 9 1 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 08 22 1