explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EyRB

Settings
# exclusive inclusive rows x rows loops node
1. 0.035 8.797 ↑ 3.0 1 1

GroupAggregate (cost=0.00..719.16 rows=3 width=12) (actual time=8.797..8.797 rows=1 loops=1)

  • Group Key: user_id
2. 8.762 8.762 ↓ 1.1 20 1

Seq Scan on order_users (cost=0.00..718.86 rows=18 width=12) (actual time=8.481..8.762 rows=20 loops=1)

  • Filter: (user_id = 9,552,306)
  • Rows Removed by Filter: 34,490
Planning time : 0.142 ms
Execution time : 8.899 ms