explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ITWq

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

Finalize Aggregate (cost=59,068.58..59,068.64 rows=1 width=320) (actual time=2,067.260..2,067.261 rows=1 loops=1)

2. 6.463 2,068.847 ↓ 2.0 2 1

Gather (cost=59,068.33..59,068.44 rows=1 width=608) (actual time=2,066.910..2,068.847 rows=2 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 2,023.964 2,062.384 ↑ 1.0 1 2

Partial Aggregate (cost=58,068.33..58,068.34 rows=1 width=608) (actual time=2,062.384..2,062.384 rows=1 loops=2)

4. 3.054 38.420 ↑ 1.1 25,920 2

Append (cost=0.56..47,697.78 rows=29,630 width=402) (actual time=0.017..38.420 rows=25,920 loops=2)

5. 1.869 1.869 ↑ 1.2 1,440 2

Parallel Index Scan using pk_pts_vent2_2019_jan_01_10 on patient_therapy_statistics_vent_2019_jan_01_10 (cost=0.56..2,660.76 rows=1,661 width=402) (actual time=0.016..1.869 rows=1,440 loops=2)

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

Parallel Index Scan using pk_pts_vent2_2019_jan_11_20 on patient_therapy_statistics_vent_2019_jan_11_20 (cost=0.56..2,653.93 rows=1,657 width=402) (actual time=0.014..1.890 rows=1,440 loops=2)

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

Parallel Index Scan using pk_pts_vent2_2019_jan_21_31 on patient_therapy_statistics_vent_2019_jan_21_31 (cost=0.56..2,920.90 rows=1,824 width=402) (actual time=0.016..2.026 rows=1,584 loops=2)

  • Index Cond: ((patient_id = 1500) 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.848 1.848 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_vent2_2019_feb_01_10 on patient_therapy_statistics_vent_2019_feb_01_10 (cost=0.56..2,653.03 rows=1,656 width=402) (actual time=0.013..1.848 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 1500) 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.819 1.819 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_vent2_2019_feb_11_20 on patient_therapy_statistics_vent_2019_feb_11_20 (cost=0.56..2,645.89 rows=1,652 width=402) (actual time=0.015..1.819 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 1500) 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.412 1.412 ↑ 1.2 1,152 2

Parallel Index Scan using pk_pts_vent2_2019_feb_21_31 on patient_therapy_statistics_vent_2019_feb_21_31 (cost=0.56..2,128.68 rows=1,328 width=402) (actual time=0.015..1.412 rows=1,152 loops=2)

  • Index Cond: ((patient_id = 1500) 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.815 1.815 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_vent2_2019_mar_01_10 on patient_therapy_statistics_vent_2019_mar_01_10 (cost=0.56..2,645.89 rows=1,652 width=402) (actual time=0.013..1.815 rows=1,440 loops=2)

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

Parallel Index Scan using pk_pts_vent2_2019_mar_11_20 on patient_therapy_statistics_vent_2019_mar_11_20 (cost=0.56..2,645.89 rows=1,652 width=402) (actual time=0.015..3.541 rows=1,440 loops=2)

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

Parallel Index Scan using pk_pts_vent2_2019_mar_21_31 on patient_therapy_statistics_vent_2019_mar_21_31 (cost=0.56..2,919.08 rows=1,822 width=402) (actual time=0.016..2.039 rows=1,584 loops=2)

  • Index Cond: ((patient_id = 1500) 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.828 1.828 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_vent2_2019_apr_01_10 on patient_therapy_statistics_vent_2019_apr_01_10 (cost=0.56..2,645.89 rows=1,652 width=402) (actual time=0.014..1.828 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 1500) 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.802 1.802 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_vent2_2019_apr_11_20 on patient_therapy_statistics_vent_2019_apr_11_20 (cost=0.56..2,645.89 rows=1,652 width=402) (actual time=0.011..1.802 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 1500) 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.761 1.761 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_vent2_2019_apr_21_31 on patient_therapy_statistics_vent_2019_apr_21_31 (cost=0.56..2,645.89 rows=1,652 width=402) (actual time=0.011..1.761 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 1500) 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.801 1.801 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_vent2_2019_may_01_10 on patient_therapy_statistics_vent_2019_may_01_10 (cost=0.56..2,645.89 rows=1,652 width=402) (actual time=0.013..1.801 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 1500) 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.814 1.814 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_vent2_2019_may_11_20 on patient_therapy_statistics_vent_2019_may_11_20 (cost=0.56..2,645.89 rows=1,652 width=402) (actual time=0.011..1.814 rows=1,440 loops=2)

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

Parallel Index Scan using pk_pts_vent2_2019_may_21_31 on patient_therapy_statistics_vent_2019_may_21_31 (cost=0.56..2,919.08 rows=1,822 width=402) (actual time=0.018..2.041 rows=1,584 loops=2)

  • Index Cond: ((patient_id = 1500) 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.840 1.840 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_vent2_2019_jun_01_10 on patient_therapy_statistics_vent_2019_jun_01_10 (cost=0.56..2,645.89 rows=1,652 width=402) (actual time=0.011..1.840 rows=1,440 loops=2)

  • Index Cond: ((patient_id = 1500) 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.856 1.856 ↑ 1.1 1,440 2

Parallel Index Scan using pk_pts_vent2_2019_jun_11_20 on patient_therapy_statistics_vent_2019_jun_11_20 (cost=0.56..2,645.89 rows=1,652 width=402) (actual time=0.017..1.856 rows=1,440 loops=2)

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

Parallel Index Scan using pk_pts_vent2_2019_jun_21_31 on patient_therapy_statistics_vent_2019_jun_21_31 (cost=0.56..2,383.42 rows=1,340 width=402) (actual time=0.012..2.364 rows=1,296 loops=2)

  • Index Cond: ((patient_id = 1500) 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
Planning time : 1.848 ms