explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ioz

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.010 ↓ 0.0 0 1

Update on dns_app_instance (cost=1.41..2.43 rows=1 width=1,831) (actual time=0.010..0.010 rows=0 loops=1)

2. 0.004 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on dns_app_instance (cost=1.41..2.43 rows=1 width=1,831) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: (id = '5000007851'::numeric)
  • Filter: (obj_version = '8941340'::numeric)
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=1
3. 0.005 0.005 ↑ 1.0 1 1

Bitmap Index Scan on pk_dns_app_instance_id (cost=0.00..1.41 rows=1 width=0) (actual time=0.004..0.005 rows=1 loops=1)

  • Index Cond: (id = '5000007851'::numeric)
Planning time : 0.287 ms
Execution time : 0.122 ms