explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5DLv : test1

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.190 485.465 ↑ 1.0 500 1

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

2. 485.275 485.275 ↑ 749.1 500 1

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

  • Index Cond: (prediction_date = '2020-05-30'::date)
  • Filter: ((task_id = 1,354) AND (version_id = 1))
Planning time : 0.118 ms
Execution time : 485.573 ms