explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Mluo

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 393.278 ↑ 4.0 4 1

Finalize GroupAggregate (cost=50,239.95..50,240.43 rows=16 width=21) (actual time=393.273..393.278 rows=4 loops=1)

  • Group Key: e.id_sexo, e.sexo
2. 0.000 393.270 ↑ 2.7 12 1

Sort (cost=50,239.95..50,240.03 rows=32 width=21) (actual time=393.269..393.270 rows=12 loops=1)

  • Sort Key: e.id_sexo, e.sexo
  • Sort Method: quicksort Memory: 25kB
3. 17.470 398.832 ↑ 2.7 12 1

Gather (cost=50,235.79..50,239.15 rows=32 width=21) (actual time=393.243..398.832 rows=12 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 18.180 381.362 ↑ 4.0 4 3

Partial HashAggregate (cost=49,235.79..49,235.95 rows=16 width=21) (actual time=381.361..381.362 rows=4 loops=3)

  • Group Key: e.id_sexo, e.sexo
5. 363.182 363.182 ↑ 1.2 18,345 3

Parallel Seq Scan on episodios_cache e (cost=0.00..49,066.17 rows=22,616 width=13) (actual time=0.147..363.182 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.295 ms
Execution time : 398.916 ms