Skip to content

Root Fan

Linux & Oracle DBA Blog

  • Home
  • Contact
  • About
  • Index

Tag: slow queries

Posted on September 26, 2025September 30, 2025

PostgreSQL SQL Tuning: How to Find and Fix Slow Queries

Colorful abstract pattern background

Even the best hardware can’t save you from poorly written SQL.

PostgreSQL provides powerful tools to analyze query execution and optimize performance.

In this article, we’ll explore the fundamentals of SQL tuning so you can identify bottlenecks and make your queries run faster.

Continue reading “PostgreSQL SQL Tuning: How to Find and Fix Slow Queries”

Unmissable Posts

  • Copy Password File From Primary ASM to Standby ASM on Oracle 19c
  • Oracle 19c RMAN Duplicate Database From Backup
  • RMAN Level 0 and Level 1 Backup Script
  • Step by Step Data Guard Broker Configuration in Oracle 19c
  • How to Change AWR Retention Period in Oracle Database

Recent Posts

  • How to Read an AWR Report in Oracle
  • PostgreSQL Performance Tuning: How to Optimize Your Database Server
  • PostgreSQL SQL Tuning: How to Find and Fix Slow Queries
  • Oracle Exadata vs ExaCC vs ExaCS
  • Oracle Query to Check RMAN Backup Status

Categories

  • Apache
  • Exadata
  • Firewall
  • Linux
  • Oracle
  • Postfix
  • PostgreSQL
  • Security
  • Ubuntu

Unmissable posts

  • Bash Script to Check if Port is Open
  • RMAN Level 0 and Level 1 Backup Script
  • How to Enable Archive Log Mode in Oracle 19c
  • How to Check PDB Status in Oracle
  • How to Restore an Oracle Database From a Backup
  • How to Read an AWR Report in Oracle
  • PostgreSQL Performance Tuning: How to Optimize Your Database Server
  • PostgreSQL SQL Tuning: How to Find and Fix Slow Queries
  • Oracle Exadata vs ExaCC vs ExaCS
  • Oracle Query to Check RMAN Backup Status

Categories

  • Apache
  • Exadata
  • Firewall
  • Linux
  • Oracle
  • Postfix
  • PostgreSQL
  • Security
  • Ubuntu

EN
EN
ES FR

  • Facebook
  • Twitter
  • Email
Privacy Policy Proudly powered by WordPress