explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TVTQ

Settings
# exclusive inclusive rows x rows loops node
1. 13.018 349.405 ↓ 1.5 13,876 1

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

  • Hash Cond: (statement.member_uuid = card.member_uuid)
2. 25.187 106.731 ↓ 1.0 47,073 1

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

  • Recheck Cond: (statement_date >= '2019-10-01'::date)
  • Filter: valid
  • Heap Blocks: exact=981
3. 81.544 81.544 ↓ 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=81.544..81.544 rows=47,073 loops=1)

  • Index Cond: (statement_date >= '2019-10-01'::date)
4. 3.732 229.656 ↓ 1.5 14,934 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 829kB
5. 14.272 225.924 ↓ 1.5 14,934 1

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

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

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

  • Filter: is_current
  • Rows Removed by Filter: 5406
7. 3.168 175.690 ↓ 1.0 14,935 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 654kB
8. 166.655 172.522 ↓ 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=5.977..172.522 rows=14,935 loops=1)

  • Recheck Cond: enabled
  • Heap Blocks: exact=844
9. 5.867 5.867 ↓ 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=5.867..5.867 rows=21,849 loops=1)

Planning time : 4.806 ms
Execution time : 350.155 ms