explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m9yF

Settings
# exclusive inclusive rows x rows loops node
1. 0.046 456.659 ↑ 4.0 4 1

Finalize GroupAggregate (cost=51,088.09..51,089.85 rows=16 width=181) (actual time=456.631..456.659 rows=4 loops=1)

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

Sort (cost=51,088.09..51,088.17 rows=32 width=241) (actual time=456.611..456.613 rows=12 loops=1)

  • Sort Key: e.sexo, e.id_sexo
  • Sort Method: quicksort Memory: 31kB
3. 16.184 466.760 ↑ 2.7 12 1

Gather (cost=51,083.89..51,087.29 rows=32 width=241) (actual time=455.975..466.760 rows=12 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 132.067 450.576 ↑ 4.0 4 3

Partial HashAggregate (cost=50,083.89..50,084.09 rows=16 width=241) (actual time=450.570..450.576 rows=4 loops=3)

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

Parallel Seq Scan on episodios_cache e (cost=0.00..49,066.17 rows=22,616 width=51) (actual time=0.082..318.509 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.872 ms
Execution time : 467.045 ms