explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v2g1 : Optimization for: plan #Qbdb

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.013 0.069 ↓ 4.0 4 1

Nested Loop (cost=0.14..18.80 rows=1 width=1,488) (actual time=0.038..0.069 rows=4 loops=1)

2. 0.028 0.028 ↓ 7.0 7 1

Seq Scan on gms_employee employee (cost=0.00..10.62 rows=1 width=1,452) (actual time=0.018..0.028 rows=7 loops=1)

  • Filter: (''{mechanic}''::text[] <@ functions)
  • Rows Removed by Filter: 1
3. 0.028 0.028 ↑ 1.0 1 7

Index Scan using gms_shop_uuid_unique on gms_shop shop (cost=0.14..8.17 rows=1 width=52) (actual time=0.003..0.004 rows=1 loops=7)

  • Index Cond: (company_uuid = employee.company_uuid)
  • Filter: ((id = ANY (''{NL999999,NL666666}''::bpchar[])) AND (employee.current_shop = (id)::text))
  • Rows Removed by Filter: 2
Planning time : 0.330 ms
Execution time : 0.110 ms