explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TejZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.172 ↑ 1.0 1 1

GroupAggregate (cost=1.13..187.34 rows=1 width=16) (actual time=0.172..0.172 rows=1 loops=1)

  • Group Key: location1_.corporation_id
2. 0.001 0.161 ↓ 4.0 4 1

Nested Loop (cost=1.13..187.33 rows=1 width=16) (actual time=0.131..0.161 rows=4 loops=1)

3. 0.005 0.092 ↓ 2.0 4 1

Nested Loop (cost=0.71..184.45 rows=2 width=16) (actual time=0.075..0.092 rows=4 loops=1)

4. 0.053 0.053 ↓ 2.0 2 1

Index Scan using i_loc_corp_id on location location1_ (cost=0.29..2.31 rows=1 width=16) (actual time=0.052..0.053 rows=2 loops=1)

  • Index Cond: (corporation_id = 86707)
5. 0.034 0.034 ↑ 60.0 2 2

Index Scan using user_loc_loc_id on user_location userlocati0_ (cost=0.42..180.94 rows=120 width=16) (actual time=0.011..0.017 rows=2 loops=2)

  • Index Cond: (location_id = location1_.id)
  • Filter: ((termination_date IS NULL) OR (termination_date >= '2019-01-10 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 0
6. 0.068 0.068 ↑ 1.0 1 4

Index Only Scan using i_au_id_del on app_user user4_ (cost=0.42..1.44 rows=1 width=8) (actual time=0.017..0.017 rows=1 loops=4)

  • Index Cond: (id = userlocati0_.user_id)
  • Heap Fetches: 4