explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kXcq

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.004 0.010 ↑ 1.0 1 1

LockRows (cost=1.14..2.16 rows=1 width=40) (actual time=0.009..0.010 rows=1 loops=1)

2. 0.003 0.006 ↑ 1.0 1 1

Bitmap Heap Scan on minimum_change_number minimumcha0_ (cost=1.14..2.15 rows=1 width=40) (actual time=0.005..0.006 rows=1 loops=1)

  • Recheck Cond: ((id)::text = 'GLOBAL_CONSIDERATION_SET'::text)
  • Heap Blocks: exact=1
3. 0.003 0.003 ↑ 1.0 1 1

Bitmap Index Scan on pk_min_change_num_id (cost=0.00..1.14 rows=1 width=0) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: ((id)::text = 'GLOBAL_CONSIDERATION_SET'::text)
Planning time : 0.063 ms
Execution time : 0.033 ms