explain.depesz.com

PostgreSQL's explain analyze made readable

Result: B2PU

Settings
# exclusive inclusive rows x rows loops node
1. 0.075 0.543 ↑ 1.0 500 1

Limit (cost=0.56..58.45 rows=500 width=570) (actual time=0.016..0.543 rows=500 loops=1)

2. 0.160 0.468 ↑ 6.7 500 1

Nested Loop Left Join (cost=0.56..389.72 rows=3,361 width=570) (actual time=0.016..0.468 rows=500 loops=1)

3. 0.021 0.021 ↑ 16.7 41 1

Index Scan Backward using name_strings_indexed on tbl_organizations t0_ (cost=0.28..67.16 rows=683 width=570) (actual time=0.008..0.021 rows=41 loops=1)

  • Index Cond: (name IS NOT NULL)
4. 0.287 0.287 ↓ 2.4 12 41

Index Only Scan using organization_country_unique_idx on tbl_organization_countries t3_ (cost=0.28..0.42 rows=5 width=8) (actual time=0.003..0.007 rows=12 loops=41)

  • Index Cond: (organization_id = t0_.id)
  • Heap Fetches: 488
Planning time : 0.418 ms
Execution time : 0.627 ms