explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KMjk

Settings
# exclusive inclusive rows x rows loops node
1. 7.527 287.000 ↓ 1.5 13,876 1

HashAggregate (cost=12,691.23..12,781.55 rows=9,032 width=16) (actual time=284.485..287.000 rows=13,876 loops=1)

  • Group Key: statement.member_uuid
2. 12.734 279.473 ↓ 1.5 13,876 1

Hash Join (cost=5,146.02..12,668.65 rows=9,032 width=16) (actual time=211.800..279.473 rows=13,876 loops=1)

  • Hash Cond: (statement.member_uuid = card.member_uuid)
3. 55.139 169.293 ↓ 1.0 47,073 1

Bitmap Heap Scan on statement (cost=1,571.44..8,540.50 rows=46,325 width=16) (actual time=114.319..169.293 rows=47,073 loops=1)

  • Recheck Cond: (statement_date >= '2019-10-01'::date)
  • Filter: valid
  • Heap Blocks: exact=981
4. 114.154 114.154 ↓ 1.0 47,073 1

Bitmap Index Scan on ix_statement_statement_date (cost=0.00..1,559.86 rows=46,325 width=0) (actual time=114.154..114.154 rows=47,073 loops=1)

  • Index Cond: (statement_date >= '2019-10-01'::date)
5. 3.749 97.446 ↓ 1.5 14,934 1

Hash (cost=3,453.10..3,453.10 rows=9,718 width=16) (actual time=97.446..97.446 rows=14,934 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 829kB
6. 14.334 93.697 ↓ 1.5 14,934 1

Hash Join (cost=1,588.73..3,453.10 rows=9,718 width=16) (actual time=18.574..93.697 rows=14,934 loops=1)

  • Hash Cond: (card.auto_pay_setting_id = auto_pay_settings.id)
7. 61.476 61.476 ↓ 1.0 52,471 1

Seq Scan on card (cost=0.00..1,571.39 rows=52,213 width=20) (actual time=0.648..61.476 rows=52,471 loops=1)

  • Filter: is_current
  • Rows Removed by Filter: 5406
8. 3.100 17.887 ↓ 1.0 14,935 1

Hash (cost=1,402.95..1,402.95 rows=14,863 width=4) (actual time=17.887..17.887 rows=14,935 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 654kB
9. 7.546 14.787 ↓ 1.0 14,935 1

Bitmap Heap Scan on auto_pay_settings (cost=410.32..1,402.95 rows=14,863 width=4) (actual time=7.356..14.787 rows=14,935 loops=1)

  • Recheck Cond: enabled
  • Heap Blocks: exact=844
10. 7.241 7.241 ↓ 1.5 21,849 1

Bitmap Index Scan on only_one_current_aps_record (cost=0.00..406.60 rows=14,863 width=0) (actual time=7.241..7.241 rows=21,849 loops=1)

Planning time : 0.843 ms
Execution time : 287.709 ms