
Blog


How to Kill an PostgreSQL process from inside PostgreSQL?

Find When was a table last changed in MySQL?

Find When was a table last changed in PostgreSQL?

How to detect chained and migrated rows in PostgreSQL?

How disk I/O influence MySQL performance?

Python script to monitor Linux Disk I/O matrix and save information in ClickHouse

Python script to monitor Linux Process Memory matrix and save information in ClickHouse
Python script to monitor Linux Process Memory matrix and save information in ClickHouse Here is a sample Python script that monitors the memory usage of Linux processes and saves the information in a ClickHouse database: […]

How pg_dump is different in PostgreSQL 16?
How pg_dump is different in PostgreSQL 16? The pg_dump command is a tool used to export data from a PostgreSQL database into a file. The tool has been included in PostgreSQL since version 7.0 and […]

How MySQL optimizer works?
How does MySQL optimizer work? The MySQL optimizer is responsible for determining the most efficient way to execute a SQL statement. It evaluates different query execution plans and chooses the one that it estimates will […]