explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HYZG

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

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

  • Buffers: shared hit=45401 read=36338
  • I/O Timings: read=179.658
2. 7.603 2,056.501 ↓ 1.5 3 1

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

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=45401 read=36338
  • I/O Timings: read=179.658
3. 320.821 2,048.898 ↑ 1.0 1 3 / 3

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

  • Buffers: shared hit=45401 read=36338
  • I/O Timings: read=179.658
4. 1,284.396 1,728.077 ↑ 1.3 1,497,914 3 / 3

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

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

  • Buffers: shared hit=45330 read=36338
  • I/O Timings: read=179.658
6. 0.008 0.033 ↑ 1.0 22 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=11
7. 0.025 0.025 ↑ 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.025 rows=22 loops=3)

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