explain.depesz.com

PostgreSQL's explain analyze made readable

Result: A6Cl

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.221 ↑ 1.0 15 1

Limit (cost=0.56..227,274.34 rows=15 width=100) (actual time=0.069..0.221 rows=15 loops=1)

2. 0.067 0.218 ↑ 13.3 15 1

GroupAggregate (cost=0.56..3,030,317.60 rows=200 width=100) (actual time=0.069..0.218 rows=15 loops=1)

  • Group Key: mouvementswithpool.ecritures_id
3. 0.081 0.151 ↑ 71,792.1 38 1

GroupAggregate (cost=0.56..2,955,291.40 rows=2,728,098 width=44) (actual time=0.039..0.151 rows=38 loops=1)

  • Group Key: mouvementswithpool.ecritures_id, mouvementswithpool.pool_name
4. 0.070 0.070 ↑ 470,361.7 58 1

Index Scan using text_index2 on mouvementswithpool (cost=0.56..2,716,582.83 rows=27,280,980 width=18) (actual time=0.029..0.070 rows=58 loops=1)

Planning time : 0.213 ms