explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Djkp

Settings
# exclusive inclusive rows x rows loops node
1. 14.031 307.419 ↑ 1,433.7 26 1

Gather (cost=1,072.46..53,978.43 rows=37,275 width=14) (actual time=0.620..307.419 rows=26 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.142 293.388 ↑ 1,725.7 9 3

Nested Loop (cost=72.46..49,250.93 rows=15,531 width=14) (actual time=193.016..293.388 rows=9 loops=3)

3. 70.771 293.229 ↑ 1,725.7 9 3

Hash Semi Join (cost=72.03..41,574.38 rows=15,531 width=14) (actual time=193.003..293.229 rows=9 loops=3)

  • Hash Cond: ((b.usuario)::text = (doc_roles_usuarios.rol_privacidad)::text)
4. 222.391 222.391 ↑ 1.3 727,747 3

Parallel Seq Scan on doc_documentos_privacidad b (cost=0.00..38,937.16 rows=911,398 width=26) (actual time=0.019..222.391 rows=727,747 loops=3)

  • Filter: (((vigencia)::text = 'S'::text) AND ((sel)::text = 'S'::text))
  • Rows Removed by Filter: 35515
5. 0.005 0.067 ↑ 11.0 2 3

Hash (cost=71.75..71.75 rows=22 width=21) (actual time=0.067..0.067 rows=2 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.001 0.062 ↑ 11.0 2 3

Append (cost=4.50..71.75 rows=22 width=21) (actual time=0.060..0.062 rows=2 loops=3)

7. 0.003 0.044 ↓ 0.0 0 3

Bitmap Heap Scan on doc_roles_usuarios (cost=4.50..69.53 rows=20 width=20) (actual time=0.044..0.044 rows=0 loops=3)

  • Recheck Cond: (((usuario)::text = 'aciero'::text) AND ((vigencia)::text = 'S'::text))
8. 0.041 0.041 ↓ 0.0 0 3

Bitmap Index Scan on index3 (cost=0.00..4.49 rows=20 width=0) (actual time=0.041..0.041 rows=0 loops=3)

  • Index Cond: (((usuario)::text = 'aciero'::text) AND ((vigencia)::text = 'S'::text))
9. 0.016 0.016 ↑ 1.0 1 3

Seq Scan on dual (cost=0.00..1.01 rows=1 width=32) (actual time=0.016..0.016 rows=1 loops=3)

10. 0.001 0.001 ↑ 1.0 1 3

Seq Scan on dual dual_1 (cost=0.00..1.01 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=3)

11. 0.017 0.017 ↑ 1.0 1 26

Index Only Scan using doc_documentos_acceso_pk on doc_documentos_acceso dc (cost=0.43..0.49 rows=1 width=14) (actual time=0.017..0.017 rows=1 loops=26)

  • Index Cond: (numero_docto = (b.numero_docto)::text)
  • Heap Fetches: 26