explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ioqI

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,714.004 ↑ 1.0 1 1

Finalize Aggregate (cost=112,119.69..112,119.70 rows=1 width=8) (actual time=1,714.003..1,714.004 rows=1 loops=1)

  • Buffers: shared hit=45593 read=36146
  • I/O Timings: read=102.921
2. 6.150 1,714.984 ↓ 1.5 3 1

Gather (cost=112,119.47..112,119.68 rows=2 width=8) (actual time=1,713.461..1,714.984 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=45593 read=36146
  • I/O Timings: read=102.921
3. 299.689 1,708.834 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=111,119.47..111,119.48 rows=1 width=8) (actual time=1,708.834..1,708.834 rows=1 loops=3)

  • Buffers: shared hit=45593 read=36146
  • I/O Timings: read=102.921
4. 1,059.197 1,409.145 ↑ 1.3 1,497,914 3 / 3

Hash Join (cost=2.93..106,286.30 rows=1,933,268 width=16) (actual time=0.087..1,409.145 rows=1,497,914 loops=3)

  • Hash Cond: (sit.storeid = userstorepermission.storeid)
  • Buffers: shared hit=45593 read=36146
  • I/O Timings: read=102.921
5. 349.915 349.915 ↑ 1.2 1,497,914 3 / 3

Parallel Seq Scan on stockitemtransaction sit (cost=0.00..100,390.97 rows=1,872,297 width=32) (actual time=0.004..349.915 rows=1,497,914 loops=3)

  • Buffers: shared hit=45522 read=36146
  • I/O Timings: read=102.921
6. 0.009 0.033 ↑ 1.0 22 3 / 3

Hash (cost=2.66..2.66 rows=22 width=16) (actual time=0.032..0.033 rows=22 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=11
7. 0.024 0.024 ↑ 1.0 22 3 / 3

Index Only Scan using ix_test on userstorepermission (cost=0.27..2.66 rows=22 width=16) (actual time=0.021..0.024 rows=22 loops=3)

  • Index Cond: (tenantuserid = 'e8dd09bb-cf41-4601-84de-78ff81618612'::uuid)
  • Heap Fetches: 0
  • Buffers: shared hit=11