explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zRF

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

HashAggregate (cost=290.64..342.21 rows=5,157 width=13) (actual rows= loops=)

  • Group Key: nom
2. 0.000 0.000 ↓ 0.0

Index Only Scan using employes_big_nom_idx1 on employes_big (cost=0.56..277.13 rows=5,402 width=13) (actual rows= loops=)

  • Index Cond: ((nom ~>=~ 'MN'::text) AND (nom ~<~ 'MO'::text))
  • Filter: (nom ~~ 'MN%'::text)