explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lgpY

Settings
# exclusive inclusive rows x rows loops node
1. 0.080 2.512 ↓ 27.8 500 1

Limit (cost=26.83..26.87 rows=18 width=570) (actual time=2.303..2.512 rows=500 loops=1)

2. 1.346 2.432 ↓ 27.8 500 1

Sort (cost=26.83..26.87 rows=18 width=570) (actual time=2.302..2.432 rows=500 loops=1)

  • Sort Key: t0_.name DESC
  • Sort Method: quicksort Memory: 899kB
3. 0.241 1.086 ↓ 48.2 868 1

Nested Loop Left Join (cost=1.94..26.45 rows=18 width=570) (actual time=0.196..1.086 rows=868 loops=1)

4. 0.064 0.467 ↓ 3.0 54 1

Nested Loop (cost=1.79..21.70 rows=18 width=570) (actual time=0.182..0.467 rows=54 loops=1)

5. 0.115 0.241 ↓ 2.2 54 1

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

  • Hash Cond: (t7_.organization_id = t9_.organization_id)
6. 0.099 0.099 ↑ 1.0 536 1

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

7. 0.019 0.027 ↑ 1.0 23 1

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

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

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

9. 0.162 0.162 ↑ 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.002..0.003 rows=1 loops=54)

  • Index Cond: (id = t7_.organization_id)
10. 0.378 0.378 ↓ 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.003..0.007 rows=16 loops=54)

  • Index Cond: (organization_id = t0_.id)
  • Heap Fetches: 868
Planning time : 1.032 ms
Execution time : 2.711 ms