explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YiEC : Optimization for: plan #5782

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 139.374 140.565 ↑ 1.0 1 1

Aggregate (cost=2,838.34..2,838.39 rows=1 width=320) (actual time=140.564..140.565 rows=1 loops=1)

2. 0.232 1.191 ↓ 1.2 2,304 1

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

3. 0.959 0.959 ↓ 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.017..0.959 rows=2,304 loops=1)

  • Index Cond: ((patient_id = 4800) 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.214 ms