PostgreSQL insights

Open SourceVersions: [18.1]443 metrics

OpenTelemetry·

New table creation with foreign key and composite indexesinfo

19d ago▸

Queryset result cache causes unbounded memory growth on large datasets

process.runtime.cpython.memory

20d ago▸

N+1 query pattern executes one query per object for related records

db.client.queries.count db.client.operation.duration

20d ago▸

PostgreSQL connection count exceeds limits causing memory exhaustion

db.client.connections.usage db.client.operation.duration

20d ago▸

Django CONN_MAX_AGE interferes with PgBouncer connection pooling

20d ago▸

Server-side cursors with iterator() hold long transactions causing lock contention

db.client.operation.duration

20d ago▸

Removed assets permanently reappear in catalog after wipeAssets callwarning

dagster.daemon.healthy dagster.daemon.heartbeat

22d ago▸

wipeAssets mutation incompletely removes events from event_logs tablewarning

22d ago▸

Concurrency limit initialization crashes PostgreSQL runs with UniqueViolationcritical

dagster.run.failed

29d ago▸

PostgreSQL service stopped prevents Veeam ONE report generation

29d ago▸

SSPI authentication failure blocks Veeam ONE caching service database access

29d ago▸

Incorrect PostgreSQL password prevents Veeam ONE database connectivity

29d ago▸

Veeam ONE reports fail with caching service database connection errors

29d ago▸

Checkpoint spikes cause I/O contention and query latencywarning

postgresql.bgwriter.checkpoint.count postgresql.bgwriter.checkpoint.requested postgresql.bgwriter.sync_time+1 more

1mo ago▸

Logical replication stops on constraint violations requiring manual resolutioncritical

postgresql.subscription.apply_error postgresql.conflicts

1mo ago▸

Slow query logging disabled prevents identification of performance issueswarning

1mo ago▸

Lock contention visible in pg_locks indicates waiting processeswarning

postgresql.locks waiting_queries

1mo ago▸

Frequent pg_locks queries can degrade database performancewarning

1mo ago▸

Prepared transactions hold locks indefinitely until commit or rollbackcritical

postgresql.locks

1mo ago▸

Cross-database lock information incomplete in pg_locksinfo

1mo ago▸

Row-level locks not visible in pg_locks during normal operationinfo

postgresql.locks

1mo ago▸

pg_locks data may be inconsistent during collection due to fast-path locksinfo

1mo ago▸

Row-level security on subscriber tables causes replication conflictswarning

postgresql.subscription.apply_error postgresql.conflicts

1mo ago▸

Missing data on UPDATE/DELETE operations silently skipped in logical replicationwarning

postgresql.replication.replay_lag postgresql.replication.flush_lag

1mo ago▸

Permission failures on target tables halt logical replicationcritical

postgresql.subscription.apply_error postgresql.conflicts

1mo ago▸

Transaction skipping can cause subscriber data inconsistencywarning

1mo ago▸

Statistics collection disabled prevents visibility into query performancewarning

1mo ago▸

Unclean shutdown resets all statistics counters losing historical datawarning

1mo ago▸

Statistics lag causes monitoring to miss active transactions and queriesinfo

1mo ago▸

Statistics cached for transaction duration causing stale datawarning

1mo ago▸