explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6pD

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 366.625 ↑ 4.0 4 1

Aggregate (cost=50,239.95..50,240.91 rows=16 width=45) (actual time=366.618..366.625 rows=4 loops=1)

2. 0.010 366.615 ↑ 4.0 4 1

Aggregate (cost=50,239.95..50,240.43 rows=16 width=181) (actual time=366.609..366.615 rows=4 loops=1)

3. 0.000 366.605 ↑ 2.7 12 1

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

  • Sort Key: e.sexo, e.id_sexo
  • Sort Method: quicksort Memory: 25kB
4. 16.834 376.854 ↑ 2.7 12 1

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

5. 21.078 360.020 ↑ 4.0 4 3

Aggregate (cost=49,235.79..49,235.95 rows=16 width=21) (actual time=360.018..360.02 rows=4 loops=3)

6. 338.942 338.942 ↑ 1.2 18,345 3

Seq Scan on episodios_cache e (cost=0..49,066.17 rows=22,616 width=13) (actual time=0.05..338.942 rows=18,345 loops=3)

  • Filter: ((altad_normalizada >= 20180101) AND (altad_normalizada <= 20181231) AND (id_hospital = 290) AND (id_norma = 1))