explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WkZg8

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

GroupAggregate (cost=0.42..1,418,263.31 rows=24,749 width=556) (actual time=117.019..10,454.843 rows=79,783 loops=1)

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

Index Scan using bbb on exaasmouvementsaccountspivot (cost=0.42..47,949.27 rows=672,152 width=175) (actual time=0.023..227.132 rows=672,152 loops=1)