explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HRyp

Settings
# exclusive inclusive rows x rows loops node
1. 151.686 977.821 ↓ 6.4 434,548 1

Sort (cost=1,698,503.07..1,698,671.91 rows=67,536 width=28) (actual time=951.605..977.821 rows=434,548 loops=1)

  • Sort Key: signal."timestamp
  • Sort Method: quicksort Memory: 46238kB
2. 169.488 826.135 ↓ 6.4 434,548 1

Hash Join (cost=33,894.01..1,693,085.54 rows=67,536 width=28) (actual time=122.883..826.135 rows=434,548 loops=1)

  • Hash Cond: (signal.parameter_id = parameter.parameter_id)
3. 172.110 656.627 ↓ 1.2 1,738,192 1

Nested Loop (cost=33,892.65..1,686,837.11 rows=1,485,790 width=20) (actual time=122.854..656.627 rows=1,738,192 loops=1)

4. 0.024 0.024 ↑ 1.0 1 1

Seq Scan on source (cost=0.00..4.21 rows=1 width=4) (actual time=0.021..0.024 rows=1 loops=1)

  • Filter: ((name)::text = 'bf_f04_23_bahnhofstr'::text)
  • Rows Removed by Filter: 96
5. 364.754 484.493 ↓ 1.2 1,738,192 1

Bitmap Heap Scan on signal (cost=33,892.65..1,671,975.00 rows=1,485,790 width=24) (actual time=122.830..484.493 rows=1,738,192 loops=1)

  • Recheck Cond: (source_id = source.source_id)
  • Filter: (('1900-01-01 00:00:00'::timestamp without time zone <= "timestamp") AND ("timestamp" <= '2019-03-07 16:56:51'::timestamp without time zone))
  • Heap Blocks: exact=17924
6. 119.739 119.739 ↓ 1.2 1,738,192 1

Bitmap Index Scan on signal_source_id_index (cost=0.00..33,521.21 rows=1,490,218 width=0) (actual time=119.739..119.739 rows=1,738,192 loops=1)

  • Index Cond: (source_id = source.source_id)
7. 0.005 0.020 ↑ 1.0 2 1

Hash (cost=1.33..1.33 rows=2 width=16) (actual time=0.020..0.020 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on parameter (cost=0.00..1.33 rows=2 width=16) (actual time=0.010..0.015 rows=2 loops=1)

  • Filter: (((name)::text = 'water level'::text) OR ((name)::text = 'flow rate'::text))
  • Rows Removed by Filter: 48