#	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

                                                                QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
 LockRows  (cost=1.14..2.16 rows=1 width=40) (actual time=0.009..0.010 rows=1 loops=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
         ->  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

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	0.003 ms	30.0 %
Bitmap Index Scan	1	0.003 ms	30.0 %
LockRows	1	0.004 ms	40.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
minimum_change_number	1	0.003 ms	30.0 %
Bitmap Heap Scan	1	0.003 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: A0Om : Optimization for: plan #kXcq

Color mode:

Visible columns:

Optimization path:

Per node type stats

Per table stats