explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6AoFx

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

Nested Loop (cost=8.44..24.73 rows=140 width=3,104) (actual time=0.090..0.091 rows=0 loops=1)

2. 0.026 0.082 ↑ 14.0 1 1

Hash Join (cost=8.31..17.73 rows=14 width=2,596) (actual time=0.079..0.082 rows=1 loops=1)

  • Hash Cond: (eu.user_id = u.id)
3. 0.003 0.036 ↑ 140.0 1 1

Nested Loop (cost=0.14..9.18 rows=140 width=528) (actual time=0.034..0.036 rows=1 loops=1)

4. 0.015 0.015 ↑ 1.0 1 1

Seq Scan on entities e (cost=0.00..1.01 rows=1 width=520) (actual time=0.014..0.015 rows=1 loops=1)

  • Filter: (entity_uuid = '47924938-36e6-11ea-978f-2e728ce88125'::uuid)
  • Rows Removed by Filter: 1
5. 0.018 0.018 ↑ 1.0 1 1

Index Only Scan using entity_users_pkey on entity_users eu (cost=0.14..8.16 rows=1 width=8) (actual time=0.017..0.018 rows=1 loops=1)

  • Index Cond: (entity_id = e.id)
  • Heap Fetches: 1
6. 0.005 0.020 ↑ 1.0 1 1

Hash (cost=8.15..8.15 rows=1 width=2,076) (actual time=0.020..0.020 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.015 0.015 ↑ 1.0 1 1

Index Scan using uq_users_uuid on users u (cost=0.14..8.15 rows=1 width=2,076) (actual time=0.014..0.015 rows=1 loops=1)

  • Index Cond: (user_uuid = '47924da2-36e6-11ea-978f-2e728ce88125'::uuid)
8. 0.007 0.007 ↓ 0.0 0 1

Index Scan using ob_profile_pkey on ob_profile ob (cost=0.14..0.50 rows=1 width=520) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (entity_id = eu.entity_id)
Planning time : 0.790 ms
Execution time : 0.267 ms