explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HLe5

Settings
# exclusive inclusive rows x rows loops node
1. 246.638 757.684 ↓ 1.3 25 1

Hash Right Join (cost=6,548.73..33,549.47 rows=19 width=11) (actual time=501.406..757.684 rows=25 loops=1)

  • Hash Cond: (fins.overall_payout_id = vp_payout_overall_payouts.id)
2. 448.981 448.981 ↓ 1.0 806,967 1

Seq Scan on vendor_payout_payout_finance_versions fins (cost=0.00..23,981.64 rows=805,064 width=7) (actual time=1.118..448.981 rows=806,967 loops=1)

3. 0.029 62.065 ↓ 1.3 25 1

Hash (cost=6,548.49..6,548.49 rows=19 width=12) (actual time=62.065..62.065 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
4. 62.036 62.036 ↓ 1.3 25 1

Index Scan using index_vp_payout_overall_payouts_on_driver_id_and_start_date_v2 on vp_payout_overall_payouts (cost=0.44..6,548.49 rows=19 width=12) (actual time=1.931..62.036 rows=25 loops=1)

  • Index Cond: (driver_id = 17776)
  • Filter: ((end_date <= '2019-01-03'::date) AND (engagement_type = 3) AND (duration_type = 1) AND (status = ANY ('{2,3,4}'::integer[])))
  • Rows Removed by Filter: 789