explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yOs3

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

Sort (cost=262,591.110..262,591.160 rows=20 width=4) (actual rows= loops=)

  • Sort Key: india
2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=262,590.430..262,590.680 rows=20 width=4) (actual rows= loops=)

  • Group Key: india
3. 0.000 0.000 ↓ 0.0

Index Scan using uniform on two (cost=0.430..258,788.190 rows=760,448 width=4) (actual rows= loops=)

  • Index Cond: (lima <= 7596488)
  • Filter: ((echo >= 7595895) AND ((india - 44) > 0))