explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5ULI

Settings
# exclusive inclusive rows x rows loops node
1. 0.073 0.555 ↑ 1.0 500 1

Limit (cost=0.98..128.61 rows=500 width=570) (actual time=0.028..0.555 rows=500 loops=1)

2. 0.096 0.482 ↑ 5.3 500 1

Nested Loop Left Join (cost=0.98..674.37 rows=2,638 width=570) (actual time=0.027..0.482 rows=500 loops=1)

3. 0.004 0.177 ↑ 28.2 19 1

Nested Loop Left Join (cost=0.70..421.24 rows=536 width=570) (actual time=0.024..0.177 rows=19 loops=1)

4. 0.019 0.139 ↑ 31.5 17 1

Nested Loop (cost=0.55..279.76 rows=536 width=570) (actual time=0.021..0.139 rows=17 loops=1)

5. 0.029 0.029 ↑ 7.5 91 1

Index Scan Backward using organizations_name_unique_idx on tbl_organizations t0_ (cost=0.28..65.46 rows=683 width=570) (actual time=0.005..0.029 rows=91 loops=1)

6. 0.091 0.091 ↓ 0.0 0 91

Index Only Scan using idx_16705_organization_id on tbl_organization_types t7_ (cost=0.28..0.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=91)

  • Index Cond: (organization_id = t0_.id)
  • Heap Fetches: 17
7. 0.034 0.034 ↑ 4.0 1 17

Index Only Scan using organization_sector_unique_idx on tbl_organization_sectors t5_ (cost=0.15..0.22 rows=4 width=4) (actual time=0.001..0.002 rows=1 loops=17)

  • Index Cond: (organization_id = t0_.id)
  • Heap Fetches: 9
8. 0.209 0.209 ↓ 5.2 26 19

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.011 rows=26 loops=19)

  • Index Cond: (organization_id = t0_.id)
  • Heap Fetches: 499
Planning time : 0.623 ms
Execution time : 0.637 ms