explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JFwK4

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.081 0.587 ↓ 1.3 18 1

GroupAggregate (cost=521.98..523.31 rows=14 width=227) (actual time=0.535..0.587 rows=18 loops=1)

  • Group Key: tenant_id, direction, assets
2. 0.037 0.506 ↑ 1.0 27 1

Sort (cost=521.98..522.05 rows=27 width=140) (actual time=0.504..0.506 rows=27 loops=1)

  • Sort Key: direction, assets
  • Sort Method: quicksort Memory: 32kB
3. 0.469 0.469 ↑ 1.0 27 1

Seq Scan on access (cost=0.00..521.34 rows=27 width=140) (actual time=0.008..0.469 rows=27 loops=1)

  • Filter: (tenant_id = '7b26e0d9-d493-30c1-ac75-38d68d70538d'::uuid)
Planning time : 0.114 ms
Execution time : 0.626 ms