explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ObqH

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

Finalize Aggregate (cost=19,500.49..19,500.55 rows=1 width=320) (actual time=2,600.542..2,600.542 rows=1 loops=1)

2. 7.979 2,602.428 ↓ 2.0 2 1

Gather (cost=19,500.24..19,500.35 rows=1 width=608) (actual time=2,598.875..2,602.428 rows=2 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 337.674 2,594.449 ↑ 1.0 1 2

Partial Aggregate (cost=18,500.24..18,500.25 rows=1 width=608) (actual time=2,594.449..2,594.449 rows=1 loops=2)

4. 0.507 2,256.775 ↑ 1.1 4,320 2

Append (cost=87.80..16,814.94 rows=4,815 width=402) (actual time=726.066..2,256.775 rows=4,320 loops=2)

5. 0.000 729.077 ↑ 1.1 1,440 2

Parallel Bitmap Heap Scan on patient_therapy_statistics_vent_2019_jan_01_10 (cost=87.80..5,594.42 rows=1,652 width=402) (actual time=726.065..729.077 rows=1,440 loops=2)

  • Recheck Cond: ((patient_id = 1920) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-01-31 00:00:00'::timestamp without time zone))
  • Filter: (end_time <= '2019-01-31 00:00:00'::timestamp without time zone)
  • Heap Blocks: exact=1423
6. 729.081 729.081 ↓ 1.0 2,880 1

Bitmap Index Scan on ix_pts_channel_stats_vent2_2019_jan_01_10 (cost=0.00..87.10 rows=2,808 width=0) (actual time=729.081..729.081 rows=2,880 loops=1)

  • Index Cond: ((patient_id = 1920) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-01-31 00:00:00'::timestamp without time zone))
7. 3.453 736.844 ↑ 1.1 1,440 2

Parallel Bitmap Heap Scan on patient_therapy_statistics_vent_2019_jan_11_20 (cost=87.80..5,594.42 rows=1,652 width=402) (actual time=733.859..736.844 rows=1,440 loops=2)

  • Recheck Cond: ((patient_id = 1920) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-01-31 00:00:00'::timestamp without time zone))
  • Filter: (end_time <= '2019-01-31 00:00:00'::timestamp without time zone)
  • Heap Blocks: exact=1438
8. 733.391 733.391 ↓ 1.0 2,880 1

Bitmap Index Scan on ix_pts_channel_stats_vent2_2019_jan_11_20 (cost=0.00..87.10 rows=2,808 width=0) (actual time=733.391..733.391 rows=2,880 loops=1)

  • Index Cond: ((patient_id = 1920) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-01-31 00:00:00'::timestamp without time zone))
9. 3.449 790.347 ↑ 1.0 1,440 2

Parallel Bitmap Heap Scan on patient_therapy_statistics_vent_2019_jan_21_31 (cost=87.90..5,626.11 rows=1,511 width=402) (actual time=787.363..790.347 rows=1,440 loops=2)

  • Recheck Cond: ((patient_id = 1920) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-01-31 00:00:00'::timestamp without time zone))
  • Filter: (end_time <= '2019-01-31 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 0
  • Heap Blocks: exact=1430
10. 786.898 786.898 ↓ 1.0 2,881 1

Bitmap Index Scan on ix_pts_channel_stats_vent2_2019_jan_21_31 (cost=0.00..87.26 rows=2,821 width=0) (actual time=786.898..786.898 rows=2,881 loops=1)

  • Index Cond: ((patient_id = 1920) AND (start_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (start_time <= '2019-01-31 00:00:00'::timestamp without time zone))
Planning time : 1.636 ms