explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qfJz

Settings
# exclusive inclusive rows x rows loops node
1. 53.358 2,178.962 ↓ 767.1 69,035 1

Gather Merge (cost=1,095,822.93..1,095,833.43 rows=90 width=88) (actual time=2,130.810..2,178.962 rows=69,035 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 19.949 2,125.604 ↓ 511.4 23,012 3 / 3

Sort (cost=1,094,822.90..1,094,823.02 rows=45 width=88) (actual time=2,123.741..2,125.604 rows=23,012 loops=3)

  • Sort Key: read_time
  • Sort Method: quicksort Memory: 4039kB
  • Worker 0: Sort Method: quicksort Memory: 3988kB
  • Worker 1: Sort Method: quicksort Memory: 3987kB
3. 1,878.325 2,105.655 ↓ 511.4 23,012 3 / 3

Parallel Bitmap Heap Scan on tilt_data (cost=74,332.26..1,094,821.67 rows=45 width=88) (actual time=1,528.506..2,105.655 rows=23,012 loops=3)

  • Recheck Cond: (station = 'c08883c0-fbe5-11e9-bd6e-aec49259cebb'::uuid)
  • Filter: (((read_time)::date <= '2020-01-09'::date) AND ((read_time)::date >= '2019-01-09'::date) AND (((date_part('minute'::text, read_time))::integer % 10) = 0))
  • Rows Removed by Filter: 1859961
  • Heap Blocks: exact=29311
4. 227.330 227.330 ↓ 1.3 5,648,919 1 / 3

Bitmap Index Scan on data_station_idx (cost=0.00..74,332.23 rows=4,339,689 width=0) (actual time=681.989..681.989 rows=5,648,919 loops=1)

  • Index Cond: (station = 'c08883c0-fbe5-11e9-bd6e-aec49259cebb'::uuid)
Planning time : 0.501 ms
Execution time : 2,184.739 ms