explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sB5Y

Settings
# exclusive inclusive rows x rows loops node
1. 0.023 459.859 ↑ 1.0 1 1

Aggregate (cost=217.77..217.78 rows=1 width=32) (actual time=459.859..459.859 rows=1 loops=1)

2. 459.836 459.836 ↓ 3.5 39 1

Index Scan using index_balance_operations_on_user_id on balance_operations (cost=0.57..217.74 rows=11 width=5) (actual time=5.275..459.836 rows=39 loops=1)

  • Index Cond: (user_id = 5861115)
  • Filter: ((updated_at >= '2020-01-07 14:45:16.111774'::timestamp without time zone) AND (operation_type = ANY ('{0,1,3,4,5,6,8,10}'::integer[])))
  • Rows Removed by Filter: 1184
Planning time : 0.115 ms
Execution time : 459.888 ms