explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gmeU

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

Bitmap Heap Scan on customer (cost=8.57..12.58 rows=1 width=756) (actual time=0.020..0.020 rows=0 loops=1)

  • Recheck Cond: ((fk_organization_unit = 3) OR (customer_number = '123456'::text))
2. 0.001 0.019 ↓ 0.0 0 1

BitmapOr (cost=8.57..8.57 rows=1 width=0) (actual time=0.019..0.019 rows=0 loops=1)

3. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on customer_fk_organization_unit_idx (cost=0.00..4.28 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (fk_organization_unit = 3)
4. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on customer_customer_number_key (cost=0.00..4.28 rows=1 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (customer_number = '123456'::text)
Planning time : 0.155 ms
Execution time : 0.053 ms