explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9MXM

Settings
# exclusive inclusive rows x rows loops node
1. 0.050 0.483 ↑ 1.0 200 1

Limit (cost=0.98..449.18 rows=200 width=570) (actual time=0.208..0.483 rows=200 loops=1)

2. 0.079 0.433 ↑ 35.7 200 1

Nested Loop Left Join (cost=0.98..16,012.98 rows=7,145 width=570) (actual time=0.207..0.433 rows=200 loops=1)

3. 0.032 0.214 ↑ 363.0 4 1

Nested Loop (cost=0.70..15,327.26 rows=1,452 width=570) (actual time=0.177..0.214 rows=4 loops=1)

  • Join Filter: (t0_.id = t9_.organization_id)
  • Rows Removed by Join Filter: 104
4. 0.002 0.137 ↑ 107.2 5 1

Nested Loop Left Join (cost=0.70..420.14 rows=536 width=578) (actual time=0.109..0.137 rows=5 loops=1)

5. 0.011 0.084 ↑ 178.7 3 1

Nested Loop (cost=0.55..278.67 rows=536 width=578) (actual time=0.073..0.084 rows=3 loops=1)

6. 0.040 0.040 ↑ 227.7 3 1

Index Scan using organizations_name_unique_idx on tbl_organizations t0_ (cost=0.28..64.36 rows=683 width=570) (actual time=0.037..0.040 rows=3 loops=1)

7. 0.033 0.033 ↑ 1.0 1 3

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.011..0.011 rows=1 loops=3)

  • Index Cond: (organization_id = t0_.id)
  • Heap Fetches: 3
8. 0.051 0.051 ↑ 4.0 1 3

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.017..0.017 rows=1 loops=3)

  • Index Cond: (organization_id = t0_.id)
  • Heap Fetches: 4
9. 0.024 0.045 ↑ 84.1 22 5

Materialize (cost=0.00..37.75 rows=1,850 width=8) (actual time=0.003..0.009 rows=22 loops=5)

10. 0.021 0.021 ↑ 80.4 23 1

Seq Scan on tbl_organization_responsibles t9_ (cost=0.00..28.50 rows=1,850 width=8) (actual time=0.013..0.021 rows=23 loops=1)

11. 0.140 0.140 ↓ 10.0 50 4

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.012..0.035 rows=50 loops=4)

  • Index Cond: (organization_id = t0_.id)
  • Heap Fetches: 200
Planning time : 3.701 ms
Execution time : 0.621 ms