ViewTube

You added an index, but EXPLAIN ANALYZE still says Seq Scan. This beginner-friendly guide explains what an index really is, ...

A query execution plan step by step on a table with a million products: cost, rows and width, planning and execution time ...

How to find and cancel a query waiting for a lock: the Lock Manager in DBeaver, the pg_locks view joined with pg_stat_activity ...

SQL Window Functions – Part 4 | LEAD() & LAG()** إزاي تقارن الصف الحالي بصف قبله أو بعده في SQL من غير ما تعمل JOIN للجدول ...

Index types in PostgreSQL and how to choose them with USING: the default B-tree, Hash for the equality operator, GiST and SP ...

When you have neither DBeaver nor psql, you can explore a database with SQL alone: pg_database and pg_database_size with ...

In March 2024, an SSH login that should have taken 0.3 seconds took 0.8. Andres Freund, a PostgreSQL developer, noticed the ...

Why not to store passwords as plain text or the salt next to them. The pgcrypto extension: encrypt and decrypt give the same ...

Simple data quality fixes in SELECT: duplicates with GROUP BY and HAVING, inconsistent names with SUBSTRING, codes outside the ...

The most common mistakes when improving performance: more RAM and CPU straight away, putting indexes on everything, solving a ...

Hash Join is the join you will see most often in a plan: the database computes a hash function for the smaller set, builds a ...