explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uVbd : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #cjH6; plan #RIdw; plan #VE6w; plan #VneM; plan #qJ5E; plan #J4aT; plan #SP2B; plan #tkVV; plan #o7K96

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 32.805 1,316.698 ↓ 56.6 22,514 1

Gather (cost=1,000.43..37,918.44 rows=398 width=803) (actual time=0.988..1,316.698 rows=22,514 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 21.702 1,283.893 ↓ 45.2 7,505 3 / 3

Nested Loop Semi Join (cost=0.43..36,878.64 rows=166 width=803) (actual time=0.365..1,283.893 rows=7,505 loops=3)

3. 73.348 73.348 ↓ 32.0 10,615 3 / 3

Parallel Seq Scan on episodios_cache_nf e (cost=0.00..10,718.27 rows=332 width=803) (actual time=0.055..73.348 rows=10,615 loops=3)

  • Filter: (id_norma = 1)
  • Rows Removed by Filter: 42459
4. 1,188.843 1,188.843 ↑ 2.0 1 31,844 / 3

Index Scan using dispensacion_episodio on dispensaciones_cache d (cost=0.43..177.86 rows=2 width=4) (actual time=0.112..0.112 rows=1 loops=31,844)

  • Index Cond: (id_episodio = e.id)
  • Filter: ((administraciond_normalizada >= 20180101) AND (administraciond_normalizada <= 20181231) AND (id_medicamento = 24117) AND (id_hospital = 290))
  • Rows Removed by Filter: 31
Planning time : 0.469 ms
Execution time : 1,319.469 ms