explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 92BV : Optimization for: Optimization for: Optimization for: plan #hr5X; plan #pNT; plan #7Pfg

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 17.572 39.547 ↑ 1.2 55,118 1

Hash Join (cost=1,239.3..3,198.7 rows=68,838 width=8) (actual time=12.831..39.547 rows=55,118 loops=1)

  • Buffers: shared hit=743
2. 9.511 9.511 ↓ 1.0 79,155 1

Index Only Scan using ix_lobjectid_lsetid on dsmember dsmember (cost=0.42..1,752.01 rows=79,154 width=8) (actual time=0.029..9.511 rows=79,155 loops=1)

  • Heap Fetches: 135
  • Buffers: shared hit=567
3. 5.058 12.464 ↓ 1.0 38,099 1

Hash (cost=763.37..763.37 rows=38,041 width=4) (actual time=12.464..12.464 rows=38,099 loops=1)

  • Buffers: shared hit=176
4. 7.406 7.406 ↓ 1.0 38,099 1

Index Only Scan using idx_dsobject_lclassid_lid_4567 on dsobject dsobject (cost=0.29..763.37 rows=38,041 width=4) (actual time=0.029..7.406 rows=38,099 loops=1)

  • Heap Fetches: 7
  • Buffers: shared hit=176