explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lshi

Settings
# exclusive inclusive rows x rows loops node
1. 246.579 5,146.713 ↑ 1.6 1,168,239 1

Nested Loop (cost=0.43..113,901.75 rows=1,924,196 width=4) (actual time=5.579..5,146.713 rows=1,168,239 loops=1)

2. 28.980 28.980 ↓ 11.2 78,567 1

Seq Scan on tasks t (cost=0.00..1,735.41 rows=7,041 width=4) (actual time=0.053..28.980 rows=78,567 loops=1)

3. 4,871.154 4,871.154 ↑ 18.2 15 78,567

Index Only Scan using units_new_idx_task_id on units_new u (cost=0.43..13.20 rows=273 width=4) (actual time=0.026..0.062 rows=15 loops=78,567)

  • Index Cond: (task_id = t.id)
  • Heap Fetches: 1151