explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GiN7

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 17.534 ↑ 1.0 10 1

Limit (cost=26.23..51.89 rows=10 width=112) (actual time=12.609..17.534 rows=10 loops=1)

2. 17.523 17.523 ↑ 4,173.1 20 1

Index Scan Backward using index_balance_operations_on_user_id_and_created_at on balance_operations (cost=0.57..214,194.53 rows=83,463 width=112) (actual time=6.338..17.523 rows=20 loops=1)

  • Index Cond: (user_id = 4,560,461)
Planning time : 8.136 ms
Execution time : 17.582 ms