explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1vRk

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.017 ↓ 0.0 0 1

Update on batch (cost=0.00..4,813.16 rows=230 width=321) (actual time=0.016..0.017 rows=0 loops=1)

2. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on batch (cost=0.00..4,813.16 rows=230 width=321) (actual time=0.012..0.013 rows=0 loops=1)

3.          

SubPlan (forSeq Scan)

4. 0.000 0.000 ↓ 0.0 0

Result (cost=20.86..20.87 rows=1 width=4) (never executed)

5.          

Initplan (forResult)

6. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=20.85..20.86 rows=1 width=4) (never executed)

7.          

Initplan (forAggregate)

8. 0.000 0.000 ↓ 0.0 0

Index Scan using processingstage_pkey on processingstage so (cost=0.15..8.17 rows=1 width=4) (never executed)

  • Index Cond: (id = batch.processingstageid)
9. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on processingstage ps (cost=4.18..12.66 rows=1 width=4) (never executed)

  • Recheck Cond: (projectid = batch.projectid)
  • Filter: ((stageorder >= $2) AND (COALESCE(batchtypeid, 0) = COALESCE(batch.batchtypeid, 0)))
10. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ix_processingstage_projectid (cost=0.00..4.18 rows=4 width=0) (never executed)

  • Index Cond: (projectid = batch.projectid)