explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dmtL

Settings
# exclusive inclusive rows x rows loops node
1. 251.895 454.847 ↓ 1.3 25 1

Hash Right Join (cost=6,555.62..33,676.69 rows=19 width=11) (actual time=298.704..454.847 rows=25 loops=1)

  • Hash Cond: (fins.overall_payout_id = vp_payout_overall_payouts.id)
2. 202.179 202.179 ↓ 1.0 809,254 1

Seq Scan on vendor_payout_payout_finance_versions fins (cost=0.00..24,088.52 rows=808,652 width=7) (actual time=0.005..202.179 rows=809,254 loops=1)

3. 0.023 0.773 ↓ 1.3 25 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
4. 0.750 0.750 ↓ 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,555.38 rows=19 width=12) (actual time=0.026..0.750 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