explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hr5X

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 15.322 42.110 ↑ 1.7 40,827 1

Hash Join (cost=1,225.27..3,181.41 rows=68,839 width=8) (actual time=17.047..42.11 rows=40,827 loops=1)

  • Buffers: shared hit=659
2. 10.103 10.103 ↑ 1.0 79,154 1

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

  • Heap Fetches: 114
  • Buffers: shared hit=543
3. 5.106 16.685 ↓ 1.0 38,099 1

Hash (cost=749.34..749.34 rows=38,041 width=4) (actual time=16.684..16.685 rows=38,099 loops=1)

  • Buffers: shared hit=116
4. 11.579 11.579 ↓ 1.0 38,099 1

Index Only Scan using idx_dsobject_lclassid_lid_5968437 on dsobject dsobject (cost=0.29..749.34 rows=38,041 width=4) (actual time=0.018..11.579 rows=38,099 loops=1)

  • Index Cond: (lclassid = ANY ('{5,6,4,7}'::integer[]))
  • Heap Fetches: 7
  • Buffers: shared hit=116