explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kpIU

Settings
# exclusive inclusive rows x rows loops node
1. 3.983 848.136 ↑ 81.9 36 1

Subquery Scan on t (cost=2,792,344.19..2,811,507.91 rows=2,948 width=45) (actual time=799.579..848.136 rows=36 loops=1)

  • Filter: (t.row_number = 1)
  • Rows Removed by Filter: 98549
2. 39.643 844.153 ↑ 6.0 98,585 1

WindowAgg (cost=2,792,344.19..2,804,137.25 rows=589,653 width=50) (actual time=799.577..844.153 rows=98,585 loops=1)

3. 42.498 804.510 ↑ 6.0 98,585 1

Sort (cost=2,792,344.19..2,793,818.32 rows=589,653 width=37) (actual time=799.565..804.510 rows=98,585 loops=1)

  • Sort Key: id.odberne_miesto_id, id.measured_value DESC
  • Sort Method: quicksort Memory: 10780kB
4. 341.556 762.012 ↑ 6.0 98,585 1

Hash Join (cost=50,934.83..2,719,702.90 rows=589,653 width=37) (actual time=331.402..762.012 rows=98,585 loops=1)

  • Hash Cond: (id.odberne_miesto_id = om.id)
  • Join Filter: (id.measured_at > om.cas_poslednej_kontroly_udalosti)
  • Rows Removed by Join Filter: 2021460
5. 114.766 417.192 ↑ 1.2 2,125,901 1

Gather (cost=50,485.44..2,712,363.22 rows=2,624,112 width=37) (actual time=175.292..417.192 rows=2,125,901 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 131.944 302.426 ↑ 1.5 708,634 3

Parallel Bitmap Heap Scan on intervalove_data id (cost=49,485.44..2,448,952.02 rows=1,093,380 width=37) (actual time=171.840..302.426 rows=708,634 loops=3)

  • Recheck Cond: ((measured_value - rk) >= '0'::numeric)
  • Heap Blocks: exact=207
7. 170.482 170.482 ↑ 1.2 2,125,901 1

Bitmap Index Scan on intervalove_data_expr_idx (cost=0.00..48,829.41 rows=2,624,112 width=0) (actual time=170.482..170.482 rows=2,125,901 loops=1)

  • Index Cond: ((measured_value - rk) >= '0'::numeric)
8. 0.683 3.264 ↑ 1.0 4,011 1

Hash (cost=399.25..399.25 rows=4,011 width=16) (actual time=3.264..3.264 rows=4,011 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 221kB
9. 2.581 2.581 ↑ 1.0 4,011 1

Seq Scan on odberne_miesto om (cost=0.00..399.25 rows=4,011 width=16) (actual time=0.076..2.581 rows=4,011 loops=1)

  • Filter: ((time_invalidated IS NULL) AND (cas_poslednej_kontroly_udalosti < now()))
  • Rows Removed by Filter: 1939