explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lA4 : Optimization for: plan #ereO

Settings

Optimization path:

Optimization(s) for this plan:

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

Finalize Aggregate (cost=58,837.60..58,837.65 rows=1 width=320) (actual time=2,045.151..2,045.151 rows=1 loops=1)

2. 6.286 2,046.521 ↓ 2.0 2 1

Gather (cost=58,837.34..58,837.45 rows=1 width=608) (actual time=2,044.536..2,046.521 rows=2 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 2,005.260 2,040.235 ↑ 1.0 1 2

Partial Aggregate (cost=57,837.34..57,837.35 rows=1 width=608) (actual time=2,040.235..2,040.235 rows=1 loops=2)

4. 3.276 34.975 ↑ 1.1 25,920 2

Append (cost=0.43..47,517.90 rows=29,484 width=402) (actual time=0.014..34.975 rows=25,920 loops=2)

5. 1.708 1.708 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_vent_2019010110_p12500 on patient_therapy_statistics_vent_2019010110_p12500 (cost=0.43..2,641.12 rows=1,647 width=402) (actual time=0.014..1.708 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 900) 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.625 1.625 ↑ 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.012..1.625 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 900) 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.734 1.734 ↑ 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.013..1.734 rows=1,584 loops=2)

  • Index Cond: ((patient_id = 900) 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.541 1.541 ↑ 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.011..1.541 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 900) 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. 1.550 1.550 ↑ 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.011..1.550 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 900) 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.229 1.229 ↑ 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.014..1.229 rows=1,152 loops=2)

  • Index Cond: ((patient_id = 900) 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.548 1.548 ↑ 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.012..1.548 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 900) 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.564 1.564 ↑ 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.011..1.564 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 900) 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.707 1.707 ↑ 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.015..1.707 rows=1,584 loops=2)

  • Index Cond: ((patient_id = 900) 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.572 1.572 ↑ 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.010..1.572 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 900) 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. 3.513 3.513 ↑ 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.013..3.513 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 900) 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.576 1.576 ↑ 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.019..1.576 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 900) 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.575 1.575 ↑ 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.012..1.575 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 900) 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.570 1.570 ↑ 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.012..1.570 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 900) 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. 2.938 2.938 ↑ 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.014..2.938 rows=1,584 loops=2)

  • Index Cond: ((patient_id = 900) 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. 1.614 1.614 ↑ 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.013..1.614 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 900) 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. 1.619 1.619 ↑ 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.014..1.619 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 900) 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.516 1.516 ↑ 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.011..1.516 rows=1,296 loops=2)

  • Index Cond: ((patient_id = 900) 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