explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xrc9

Settings
# exclusive inclusive rows x rows loops node
1. 9.393 417.958 ↓ 23.0 23 1

Nested Loop (cost=2,451.74..5,862.68 rows=1 width=327) (actual time=19.858..417.958 rows=23 loops=1)

2. 6.563 342.285 ↓ 33,140.0 33,140 1

Nested Loop (cost=2,451.44..5,862.28 rows=1 width=285) (actual time=18.904..342.285 rows=33,140 loops=1)

3. 29.766 65.858 ↓ 38,552.0 38,552 1

Hash Left Join (cost=2,451.02..5,861.12 rows=1 width=160) (actual time=18.882..65.858 rows=38,552 loops=1)

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

Seq Scan on card (cost=0.00..1,571.39 rows=52,213 width=83) (actual time=0.009..17.255 rows=52,565 loops=1)

  • Filter: is_current
  • Rows Removed by Filter: 5438
5. 5.816 18.837 ↓ 1.1 27,500 1

Hash (cost=2,125.82..2,125.82 rows=26,016 width=77) (actual time=18.837..18.837 rows=27,500 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 3329kB
6. 13.021 13.021 ↓ 1.1 27,500 1

Seq Scan on auto_pay_logs (cost=0.00..2,125.82 rows=26,016 width=77) (actual time=7.097..13.021 rows=27,500 loops=1)

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

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,552)

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

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,140)

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