Getting started with PGBouncer in PostgreSQL

Resource management is one of the key thing in all RDBMS. DB Connections is one of them. In PostgreSQL, Allocating more connections without proper analysis of resources causes an overhead in Memory usage and the creation of an OS process for each connection will lead to a scheduling overhead in the time-sharing operating system. These … Continue reading Getting started with PGBouncer in PostgreSQL

Row scanned equals to 1, Is the query is optimally tuned ?

A few days ago one of our intern @mydbops reached me with a SQL query. The query scans only a row according to the execution plan. But query does not seems optimally performing. Below is the SQL query and its explain plan. ( MySQL 5.7 ) select username, role from user_roles where username= '9977223389' ORDER … Continue reading Row scanned equals to 1, Is the query is optimally tuned ?