explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DXSq

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0 3,962 1

Gather (cost=0..0 rows=0 width=0) (actual rows=3,962 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.000 0.000 ↓ 0.0 1,321 3 / 3

Nested Loop (cost=0..0 rows=0 width=0) (actual rows=1,321 loops=3)

3. 0.000 0.000 ↓ 0.0 1,321 3 / 3

Nested Loop (cost=0..0 rows=0 width=0) (actual rows=1,321 loops=3)

4. 0.000 0.000 ↓ 0.0 1,496 3 / 3

Index Scan using employee_attribute_employee_id_company_attribute_id_company_id_ on employee_attribute ea (cost=0..0 rows=0 width=0) (actual rows=1,496 loops=3)

  • Index Cond: (company_id = 546)
5. 0.000 0.000 ↓ 0.0 1 4,489 / 3

Index Scan using company_attribute_pkey on company_attribute ca (cost=0..0 rows=0 width=0) (actual rows=1 loops=4,489)

  • Index Cond: (id = ea.company_attribute_id)
  • Filter: ((NOT deleted) AND ((type)::text <> ALL ('{hash,roles}'::text[])))
6. 0.000 0.000 ↓ 0.0 1 3,962 / 3

Index Scan using employee_pkey on employee e (cost=0..0 rows=0 width=0) (actual rows=1 loops=3,962)

  • Index Cond: (id = ea.employee_id)