explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kzmA

Settings
# exclusive inclusive rows x rows loops node
1. 0.082 0.228 ↓ 38.0 38 1

Sort (cost=65.59..65.59 rows=1 width=172) (actual time=0.222..0.228 rows=38 loops=1)

  • Sort Key: m.apepat_med, m.apemat_med, m.nom_med
  • Sort Method: quicksort Memory: 28kB
2.          

CTE ultima_plantilla

3. 0.004 0.040 ↑ 100.0 2 1

Unique (cost=55.27..59.17 rows=200 width=76) (actual time=0.034..0.040 rows=2 loops=1)

4. 0.031 0.036 ↑ 111.4 7 1

Sort (cost=55.27..57.22 rows=780 width=76) (actual time=0.034..0.036 rows=7 loops=1)

  • Sort Key: h_medico_plantilla.rut_med, h_medico_plantilla.fecha DESC
  • Sort Method: quicksort Memory: 25kB
5. 0.005 0.005 ↑ 111.4 7 1

Seq Scan on h_medico_plantilla (cost=0.00..17.80 rows=780 width=76) (actual time=0.004..0.005 rows=7 loops=1)

6. 0.029 0.146 ↓ 38.0 38 1

Hash Right Join (cost=1.65..6.41 rows=1 width=172) (actual time=0.123..0.146 rows=38 loops=1)

  • Hash Cond: (hmp.rut_med = m.rut_med)
7. 0.042 0.042 ↑ 100.0 2 1

CTE Scan on ultima_plantilla hmp (cost=0.00..4.00 rows=200 width=76) (actual time=0.036..0.042 rows=2 loops=1)

8. 0.032 0.075 ↓ 38.0 38 1

Hash (cost=1.64..1.64 rows=1 width=128) (actual time=0.075..0.075 rows=38 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
9. 0.043 0.043 ↓ 38.0 38 1

Seq Scan on medico m (cost=0.00..1.64 rows=1 width=128) (actual time=0.019..0.043 rows=38 loops=1)

  • Filter: (est_med = '1'::numeric)
  • Rows Removed by Filter: 14
Planning time : 0.288 ms
Execution time : 0.289 ms