explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2lUC

Settings
# exclusive inclusive rows x rows loops node
1. 0.090 0.645 ↓ 5.6 500 1

Limit (cost=2.22..34.95 rows=89 width=570) (actual time=0.228..0.645 rows=500 loops=1)

2. 0.133 0.555 ↓ 5.6 500 1

Nested Loop Left Join (cost=2.22..34.95 rows=89 width=570) (actual time=0.227..0.555 rows=500 loops=1)

3. 0.007 0.222 ↑ 2.2 8 1

Nested Loop Left Join (cost=1.94..26.45 rows=18 width=570) (actual time=0.216..0.222 rows=8 loops=1)

4. 0.002 0.206 ↑ 18.0 1 1

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

5. 0.091 0.193 ↑ 24.0 1 1

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

  • Hash Cond: (t7_.organization_id = t9_.organization_id)
6. 0.082 0.082 ↑ 1.2 437 1

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

7. 0.010 0.020 ↑ 1.0 23 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.010 0.010 ↑ 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.010 rows=23 loops=1)

9. 0.011 0.011 ↑ 1.0 1 1

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

  • Index Cond: (id = t7_.organization_id)
10. 0.009 0.009 ↓ 2.0 8 1

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.006..0.009 rows=8 loops=1)

  • Index Cond: (organization_id = t0_.id)
  • Heap Fetches: 8
11. 0.200 0.200 ↓ 12.4 62 8

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.006..0.025 rows=62 loops=8)

  • Index Cond: (organization_id = t0_.id)
  • Heap Fetches: 500
Planning time : 1.717 ms
Execution time : 0.828 ms