explain.depesz.com

PostgreSQL's explain analyze made readable

Result: o3EU4 : test

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=0.44..879.83 rows=500 width=1,871) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Index Scan using prediction_date_index on raw_data rd (cost=0.44..658,737.71 rows=374,543 width=1,871) (actual rows= loops=)

  • Index Cond: (prediction_date = '2020-05-30'::date)
  • Filter: ((task_id = 1,354) AND (version_id = 1))