explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JJsc

Settings
# exclusive inclusive rows x rows loops node
1. 10,459.248 10,666.885 ↓ 3.2 79,783 1

GroupAggregate (cost=0.42..1,400,701.75 rows=24,749 width=556) (actual time=117.897..10,666.885 rows=79,783 loops=1)

  • Group Key: line_number
2. 207.637 207.637 ↑ 1.0 672,152 1

Index Scan using aaaff on exaasmouvementsaccountspivot (cost=0.42..30,387.71 rows=672,152 width=175) (actual time=0.030..207.637 rows=672,152 loops=1)