explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nL3k

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

Finalize Aggregate (cost=87,579.68..87,579.69 rows=1 width=8) (actual time=1,412.742..1,412.742 rows=1 loops=1)

  • Buffers: shared hit=17386
2. 6.988 1,413.848 ↓ 1.5 3 1

Gather (cost=87,579.47..87,579.68 rows=2 width=8) (actual time=1,412.338..1,413.848 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=17386
3. 293.868 1,406.860 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=86,579.47..86,579.48 rows=1 width=8) (actual time=1,406.860..1,406.860 rows=1 loops=3)

  • Buffers: shared hit=17386
4. 698.352 1,112.992 ↑ 1.3 1,497,914 3 / 3

Hash Join (cost=3.36..81,746.30 rows=1,933,268 width=16) (actual time=0.718..1,112.992 rows=1,497,914 loops=3)

  • Hash Cond: (sit.storeid = userstorepermission.storeid)
  • Buffers: shared hit=17386
5. 414.608 414.608 ↑ 1.2 1,497,914 3 / 3

Parallel Index Only Scan using ix_stockitemtransaction_storeid on stockitemtransaction sit (cost=0.43..75,850.97 rows=1,872,297 width=16) (actual time=0.628..414.608 rows=1,497,914 loops=3)

  • Heap Fetches: 0
  • Buffers: shared hit=17315
6. 0.010 0.032 ↑ 1.0 22 3 / 3

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

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

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