explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0RrM

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

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

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

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

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

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

  • Workers Planned: 2
  • Workers Launched: 2
4. 18.987 374.362 ↑ 4.0 4 3

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

  • Group Key: e.id_sexo, e.sexo
5. 355.375 355.375 ↑ 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.057..355.375 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.339 ms
Execution time : 392.321 ms