explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bN5h

Settings
# exclusive inclusive rows x rows loops node
1. 10,574.877 10,840.664 ↓ 3.3 79,783 1

GroupAggregate (cost=0.42..1,418,255.25 rows=24,501 width=556) (actual time=129.040..10,840.664 rows=79,783 loops=1)

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

Index Scan using xsmvmntsccntspvt_ln_nmbrmnmnt_ndx on exaasmouvementsaccountspivot (cost=0.42..47,949.27 rows=672,152 width=175) (actual time=0.020..265.787 rows=672,152 loops=1)