explain.depesz.com

PostgreSQL's explain analyze made readable

Result: flx2

Settings
# exclusive inclusive rows x rows loops node
1. 3.813 36,587.202 ↓ 1.1 9,376 1

Sort (cost=3,981,424.24..3,981,446.20 rows=8,783 width=38) (actual time=36,586.162..36,587.202 rows=9,376 loops=1)

  • Sort Key: m.""MeasDBTime"" DESC
  • Sort Method: quicksort Memory: 1117kB
2. 13.132 36,583.389 ↓ 1.1 9,376 1

GroupAggregate (cost=3,979,027.16..3,980,848.93 rows=8,783 width=38) (actual time=36,561.761..36,583.389 rows=9,376 loops=1)

  • Group Key: m.""Id"
3. 49.457 36,570.257 ↑ 1.8 75,606 1

Sort (cost=3,979,027.16..3,979,373.95 rows=138,715 width=32) (actual time=36,561.739..36,570.257 rows=75,606 loops=1)

  • Sort Key: m.""Id"
  • Sort Method: quicksort Memory: 7798kB
4. 12,361.057 36,520.800 ↑ 1.8 75,606 1

Hash Right Join (cost=208,263.54..3,967,179.68 rows=138,715 width=32) (actual time=33,684.400..36,520.800 rows=75,606 loops=1)

  • Hash Cond: (r.""ChannelMeasureId"" = c.""Id"")
5. 23,993.004 23,993.004 ↓ 1.0 105,585,753 1

Seq Scan on ""ProbChannelMeasRAWX"" r (cost=0.00..3,363,028.72 rows=105,200,072 width=18) (actual time=0.021..23,993.004 rows=105,585,753 loops=1)

6. 3.390 166.739 ↓ 1.4 9,376 1

Hash (cost=208,180.65..208,180.65 rows=6,631 width=46) (actual time=166.738..166.739 rows=9,376 loops=1)

  • Buckets: 16384 (originally 8192) Batches: 1 (originally 1) Memory Usage: 843kB
7. 7.970 163.349 ↓ 1.4 9,376 1

Gather (cost=1,327.31..208,180.65 rows=6,631 width=46) (actual time=5.778..163.349 rows=9,376 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
8. 46.029 155.379 ↓ 1.1 3,125 3

Nested Loop Left Join (cost=327.31..206,517.55 rows=2,763 width=46) (actual time=1.735..155.379 rows=3,125 loops=3)

9. 101.222 109.336 ↓ 1.1 3,125 3

Nested Loop (cost=326.88..44,173.27 rows=2,763 width=24) (actual time=1.643..109.336 rows=3,125 loops=3)

10. 3.948 8.102 ↓ 2.2 8,228 3

Parallel Bitmap Heap Scan on ""ProbeMeas"" m (cost=326.45..19,034.41 rows=3,660 width=24) (actual time=1.544..8.102 rows=8,228 loops=3)

  • Recheck Cond: ((""ProbeId"" = 95) AND (""MeasDBTime"" >= '2019-09-05 06:00:00'::timestamp without time zone))
  • Heap Blocks: exact=905
11. 4.154 4.154 ↓ 2.8 24,685 1

Bitmap Index Scan on ""IX_ProbeMeas_ProbeId_MeasDBTime"" (cost=0.00..324.26 rows=8,783 width=0) (actual time=4.153..4.154 rows=24,685 loops=1)

  • Index Cond: ((""ProbeId"" = 95) AND (""MeasDBTime"" >= '2019-09-05 06:00:00'::timestamp without time zone))
12. 0.012 0.012 ↓ 0.0 0 24,685

Index Scan using ""IX_QualityIndicators_MeasureId"" on ""QualityIndicators"" q (cost=0.43..6.87 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=24,685)

  • Index Cond: (""MeasureId"" = m.""Id"")
  • Filter: (""Status"" = 102)
  • Rows Removed by Filter: 1
13. 0.014 0.014 ↑ 6.0 1 9,376

Index Scan using ""IX_ProbChannelMeas_MeasureId"" on ""ProbChannelMeas"" c (cost=0.43..58.70 rows=6 width=38) (actual time=0.014..0.014 rows=1 loops=9,376)

  • Index Cond: (""MeasureId"" = m.""Id"")
  • Filter: (""ChannelNumber"" = 1)
  • Rows Removed by Filter: 2
Planning time : 1.369 ms
Execution time : 36,589.892 ms