explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H0oK

Settings
# exclusive inclusive rows x rows loops node
1. 0.079 0.723 ↑ 1.0 500 1

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

2. 0.130 0.644 ↑ 5.3 500 1

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

3. 0.010 0.248 ↑ 28.2 19 1

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

4. 0.072 0.204 ↑ 31.5 17 1

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

5. 0.041 0.041 ↑ 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.007..0.041 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.002..0.002 rows=1 loops=17)

  • Index Cond: (organization_id = t0_.id)
  • Heap Fetches: 9
8. 0.266 0.266 ↓ 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.005..0.014 rows=26 loops=19)

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