explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9Fx4

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.027 92.659 ↓ 0.0 0 1

Update on table1 (cost=0.00..15,901.61 rows=1 width=32) (actual time=92.659..92.659 rows=0 loops=1)

2. 92.632 92.632 ↑ 1.0 1 1

Seq Scan on table1 (cost=0.00..15,901.61 rows=1 width=32) (actual time=92.632..92.632 rows=1 loops=1)

  • Filter: (id = 1)
  • Rows Removed by Filter: 534339