explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R2Ta

Settings
# exclusive inclusive rows x rows loops node
1. 23.946 489.052 ↓ 23.0 23 1

Nested Loop (cost=2,451.74..5,862.68 rows=1 width=250) (actual time=54.590..489.052 rows=23 loops=1)

2. 15.489 398.852 ↓ 33,127.0 33,127 1

Nested Loop (cost=2,451.44..5,862.28 rows=1 width=208) (actual time=53.305..398.852 rows=33,127 loops=1)

3. 30.040 112.673 ↓ 38,670.0 38,670 1

Hash Left Join (cost=2,451.02..5,861.12 rows=1 width=83) (actual time=53.275..112.673 rows=38,670 loops=1)

  • Hash Cond: (card.member_uuid = auto_pay_logs.member_uuid)
  • Filter: (auto_pay_logs.id IS NULL)
  • Rows Removed by Filter: 27537
4. 29.446 29.446 ↓ 1.0 52,703 1

Seq Scan on card (cost=0.00..1,571.39 rows=52,213 width=83) (actual time=0.021..29.446 rows=52,703 loops=1)

  • Filter: is_current
  • Rows Removed by Filter: 5482
5. 8.094 53.187 ↓ 1.1 27,537 1

Hash (cost=2,125.82..2,125.82 rows=26,016 width=24) (actual time=53.187..53.187 rows=27,537 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1762kB
6. 45.093 45.093 ↓ 1.1 27,537 1

Seq Scan on auto_pay_logs (cost=0.00..2,125.82 rows=26,016 width=24) (actual time=28.417..45.093 rows=27,537 loops=1)

  • Filter: (payment_date = '2019-10-26 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 53132
7. 270.690 270.690 ↑ 1.0 1 38,670

Index Scan using ix_statement_member_uuid on statement (cost=0.42..1.15 rows=1 width=125) (actual time=0.004..0.007 rows=1 loops=38,670)

  • Index Cond: (member_uuid = card.member_uuid)
  • Filter: (valid AND (statement_date >= '2019-10-01'::date))
  • Rows Removed by Filter: 3
8. 66.254 66.254 ↓ 0.0 0 33,127

Index Scan using auto_pay_settings_pkey on auto_pay_settings (cost=0.29..0.39 rows=1 width=42) (actual time=0.002..0.002 rows=0 loops=33,127)

  • Index Cond: (id = card.auto_pay_setting_id)
  • Filter: enabled
  • Rows Removed by Filter: 1
Planning time : 9.658 ms
Execution time : 489.154 ms