explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Efom

Settings
# exclusive inclusive rows x rows loops node
1. 1,276.349 1,425.842 ↓ 1.3 12,128 1

HashAggregate (cost=1,116,261.92..1,116,354.49 rows=9,257 width=1,620) (actual time=1,405.447..1,425.842 rows=12,128 loops=1)

  • Group Key: e.id, e.min_hours, e.max_hours, e.min_pay, e.max_pay, e.datecreated, e.user_id, e.notice_timeframe, e.parent_id, e.deleted,
2. 147.548 149.493 ↓ 1.3 12,128 1

Nested Loop (cost=0.99..1,114,989.08 rows=9,257 width=1,620) (actual time=0.053..149.493 rows=12,128 loops=1)

  • -> Index Scan using emp_user_id on employee e (cost=0.57..2388.38 rows=2931 width=1620) (actual time=0.031..0.099 rows=10 loop
3. 1.945 1.945 ↓ 2.6 1,186 1

Index Scan using i_au_corp on app_user au (cost=0.42..432.81 rows=461 width=8) (actual time=0.030..1.945 rows=1,186 loops=1)

  • Index Cond: (corporation_id = 53921)
  • Index Cond: (user_id = au.id)