Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: pg-stat-activity

pg_stat_statements causing DB to run out of memory

By adminPosted on January 20, 2023

Question : I enabled pg_stat_statements on an AWS RDS postgres 9.6.3 instance with 30GB RAM. We got the error message […]

Why is pg_stat_activity.query_start null for almost all queries? [closed]

By adminPosted on April 12, 2022

Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]

pg_stat_activity entries with no corresponding process on the client

By adminPosted on March 16, 2022

Question : If I see an entry in pg_stat_activity for a client_addr:client_port combination where there is no process bound to […]

Recent Posts

  • Avoid using Many to Many Relationship
  • Does MySQL still handle indexes in this way?
  • Microsoft SQL Server equivalent to Oracle Enterprise Manger Top Activity Interface?
  • Retrieve next queue item
  • Why does ENCODE on BYTEA not seem to have any performance impact?
  • Applying Multiple Window Functions in 1 SELECT using different partition
  • With SQL Server’s Query Store, how can cleanup avoid deleting “least expensive” queries?
  • PostgreSQL 11 fails to start if add `listen_addresses = ‘*’` in pg_hba.conf
  • Joining two tables with an alias
  • What is hot spotting in the context of adding files to tempdb?
  • 1822, “Failed to add the foreign key constraint. Missing index for constraint in referenced table script [closed]
  • MySQL – cannot examine view definition – Error getting DDL for object – No database selected
  • Database design for a lot of rows with data archive
  • Is the Service Broker good for publishing data between servers?
  • MySQL – query to show guests with same last_name + booking_date [closed]
  • How can primary keys in a Netezza table be indexed?
  • Is Oracle more demanding environment for a DBA than SQL Server? [closed]
  • Tiny table causes extreme performance degradation, fixed by forced VACUUM. Why?
  • Generating an arithmetic sequence
  • Find jobs that succeeded, but had steps that failed

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding