explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HSW0

Settings
# exclusive inclusive rows x rows loops node
1. 0.103 0.682 ↓ 975.0 975 1

Nested Loop (cost=4.97..75.49 rows=1 width=92) (actual time=0.166..0.682 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..8.44 rows=1 width=5) (actual time=0.007..0.007 rows=1 loops=1)

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

Bitmap Heap Scan on rappi_credit_transactions (cost=4.55..67.05 rows=1 width=59) (actual time=0.158..0.572 rows=975 loops=1)

  • Recheck Cond: (rappi_credit_id = rappi_credits.id)
  • Filter: (((starts_at IS NULL) OR (starts_at < '2019-06-06 11:36:29.362631'::timestamp without time zone)) AND ((ends_at IS NULL) OR (ends_at > '2019-06-06 11:36:29.362631'::timestamp without time zone)) AND ((state)::text = 'paid'::text))
  • Rows Removed by Filter: 650
  • Heap Blocks: exact=89
4. 0.102 0.102 ↓ 101.6 1,625 1

Bitmap Index Scan on rappi_credit_transactions_rappi_credit_id_index (cost=0.00..4.54 rows=16 width=0) (actual time=0.102..0.102 rows=1,625 loops=1)

  • Index Cond: (rappi_credit_id = rappi_credits.id)
Planning time : 0.217 ms
Execution time : 0.768 ms