explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VrxX

Settings
# exclusive inclusive rows x rows loops node
1. 10.675 80.014 ↑ 1.1 4,826 1

Gather (cost=5,491.23..26,978.94 rows=5,116 width=182) (actual time=34.269..80.014 rows=4,826 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.911 69.339 ↑ 1.3 1,609 3 / 3

Hash Left Join (cost=4,491.23..25,467.34 rows=2,132 width=182) (actual time=29.023..69.339 rows=1,609 loops=3)

  • Hash Cond: (ag_nodo5__ticket_accion.id_ejecutivo_activacion = ag_users.id_user)
3. 2.254 66.374 ↑ 1.3 1,609 3 / 3

Parallel Hash Left Join (cost=4,299.82..25,270.32 rows=2,132 width=136) (actual time=26.893..66.374 rows=1,609 loops=3)

  • Hash Cond: (ag_nodo5__ticket_accion.id_empresa = ag_nodo5__empresa.id_nodo)
4. 1.838 37.851 ↑ 1.3 1,609 3 / 3

Nested Loop Left Join (cost=0.42..20,965.33 rows=2,132 width=111) (actual time=0.164..37.851 rows=1,609 loops=3)

5. 26.361 26.361 ↑ 1.3 1,609 3 / 3

Parallel Seq Scan on ag_nodo5__ticket_accion (cost=0.00..10,869.15 rows=2,132 width=111) (actual time=0.132..26.361 rows=1,609 loops=3)

  • Filter: ((id_responsable = 6,787) AND (nodo_status = '3'::bpchar))
  • Rows Removed by Filter: 82,915
6. 9.652 9.652 ↑ 1.0 1 4,826 / 3

Index Scan using ag_nodo5__ticket_pkey on ag_nodo5__ticket (cost=0.42..4.74 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=4,826)

  • Index Cond: (id_nodo = ag_nodo5__ticket_accion.id_ticket)
7. 13.154 26.269 ↑ 1.8 32,179 3 / 3

Parallel Hash (cost=3,588.62..3,588.62 rows=56,862 width=41) (actual time=26.269..26.269 rows=32,179 loops=3)

  • Buckets: 131,072 Batches: 1 Memory Usage: 8,320kB
8. 13.115 13.115 ↑ 1.8 32,179 3 / 3

Parallel Seq Scan on ag_nodo5__empresa (cost=0.00..3,588.62 rows=56,862 width=41) (actual time=0.007..13.115 rows=32,179 loops=3)

9. 0.598 2.054 ↑ 1.0 2,196 3 / 3

Hash (cost=163.96..163.96 rows=2,196 width=26) (actual time=2.054..2.054 rows=2,196 loops=3)

  • Buckets: 4,096 Batches: 1 Memory Usage: 161kB
10. 1.456 1.456 ↑ 1.0 2,196 3 / 3

Seq Scan on ag_users (cost=0.00..163.96 rows=2,196 width=26) (actual time=0.013..1.456 rows=2,196 loops=3)

Planning time : 2.199 ms
Execution time : 80.456 ms