explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JZON

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

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

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

Index Scan using aaa on exaasmouvementsaccountspivot (cost=0.42..47,949.27 rows=672,152 width=175) (actual time=0.022..295.401 rows=672,152 loops=1)