explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gWrT

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 351.753 ↑ 1.0 1 1

Finalize GroupAggregate (cost=1,000.00..50,179.48 rows=1 width=12) (actual time=351.753..351.753 rows=1 loops=1)

  • Group Key: e.id_hospital
2. 11.206 353.690 ↓ 1.5 3 1

Gather (cost=1,000.00..50,179.46 rows=2 width=12) (actual time=351.742..353.690 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 15.244 342.484 ↑ 1.0 1 3

Partial GroupAggregate (cost=0.00..49,179.26 rows=1 width=12) (actual time=342.484..342.484 rows=1 loops=3)

  • Group Key: e.id_hospital
4. 327.240 327.240 ↑ 1.2 18,345 3

Parallel Seq Scan on episodios_cache e (cost=0.00..49,066.17 rows=22,616 width=4) (actual time=0.076..327.240 rows=18,345 loops=3)

  • Filter: ((altad_normalizada >= 20180101) AND (altad_normalizada <= 20181231) AND (id_hospital = 290) AND (id_norma = 1))
  • Rows Removed by Filter: 247022
Planning time : 0.421 ms
Execution time : 353.762 ms