explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nijx

Settings
# exclusive inclusive rows x rows loops node
1. 0.203 0.693 ↓ 2.0 2 1

Nested Loop (cost=1.14..77.18 rows=1 width=60) (actual time=0.472..0.693 rows=2 loops=1)

2. 0.091 0.490 ↓ 261.7 785 1

Nested Loop (cost=0.84..76.15 rows=3 width=60) (actual time=0.017..0.490 rows=785 loops=1)

3. 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)
4. 0.392 0.392 ↓ 98.1 785 1

Index Scan using rappi_credit_transactions_rappi_credit_id_index on rappi_credit_transactions (cost=0.42..67.63 rows=8 width=59) (actual time=0.009..0.392 rows=785 loops=1)

  • Index Cond: (rappi_credit_id = rappi_credits.id)
  • Filter: ((starts_at < '2019-06-06 10:28:52.838087'::timestamp without time zone) AND ((state)::text = 'paid'::text))
  • Rows Removed by Filter: 840
5. 0.000 0.000 ↓ 0.0 0 785

Index Scan using rappi_credit_restrictions_pkey on rappi_credit_restrictions (cost=0.29..0.33 rows=1 width=12) (actual time=0.000..0.000 rows=0 loops=785)

  • Index Cond: (id = rappi_credit_transactions.rappi_credit_restriction_id)
  • Filter: ((starts_at < '2019-06-06 10:28:52.838087'::timestamp without time zone) AND (ends_at > '2019-06-06 10:28:52.838087'::timestamp without time zone) AND (COALESCE(rappi_credit_transactions.ends_at, ends_at) > '2019-06-06 10:28:52.838087'::timestamp without time zone))
  • Rows Removed by Filter: 0
Planning time : 0.369 ms
Execution time : 0.745 ms