explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jj3x

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Finalize Aggregate (cost=57,249.65..57,249.66 rows=1 width=32) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather (cost=57,249.43..57,249.64 rows=2 width=32) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial Aggregate (cost=56,249.43..56,249.44 rows=1 width=32) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=30,736.67..55,207.76 rows=416,667 width=5) (actual rows= loops=)

  • Hash Cond: (interval_readings.reading_file_import_id = reading_file_import.id)
5. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on interval_readings (cost=0.00..17,679.33 rows=416,667 width=13) (actual rows= loops=)

  • Filter: ((interval_number >= '0'::numeric) AND (interval_number <= '12'::numeric) AND ((connection_id)::text = '12345'::text) AND ((reading_unit)::text = 'kWh'::text))
6. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=23,900.33..23,900.33 rows=416,667 width=8) (actual rows= loops=)

  • -> Parallel Seq Scan on reading_file_import (cost=0.00..23900.33 rows=416,667 width=8)" Filter: (month = '2019-02-02'::date)