explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gZA9

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 348.611 ↑ 4.0 4 1

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

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

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

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

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

  • Workers Planned: 2
  • Workers Launched: 2
4. 16.409 332.231 ↑ 4.0 4 3

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

  • Group Key: e.sexo, e.id_sexo
5. 315.822 315.822 ↑ 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.173..315.822 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.306 ms
Execution time : 348.795 ms