explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uCYW

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.015 21.047 ↑ 1.0 1 1

Aggregate (cost=68.87..68.88 rows=1 width=8) (actual time=21.047..21.047 rows=1 loops=1)

2. 21.032 21.032 ↑ 2.0 1 1

Index Scan using index_payments_on_user_id on payments (cost=0.43..68.86 rows=2 width=0) (actual time=16.221..21.032 rows=1 loops=1)

  • Index Cond: (user_id = 8232)
  • Filter: ((total_amount_in_inr > 0) AND ((origin_type)::text <> 'Basket'::text) AND (total_amount_in_inr > 0) AND ((contribution_type)::text = 'loan'::text))