explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GO3Y

Settings
# exclusive inclusive rows x rows loops node
1. 0.070 19.767 ↓ 4.4 500 1

Limit (cost=54.27..54.56 rows=113 width=570) (actual time=19.612..19.767 rows=500 loops=1)

2. 10.066 19.697 ↓ 4.4 500 1

Sort (cost=54.27..54.56 rows=113 width=570) (actual time=19.610..19.697 rows=500 loops=1)

  • Sort Key: t0_.name DESC
  • Sort Method: top-N heapsort Memory: 532kB
3. 3.709 9.631 ↓ 165.4 18,685 1

Nested Loop Left Join (cost=0.70..50.42 rows=113 width=570) (actual time=0.039..9.631 rows=18,685 loops=1)

4. 0.107 0.594 ↓ 12.9 296 1

Nested Loop Left Join (cost=0.42..39.56 rows=23 width=570) (actual time=0.030..0.594 rows=296 loops=1)

5. 0.067 0.257 ↑ 1.0 23 1

Nested Loop (cost=0.28..33.49 rows=23 width=570) (actual time=0.023..0.257 rows=23 loops=1)

6. 0.029 0.029 ↑ 1.0 23 1

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

7. 0.161 0.161 ↑ 1.0 1 23

Index Scan using idx_16680_primary on tbl_organizations t0_ (cost=0.28..1.39 rows=1 width=570) (actual time=0.006..0.007 rows=1 loops=23)

  • Index Cond: (id = t9_.organization_id)
8. 0.230 0.230 ↓ 3.2 13 23

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.010 rows=13 loops=23)

  • Index Cond: (organization_id = t0_.id)
  • Heap Fetches: 296
9. 5.328 5.328 ↓ 12.6 63 296

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.018 rows=63 loops=296)

  • Index Cond: (organization_id = t0_.id)
  • Heap Fetches: 18685
Planning time : 0.499 ms
Execution time : 19.960 ms