explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MZ5 : Optimization for: plan #a6L9

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.187 0.189 ↓ 0.0 0 1

Insert on query_plan_test4 (cost=0..0.01 rows=1 width=520) (actual time=0.189..0.189 rows=0 loops=1)

  • Buffers: shared hit=1 read=1 dirtied=3 written=2
2. 0.002 0.002 ↑ 1.0 1 1

Result (cost=0..0.01 rows=1 width=520) (actual time=0.001..0.002 rows=1 loops=1)

Planning time : 0.022 ms
Execution time : 0.227 ms