explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qbdb

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.007 0.048 ↓ 4.0 4 1

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

2. 0.020 0.020 ↓ 7.0 7 1

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

  • Filter: (''{mechanic}''::text[] <@ functions)
  • Rows Removed by Filter: 1
3. 0.021 0.021 ↑ 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.002..0.003 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.192 ms
Execution time : 0.073 ms