explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WoPH

Settings
# exclusive inclusive rows x rows loops node
1. 0.076 0.695 ↑ 1.0 500 1

Limit (cost=0.98..128.61 rows=500 width=570) (actual time=0.039..0.695 rows=500 loops=1)

2. 0.117 0.619 ↑ 5.3 500 1

Nested Loop Left Join (cost=0.98..674.37 rows=2,638 width=570) (actual time=0.039..0.619 rows=500 loops=1)

3. 0.011 0.236 ↑ 28.2 19 1

Nested Loop Left Join (cost=0.70..421.24 rows=536 width=570) (actual time=0.033..0.236 rows=19 loops=1)

4. 0.063 0.191 ↑ 31.5 17 1

Nested Loop (cost=0.55..279.76 rows=536 width=570) (actual time=0.029..0.191 rows=17 loops=1)

5. 0.037 0.037 ↑ 7.5 91 1

Index Scan Backward using name_strings_indexed on tbl_organizations t0_ (cost=0.28..65.46 rows=683 width=570) (actual time=0.008..0.037 rows=91 loops=1)

6. 0.091 0.091 ↓ 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.001..0.001 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.266 0.266 ↓ 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.014 rows=26 loops=19)

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