explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Huio

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.017 ↓ 0.0 0 1

Nested Loop (cost=0.86..68.09 rows=1 width=4) (actual time=0.017..0.017 rows=0 loops=1)

2. 0.015 0.015 ↓ 0.0 0 1

Index Scan using temp_ir_attachment_res_model37 on assignment_assignment (cost=0.43..17.30 rows=6 width=4) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((active = true) AND (hr_employee_id = 1))
  • Filter: active
3. 0.000 0.000 ↓ 0.0 0

Index Scan using ir_attachment_res_idx on ir_attachment (cost=0.43..8.45 rows=1 width=8) (never executed)

  • Index Cond: (((res_model)::text = 'assignment.assignment'::text) AND (res_id = assignment_assignment.id))
  • Filter: (active AND ((res_field)::text = 'assignment_attachment_ids'::text))
Planning time : 1.778 ms
Execution time : 0.086 ms