explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5782

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 133.892 135.025 ↑ 1.0 1 1

Aggregate (cost=2,814.96..2,815.01 rows=1 width=288) (actual time=135.025..135.025 rows=1 loops=1)

2. 0.227 1.133 ↓ 1.2 2,304 1

Append (cost=0.56..2,183.79 rows=1,870 width=335) (actual time=0.013..1.133 rows=2,304 loops=1)

3. 0.906 0.906 ↓ 1.2 2,304 1

Index Scan using pk_pts_2019_jan_01_10 on patient_therapy_statistics_2019_jan_01_10 (cost=0.56..2,183.79 rows=1,870 width=335) (actual time=0.013..0.906 rows=2,304 loops=1)

  • Index Cond: ((patient_id = 1450) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-01-09 00:00:00'::timestamp without time zone))
  • Filter: (end_time <= '2019-01-09 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 1
Planning time : 1.419 ms