explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uRXC : with bag_type stats

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 0.047 ↑ 1.3 3 1

Hash Join (cost=1.69..7.48 rows=4 width=4) (actual time=0.036..0.047 rows=3 loops=1)

  • Hash Cond: (bag.bag_type_id = bag_type.id)
  • Buffers: shared hit=6
2. 0.019 0.019 ↑ 1.3 6 1

Index Only Scan using bag_owner_type_u1 on bag (cost=0.56..6.32 rows=8 width=8) (actual time=0.014..0.019 rows=6 loops=1)

  • Index Cond: (owner_id = '00000000-0000-0000-0000-000000076100'::uuid)
  • Heap Fetches: 6
  • Buffers: shared hit=5
3. 0.005 0.013 ↑ 1.0 3 1

Hash (cost=1.10..1.10 rows=3 width=8) (actual time=0.012..0.013 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
4. 0.008 0.008 ↑ 1.0 3 1

Seq Scan on bag_type (cost=0.00..1.10 rows=3 width=8) (actual time=0.004..0.008 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
Planning time : 0.220 ms
Execution time : 0.077 ms