explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sFOn

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

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

  • Buffers: shared hit=45785 read=35954
  • I/O Timings: read=141.275
2. 7.607 1,825.426 ↓ 1.5 3 1

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

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=45785 read=35954
  • I/O Timings: read=141.275
3. 320.118 1,817.819 ↑ 1.0 1 3 / 3

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

  • Buffers: shared hit=45785 read=35954
  • I/O Timings: read=141.275
4. 1,077.428 1,497.701 ↑ 1.3 1,497,914 3 / 3

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

  • Hash Cond: (sit.storeid = userstorepermission.storeid)
  • Buffers: shared hit=45785 read=35954
  • I/O Timings: read=141.275
5. 420.241 420.241 ↑ 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.008..420.241 rows=1,497,914 loops=3)

  • Buffers: shared hit=45714 read=35954
  • I/O Timings: read=141.275
6. 0.008 0.032 ↑ 1.0 22 3 / 3

Hash (cost=2.66..2.66 rows=22 width=16) (actual time=0.032..0.032 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.020..0.024 rows=22 loops=3)

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