explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5F9s

Settings
# exclusive inclusive rows x rows loops node
1. 0.121 0.716 ↓ 975.0 975 1

Nested Loop (cost=0.84..21.99 rows=1 width=92) (actual time=0.019..0.716 rows=975 loops=1)

2. 0.007 0.007 ↑ 1.0 1 1

Index Scan using rappi_credits_application_user_id_index on rappi_credits (cost=0.42..2.64 rows=1 width=5) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (application_user_id = 131459676)
3. 0.588 0.588 ↓ 975.0 975 1

Index Scan using rappi_credit_transactions_rappi_credit_id_index on rappi_credit_transactions (cost=0.42..19.34 rows=1 width=59) (actual time=0.010..0.588 rows=975 loops=1)

  • Index Cond: (rappi_credit_id = rappi_credits.id)
  • Filter: (((state)::text = 'paid'::text) AND ((starts_at IS NULL) OR (starts_at < now())) AND ((ends_at IS NULL) OR (ends_at > now())))
  • Rows Removed by Filter: 650
Planning time : 0.223 ms
Execution time : 0.790 ms