---
title: "kiran sabne (@kiransabne) | Hashnode"
description: "SQL Developer and Backend Developer. Read the latest articles by kiran sabne on Hashnode."
url: "https://hashnode.com/@kiransabne"
---

@kiransabne

# kiran sabne

@kiransabne · Joined February 2022

SQL Developer and Backend Developer

### [PostgreSQL Nested Loop: When Is It Actually a Problem?](https://kiransabne.dev/postgresql-nested-loop-when-is-it-actually-a-problem?utm_source=hashnode&utm_medium=feed)

When a Postgres Nested Loop join is fine vs. when outer rows × inner loops actually costs you — real EXPLAIN ANALYZE examples.

3 min read · [kiransabne.dev](https://kiransabne.dev/postgresql-nested-loop-when-is-it-actually-a-problem?utm_source=hashnode&utm_medium=feed)

[Sep 18](https://hashnode.com/posts/postgresql-nested-loop-when-is-it-actually-a-problem/6aad16149e5b1cc05dd4d181)

### [PostgreSQL Index Bloat: Why It Happens and How to Fix It](https://kiransabne.dev/postgresql-index-bloat-why-it-happens-and-how-to-fix-it?utm_source=hashnode&utm_medium=feed)

Why PostgreSQL indexes bloat even after VACUUM, how to measure it with pgstatindex, and when to use REINDEX CONCURRENTLY or pg\_repack to fix it.

6 min read · [kiransabne.dev](https://kiransabne.dev/postgresql-index-bloat-why-it-happens-and-how-to-fix-it?utm_source=hashnode&utm_medium=feed)

[Sep 18](https://hashnode.com/posts/postgresql-index-bloat-why-it-happens-and-how-to-fix-it/6aacdb14c88db9c85cde799f)

### [PostgreSQL VACUUM: Why It Exists (and What Happens When It Falls Behind)](https://kiransabne.dev/postgresql-vacuum-why-it-exists-and-what-happens-when-it-falls-behind?utm_source=hashnode&utm_medium=feed)

How PostgreSQL's MVCC creates dead tuples, what VACUUM actually does, why autovacuum falls behind, and how to tune it before bloat and wraparound hit.

7 min read · [kiransabne.dev](https://kiransabne.dev/postgresql-vacuum-why-it-exists-and-what-happens-when-it-falls-behind?utm_source=hashnode&utm_medium=feed)

[Aug 25](https://hashnode.com/posts/postgresql-vacuum-why-it-exists-and-what-happens-when-it-falls-behind/6a8d3c79f207f4a6cde7d591)

### [How to Read a PostgreSQL Execution Plan: The Complete Guide (With Real Examples)](https://kiransabne.dev/how-to-read-a-postgresql-execution-plan-the-complete-guide-with-real-examples?utm_source=hashnode&utm_medium=feed)

Learn to read PostgreSQL execution plans step by step. EXPLAIN ANALYZE, node types, buffers, and real production examples

17 min read · [kiransabne.dev](https://kiransabne.dev/how-to-read-a-postgresql-execution-plan-the-complete-guide-with-real-examples?utm_source=hashnode&utm_medium=feed)

[Aug 22](https://hashnode.com/posts/how-to-read-a-postgresql-execution-plan-the-complete-guide-with-real-examples/6a895774efd93b0140a7add6)

### [How do you write efficient pagination for millions of rows?](https://kiransabne.dev/how-to-write-efficient-pagination-for-millions-of-rows?utm_source=hashnode&utm_medium=feed)

Learn efficient pagination for PostgreSQL to optimize API, UI, and high-concurrency performance

3 min read · [kiransabne.dev](https://kiransabne.dev/how-to-write-efficient-pagination-for-millions-of-rows?utm_source=hashnode&utm_medium=feed)

[Jan 9](https://hashnode.com/posts/how-to-write-efficient-pagination-for-millions-of-rows/6960701f3d45d04a0f707769)
