explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ereO

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 2,064.102 ↑ 1.0 1 1

Finalize Aggregate (cost=60,851.27..60,851.32 rows=1 width=320) (actual time=2,064.102..2,064.102 rows=1 loops=1)

2. 8.223 2,065.832 ↓ 2.0 2 1

Gather (cost=60,851.01..60,851.12 rows=1 width=608) (actual time=2,061.995..2,065.832 rows=2 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 2,020.441 2,057.609 ↑ 1.0 1 2

Partial Aggregate (cost=59,851.01..59,851.02 rows=1 width=608) (actual time=2,057.609..2,057.609 rows=1 loops=2)

4. 2.950 37.168 ↑ 1.2 25,920 2

Append (cost=0.43..49,169.32 rows=30,519 width=402) (actual time=0.017..37.168 rows=25,920 loops=2)

5. 1.795 1.795 ↑ 1.9 1,440 2

Parallel Index Scan using pk_pts_vent_2019010110_p12500 on patient_therapy_statistics_vent_2019010110_p12500 (cost=0.43..4,292.54 rows=2,682 width=402) (actual time=0.017..1.795 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 800) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-06-30 00:00:00'::timestamp without time zone))
  • Filter: (end_time <= '2019-06-30 00:00:00'::timestamp without time zone)
6. 1.773 1.773 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_vent_2019011120_p12500 on patient_therapy_statistics_vent_2019011120_p12500 (cost=0.43..2,639.42 rows=1,646 width=402) (actual time=0.017..1.773 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 800) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-06-30 00:00:00'::timestamp without time zone))
  • Filter: (end_time <= '2019-06-30 00:00:00'::timestamp without time zone)
7. 1.927 1.927 ↑ 1.1 1,584 2

Parallel Index Scan using pk_pts_vent_2019012131_p12500 on patient_therapy_statistics_vent_2019012131_p12500 (cost=0.43..2,903.48 rows=1,811 width=402) (actual time=0.017..1.927 rows=1,584 loops=2)

  • Index Cond: ((patient_id = 800) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-06-30 00:00:00'::timestamp without time zone))
  • Filter: (end_time <= '2019-06-30 00:00:00'::timestamp without time zone)
8. 1.800 1.800 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_vent_2019020110_p12500 on patient_therapy_statistics_vent_2019020110_p12500 (cost=0.43..2,642.96 rows=1,648 width=402) (actual time=0.015..1.800 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 800) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-06-30 00:00:00'::timestamp without time zone))
  • Filter: (end_time <= '2019-06-30 00:00:00'::timestamp without time zone)
9. 2.885 2.885 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_vent_2019021120_p12500 on patient_therapy_statistics_vent_2019021120_p12500 (cost=0.43..2,641.27 rows=1,646 width=402) (actual time=0.013..2.885 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 800) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-06-30 00:00:00'::timestamp without time zone))
  • Filter: (end_time <= '2019-06-30 00:00:00'::timestamp without time zone)
10. 1.407 1.407 ↑ 1.1 1,152 2

Parallel Index Scan using pk_pts_vent_2019022131_p12500 on patient_therapy_statistics_vent_2019022131_p12500 (cost=0.43..2,115.08 rows=1,318 width=402) (actual time=0.022..1.407 rows=1,152 loops=2)

  • Index Cond: ((patient_id = 800) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-06-30 00:00:00'::timestamp without time zone))
  • Filter: (end_time <= '2019-06-30 00:00:00'::timestamp without time zone)
11. 1.727 1.727 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_vent_2019030110_p12500 on patient_therapy_statistics_vent_2019030110_p12500 (cost=0.43..2,637.67 rows=1,645 width=402) (actual time=0.015..1.727 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 800) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-06-30 00:00:00'::timestamp without time zone))
  • Filter: (end_time <= '2019-06-30 00:00:00'::timestamp without time zone)
12. 1.759 1.759 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_vent_2019031120_p12500 on patient_therapy_statistics_vent_2019031120_p12500 (cost=0.43..2,637.67 rows=1,645 width=402) (actual time=0.014..1.759 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 800) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-06-30 00:00:00'::timestamp without time zone))
  • Filter: (end_time <= '2019-06-30 00:00:00'::timestamp without time zone)
13. 1.969 1.969 ↑ 1.1 1,584 2

Parallel Index Scan using pk_pts_vent_2019032131_p12500 on patient_therapy_statistics_vent_2019032131_p12500 (cost=0.43..2,904.60 rows=1,811 width=402) (actual time=0.014..1.969 rows=1,584 loops=2)

  • Index Cond: ((patient_id = 800) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-06-30 00:00:00'::timestamp without time zone))
  • Filter: (end_time <= '2019-06-30 00:00:00'::timestamp without time zone)
14. 1.750 1.750 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_vent_2019040110_p12500 on patient_therapy_statistics_vent_2019040110_p12500 (cost=0.43..2,638.45 rows=1,645 width=402) (actual time=0.019..1.750 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 800) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-06-30 00:00:00'::timestamp without time zone))
  • Filter: (end_time <= '2019-06-30 00:00:00'::timestamp without time zone)
15. 1.651 1.651 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_vent_2019041120_p12500 on patient_therapy_statistics_vent_2019041120_p12500 (cost=0.43..2,637.67 rows=1,645 width=402) (actual time=0.016..1.651 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 800) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-06-30 00:00:00'::timestamp without time zone))
  • Filter: (end_time <= '2019-06-30 00:00:00'::timestamp without time zone)
16. 1.758 1.758 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_vent_2019042131_p12500 on patient_therapy_statistics_vent_2019042131_p12500 (cost=0.43..2,637.67 rows=1,645 width=402) (actual time=0.016..1.758 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 800) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-06-30 00:00:00'::timestamp without time zone))
  • Filter: (end_time <= '2019-06-30 00:00:00'::timestamp without time zone)
17. 1.727 1.727 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_vent_2019050110_p12500 on patient_therapy_statistics_vent_2019050110_p12500 (cost=0.43..2,637.67 rows=1,645 width=402) (actual time=0.020..1.727 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 800) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-06-30 00:00:00'::timestamp without time zone))
  • Filter: (end_time <= '2019-06-30 00:00:00'::timestamp without time zone)
18. 1.744 1.744 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_vent_2019051120_p12500 on patient_therapy_statistics_vent_2019051120_p12500 (cost=0.43..2,637.67 rows=1,645 width=402) (actual time=0.015..1.744 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 800) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-06-30 00:00:00'::timestamp without time zone))
  • Filter: (end_time <= '2019-06-30 00:00:00'::timestamp without time zone)
19. 1.935 1.935 ↑ 1.1 1,584 2

Parallel Index Scan using pk_pts_vent_2019052131_p12500 on patient_therapy_statistics_vent_2019052131_p12500 (cost=0.43..2,904.60 rows=1,811 width=402) (actual time=0.016..1.935 rows=1,584 loops=2)

  • Index Cond: ((patient_id = 800) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-06-30 00:00:00'::timestamp without time zone))
  • Filter: (end_time <= '2019-06-30 00:00:00'::timestamp without time zone)
20. 2.505 2.505 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_vent_2019060110_p12500 on patient_therapy_statistics_vent_2019060110_p12500 (cost=0.43..2,637.67 rows=1,645 width=402) (actual time=0.016..2.505 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 800) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-06-30 00:00:00'::timestamp without time zone))
  • Filter: (end_time <= '2019-06-30 00:00:00'::timestamp without time zone)
21. 2.521 2.521 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_vent_2019061120_p12500 on patient_therapy_statistics_vent_2019061120_p12500 (cost=0.43..2,642.07 rows=1,648 width=402) (actual time=0.016..2.521 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 800) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-06-30 00:00:00'::timestamp without time zone))
  • Filter: (end_time <= '2019-06-30 00:00:00'::timestamp without time zone)
22. 1.585 1.585 ↑ 1.0 1,296 2

Parallel Index Scan using pk_pts_vent_2019062131_p12500 on patient_therapy_statistics_vent_2019062131_p12500 (cost=0.43..2,381.18 rows=1,338 width=402) (actual time=0.015..1.585 rows=1,296 loops=2)

  • Index Cond: ((patient_id = 800) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-06-30 00:00:00'::timestamp without time zone))
  • Filter: (end_time <= '2019-06-30 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 0