explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q4d8

Settings
# exclusive inclusive rows x rows loops node
1. 0.098 0.750 ↑ 1.0 500 1

Limit (cost=0.98..128.93 rows=500 width=570) (actual time=0.042..0.750 rows=500 loops=1)

2. 0.118 0.652 ↑ 5.3 500 1

Nested Loop Left Join (cost=0.98..676.07 rows=2,638 width=570) (actual time=0.041..0.652 rows=500 loops=1)

3. 0.008 0.287 ↑ 28.2 19 1

Nested Loop Left Join (cost=0.70..422.94 rows=536 width=570) (actual time=0.037..0.287 rows=19 loops=1)

4. 0.022 0.245 ↑ 31.5 17 1

Nested Loop (cost=0.55..281.47 rows=536 width=570) (actual time=0.033..0.245 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..67.16 rows=683 width=570) (actual time=0.008..0.041 rows=91 loops=1)

  • Index Cond: (name IS NOT NULL)
6. 0.182 0.182 ↓ 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.002..0.002 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.247 0.247 ↓ 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.003..0.013 rows=26 loops=19)

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