explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Uqls

Settings
# exclusive inclusive rows x rows loops node
1. 157.266 1,035.574 ↓ 6.4 434,548 1

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

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

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

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

Nested Loop (cost=33,892.65..1,686,837.11 rows=1,485,790 width=20) (actual time=144.034..703.472 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.020..0.024 rows=1 loops=1)

  • Filter: ((name)::text = 'bf_f04_23_bahnhofstr'::text)
  • Rows Removed by Filter: 96
5. 384.437 524.941 ↓ 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=144.010..524.941 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. 140.504 140.504 ↓ 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=140.504..140.504 rows=1,738,192 loops=1)

  • Index Cond: (source_id = source.source_id)
7. 0.004 0.022 ↑ 1.0 2 1

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

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

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

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