explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uppx

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.101 ↑ 1.0 1 1

Nested Loop (cost=8.72..18.20 rows=1 width=2,882) (actual time=0.096..0.101 rows=1 loops=1)

2. 0.005 0.073 ↑ 1.0 1 1

Nested Loop (cost=8.57..10.00 rows=1 width=2,768) (actual time=0.069..0.073 rows=1 loops=1)

3. 0.008 0.056 ↑ 1.0 1 1

Merge Join (cost=8.57..8.98 rows=1 width=2,764) (actual time=0.053..0.056 rows=1 loops=1)

  • Merge Cond: (c.id = u.country_id)
4. 0.011 0.011 ↑ 120.0 2 1

Index Scan using short_codes_pkey on short_codes c (cost=0.27..46.40 rows=240 width=11) (actual time=0.010..0.011 rows=2 loops=1)

5. 0.017 0.037 ↑ 1.0 1 1

Sort (cost=8.30..8.31 rows=1 width=2,757) (actual time=0.037..0.037 rows=1 loops=1)

  • Sort Key: u.country_id
  • Sort Method: quicksort Memory: 26kB
6. 0.020 0.020 ↑ 1.0 1 1

Index Scan using users_pkey on users u (cost=0.28..8.29 rows=1 width=2,757) (actual time=0.019..0.020 rows=1 loops=1)

  • Index Cond: (id = 9629)
7. 0.012 0.012 ↑ 1.0 1 1

Seq Scan on user_organization uo (cost=0.00..1.01 rows=1 width=8) (actual time=0.011..0.012 rows=1 loops=1)

  • Filter: (user_id = 9629)
8. 0.022 0.022 ↑ 1.0 1 1

Index Scan using organizations_pkey on organizations o (cost=0.15..8.17 rows=1 width=122) (actual time=0.021..0.022 rows=1 loops=1)

  • Index Cond: (id = uo.org_id)