[Solved] Given the EXPLAIN output:Seq Scan on products (cost=0.00..100.00 rows=10 width=50)What does the rows=10 indicate? | PostgreSQL

PostgreSQL - Performance Tuning

Given the EXPLAIN output:

Seq Scan on products  (cost=0.00..100.00 rows=10 width=50)

What does the rows=10 indicate?

AMaximum rows allowed in the table

BEstimated number of rows the query will return

CNumber of rows scanned so far

DNumber of rows currently in the table

Step-by-Step Solution

Solution:

Step 1: Understand the meaning of rows in EXPLAIN
Rows shows the planner's estimate of rows output by this step.
Step 2: Differentiate from actual row counts
It is an estimate, not actual scanned or total rows in table.
Final Answer:
Estimated number of rows the query will return -> Option B
Quick Check:
rows=10 means estimated output rows [OK]

Quick Trick: rows= shows estimated output rows, not actual count [OK]

Common Mistakes:

Master "Performance Tuning" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Given the EXPLAIN output: