explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zt6

Settings
# exclusive inclusive rows x rows loops node
1. 0.064 61.963 ↓ 5.6 500 1

Limit (cost=37.88..38.11 rows=89 width=570) (actual time=61.808..61.963 rows=500 loops=1)

2. 31.906 61.899 ↓ 5.6 500 1

Sort (cost=37.88..38.11 rows=89 width=570) (actual time=61.806..61.899 rows=500 loops=1)

  • Sort Key: t0_.name DESC
  • Sort Method: top-N heapsort Memory: 532kB
3. 11.819 29.993 ↓ 621.2 55,287 1

Nested Loop Left Join (cost=2.22..35.00 rows=89 width=570) (actual time=0.204..29.993 rows=55,287 loops=1)

4. 0.259 1.682 ↓ 48.2 868 1

Nested Loop Left Join (cost=1.94..26.50 rows=18 width=570) (actual time=0.193..1.682 rows=868 loops=1)

5. 0.105 0.667 ↓ 3.0 54 1

Nested Loop (cost=1.79..21.75 rows=18 width=570) (actual time=0.185..0.667 rows=54 loops=1)

6. 0.187 0.292 ↓ 2.2 54 1

Hash Join (cost=1.52..12.13 rows=24 width=16) (actual time=0.177..0.292 rows=54 loops=1)

  • Hash Cond: (t7_.organization_id = t9_.organization_id)
7. 0.084 0.084 ↑ 1.0 536 1

Seq Scan on tbl_organization_types t7_ (cost=0.00..8.36 rows=536 width=8) (actual time=0.019..0.084 rows=536 loops=1)

8. 0.009 0.021 ↑ 1.0 23 1

Hash (cost=1.23..1.23 rows=23 width=8) (actual time=0.021..0.021 rows=23 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.012 0.012 ↑ 1.0 23 1

Seq Scan on tbl_organization_responsibles t9_ (cost=0.00..1.23 rows=23 width=8) (actual time=0.005..0.012 rows=23 loops=1)

10. 0.270 0.270 ↑ 1.0 1 54

Index Scan using idx_16680_primary on tbl_organizations t0_ (cost=0.28..0.39 rows=1 width=570) (actual time=0.004..0.005 rows=1 loops=54)

  • Index Cond: (id = t7_.organization_id)
  • Filter: (name IS NOT NULL)
11. 0.756 0.756 ↓ 4.0 16 54

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.005..0.014 rows=16 loops=54)

  • Index Cond: (organization_id = t0_.id)
  • Heap Fetches: 868
12. 16.492 16.492 ↓ 12.8 64 868

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.004..0.019 rows=64 loops=868)

  • Index Cond: (organization_id = t0_.id)
  • Heap Fetches: 55287
Planning time : 1.791 ms
Execution time : 62.224 ms