explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Tmao

Settings
# exclusive inclusive rows x rows loops node
1. 27.457 38.911 ↑ 1.0 1 1

Aggregate (cost=2,435.90..2,435.91 rows=1 width=32) (actual time=38.911..38.911 rows=1 loops=1)

2. 0.200 11.454 ↓ 1,296.0 2,592 1

Append (cost=0.56..2,435.82 rows=2 width=522) (actual time=0.025..11.454 rows=2,592 loops=1)

3. 11.254 11.254 ↓ 1,296.0 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,435.82 rows=2 width=522) (actual time=0.024..11.254 rows=2,592 loops=1)

  • Index Cond: ((patient_id = 500) 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) AND ((channel_stats #> '{tidVolExhaled}'::text[]) @> '{"stat_name": "tidVolExhaled"}'::jsonb))
  • Rows Removed by Filter: 1