explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rg5v

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.13..39,990.68 rows=182 width=73) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.70..39,693.03 rows=182 width=25) (actual rows= loops=)

  • Join Filter: (SubPlan 1)
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.28..28,817.88 rows=363 width=33) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..26,138.85 rows=3,869 width=20) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using transaction_reversal_datetime_reversed on transaction_reversal (cost=0.42..838.45 rows=3,869 width=12) (actual rows= loops=)

  • Index Cond: ((datetime_reversed < '2019-06-14 00:00:00+00'::timestamp with time zone) AND (datetime_reversed > '2019-05-14 00:00:00+00'::timestamp with time zone))
6. 0.000 0.000 ↓ 0.0

Index Scan using uniq_4f2d75462fc0cb0f on subscription_transaction (cost=0.43..6.53 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (transaction_id = transaction_reversal.transaction_id)
7. 0.000 0.000 ↓ 0.0

Index Scan using transactions_pkey on transactions (cost=0.43..0.68 rows=1 width=25) (actual rows= loops=)

  • Index Cond: (id = subscription_transaction.transaction_id)
  • Filter: ((NOT successful) AND (status <> ALL ('{60,70}'::integer[])) AND ((method)::text = 'direct-debit'::text))
8. 0.000 0.000 ↓ 0.0

Index Scan using subscription_pkey on subscription (cost=0.42..0.49 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = subscription_transaction.subscription_id)
9.          

SubPlan (forNested Loop)

10. 0.000 0.000 ↓ 0.0

Index Scan using idx_42ab658da76ed395 on listing_reaction (cost=0.43..58.48 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (user_id = subscription.user_id)
  • Filter: ((datetime_created > transactions.datetime_created) AND (datetime_created < (transactions.datetime_created + '1 mon'::interval)))
11. 0.000 0.000 ↓ 0.0

Index Scan using users_pkey on users (cost=0.43..1.63 rows=1 width=56) (actual rows= loops=)