explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2AyP : without bag_type stats

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.038 ↓ 3.0 3 1

Nested Loop (cost=0.56..4.37 rows=1 width=4) (actual time=0.022..0.038 rows=3 loops=1)

  • Buffers: shared hit=16
2. 0.011 0.011 ↓ 3.0 3 1

Seq Scan on bag_type (cost=0.00..1.10 rows=1 width=8) (actual time=0.007..0.011 rows=3 loops=1)

  • Filter: ((game = 'test_ronin'::text) AND (name = ANY ('{item,wallet,buildingFixed}'::text[])))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=1
3. 0.018 0.018 ↑ 1.0 1 3

Index Only Scan using bag_owner_type_u1 on bag (cost=0.56..2.78 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=3)

  • Index Cond: ((owner_id = '00000000-0000-0000-0000-000000076100'::uuid) AND (bag_type_id = bag_type.id))
  • Heap Fetches: 3
  • Buffers: shared hit=15
Planning time : 0.170 ms
Execution time : 0.063 ms