explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lize

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,667.715 ↑ 1.0 1 1

Finalize Aggregate (cost=68,248.50..68,248.56 rows=1 width=320) (actual time=1,667.715..1,667.715 rows=1 loops=1)

2. 6.189 1,669.095 ↓ 2.0 2 1

Gather (cost=68,248.25..68,248.36 rows=1 width=608) (actual time=1,667.331..1,669.095 rows=2 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 1,644.763 1,662.906 ↑ 1.0 1 2

Partial Aggregate (cost=67,248.25..67,248.26 rows=1 width=608) (actual time=1,662.906..1,662.906 rows=1 loops=2)

4. 2.731 18.143 ↑ 1.3 25,920 2

Append (cost=0.56..55,160.60 rows=34,536 width=365) (actual time=0.017..18.143 rows=25,920 loops=2)

5. 0.615 0.615 ↑ 1.2 1,440 2

Parallel Index Scan using pk_pts_2019_jan_01_10 on patient_therapy_statistics_2019_jan_01_10 (cost=0.56..2,708.67 rows=1,712 width=335) (actual time=0.017..0.615 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 1400) 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. 0.584 0.584 ↑ 1.2 1,440 2

Parallel Index Scan using pk_pts_2019_jan_11_20 on patient_therapy_statistics_2019_jan_11_20 (cost=0.56..2,710.49 rows=1,707 width=367) (actual time=0.014..0.584 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 1400) 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. 0.680 0.680 ↑ 1.2 1,584 2

Parallel Index Scan using pk_pts_2019_jan_21_31 on patient_therapy_statistics_2019_jan_21_31 (cost=0.56..2,981.91 rows=1,879 width=366) (actual time=0.010..0.680 rows=1,584 loops=2)

  • Index Cond: ((patient_id = 1400) 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. 0.591 0.591 ↑ 1.2 1,440 2

Parallel Index Scan using pk_pts_2019_feb_01_10 on patient_therapy_statistics_2019_feb_01_10 (cost=0.56..2,722.70 rows=1,706 width=367) (actual time=0.012..0.591 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 1400) 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. 0.604 0.604 ↑ 1.2 1,440 2

Parallel Index Scan using pk_pts_2019_feb_11_20 on patient_therapy_statistics_2019_feb_11_20 (cost=0.56..2,698.29 rows=1,699 width=367) (actual time=0.014..0.604 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 1400) 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.212 1.212 ↑ 1.2 1,152 2

Parallel Index Scan using pk_pts_2019_feb_21_31 on patient_therapy_statistics_2019_feb_21_31 (cost=0.56..2,166.01 rows=1,365 width=367) (actual time=0.014..1.212 rows=1,152 loops=2)

  • Index Cond: ((patient_id = 1400) 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.154 1.154 ↑ 1.2 1,440 2

Parallel Index Scan using pk_pts_2019_march_01_10 on patient_therapy_statistics_2019_march_01_10 (cost=0.56..2,718.49 rows=1,706 width=367) (actual time=0.015..1.154 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 1400) 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. 0.620 0.620 ↑ 4.1 1,440 2

Parallel Index Scan using pk_pts_2019_march_11_20 on patient_therapy_statistics_2019_march_11_20 (cost=0.56..9,374.87 rows=5,929 width=367) (actual time=0.013..0.620 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 1400) 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. 0.667 0.667 ↑ 1.2 1,584 2

Parallel Index Scan using pk_pts_2019_march_21_31 on patient_therapy_statistics_2019_march_21_31 (cost=0.56..2,977.44 rows=1,876 width=367) (actual time=0.011..0.667 rows=1,584 loops=2)

  • Index Cond: ((patient_id = 1400) 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. 0.617 0.617 ↑ 1.2 1,440 2

Parallel Index Scan using pk_pts_2019_april_01_10 on patient_therapy_statistics_2019_april_01_10 (cost=0.56..2,725.65 rows=1,712 width=367) (actual time=0.014..0.617 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 1400) 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. 0.634 0.634 ↑ 1.2 1,440 2

Parallel Index Scan using pk_pts_2019_april_11_20 on patient_therapy_statistics_2019_april_11_20 (cost=0.56..2,734.32 rows=1,722 width=367) (actual time=0.015..0.634 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 1400) 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. 0.610 0.610 ↑ 1.2 1,440 2

Parallel Index Scan using pk_pts_2019_april_21_31 on patient_therapy_statistics_2019_april_21_31 (cost=0.56..2,714.07 rows=1,709 width=367) (actual time=0.015..0.610 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 1400) 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.130 1.130 ↑ 1.2 1,440 2

Parallel Index Scan using pk_pts_2019_may_01_10 on patient_therapy_statistics_2019_may_01_10 (cost=0.56..2,666.93 rows=1,664 width=367) (actual time=0.011..1.130 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 1400) 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.156 1.156 ↑ 1.2 1,440 2

Parallel Index Scan using pk_pts_2019_may_11_20 on patient_therapy_statistics_2019_may_11_20 (cost=0.56..2,649.42 rows=1,658 width=367) (actual time=0.011..1.156 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 1400) 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.244 1.244 ↑ 1.2 1,584 2

Parallel Index Scan using pk_pts_2019_may_21_31 on patient_therapy_statistics_2019_may_21_31 (cost=0.56..2,916.56 rows=1,825 width=367) (actual time=0.011..1.244 rows=1,584 loops=2)

  • Index Cond: ((patient_id = 1400) 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.129 1.129 ↑ 1.2 1,440 2

Parallel Index Scan using pk_pts_2019_june_01_10 on patient_therapy_statistics_2019_june_01_10 (cost=0.56..2,654.52 rows=1,658 width=367) (actual time=0.011..1.129 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 1400) 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.164 1.164 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_2019_june_11_20 on patient_therapy_statistics_2019_june_11_20 (cost=0.56..2,645.84 rows=1,656 width=367) (actual time=0.011..1.164 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 1400) 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.001 1.001 ↑ 1.0 1,296 2

Parallel Index Scan using pk_pts_2019_june_21_31 on patient_therapy_statistics_2019_june_21_31 (cost=0.56..2,394.45 rows=1,353 width=367) (actual time=0.010..1.001 rows=1,296 loops=2)

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