Using pg_stat_statements to Track SQL Planning and Execution in PostgreSQL
The pg_stat_statements module in PostgreSQL provides a way to track the planning and execution statistics of all SQL statements executed by the server. It co...
Recent Posts
2024
Monitoring PostgreSQL Replication
PostgreSQL replication is a critical component of database high availability and disaster recovery. Ensuring that replication is running smoothly and identif...
How to Setup PostgreSQL Replication
Setting up PostgreSQL replication ensures that your database remains highly available, providing data redundancy and improving reliability. This guide walks ...
2019
Linux Hardlink and Softlink/Symlink explained.
What is Inode? it’s the metadata about a regular file and directory in Linux.
Confusing error: could not bind IPv4 socket: Cannot assign requested address
Postgres service failing with error: “could not bind IPv4 socket: Cannot assign requested address”
Welcome to New ScratchPad Blog!
Hello World! Every journey in the world of programming begins with a simple Hello World. So, it feels fitting that my very first blog post starts with the ...
2016
How to install LAMP Stack On CentOS 6
This is a simple and straight forward tutorial to install and configure LAMP stack (Linux, Apache, MySQL, PHP) on a CentOS 6 system.
Vim - Powerful Text Editor in Linux!
Vim is one of the handy and most common text editor in Linux. It is a text editor that is upwards compatible to Vi. It can be used to edit all kinds of plai...