explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IPBo

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Unique (cost=8.32..8.82 rows=100 width=32) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=8.32..8.32 rows=1 width=32) (actual rows= loops=)

  • Sort Key: (unnest(candidates.tags))
3. 0.000 0.000 ↓ 0.0

Index Scan using index_candidates_on_company_id on candidates (cost=0.29..8.31 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (company_id = 5)
  • Filter: (deleted_at IS NULL)