explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8XWz

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 210.528 213.943 ↑ 1.0 1 1

Aggregate (cost=3,193.78..3,193.84 rows=1 width=320) (actual time=213.943..213.943 rows=1 loops=1)

2. 0.304 3.415 ↓ 1.1 2,592 1

Append (cost=0.56..2,396.43 rows=2,278 width=402) (actual time=0.014..3.415 rows=2,592 loops=1)

3. 3.111 3.111 ↓ 1.1 2,592 1

Index Scan using pk_pts_vent2_2019_jan_01_10 on patient_therapy_statistics_vent_2019_jan_01_10 (cost=0.56..2,396.43 rows=2,278 width=402) (actual time=0.014..3.111 rows=2,592 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-10 00:00:00'::timestamp without time zone))
  • Filter: (end_time <= '2019-01-10 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 1
Planning time : 1.333 ms