explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rLZG

Settings
# exclusive inclusive rows x rows loops node
1. 7.047 57.951 ↑ 1.1 4,826 1

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.940 50.904 ↑ 1.3 1,609 3 / 3

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

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

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

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

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

5. 20.809 20.809 ↑ 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.114..20.809 rows=1,609 loops=3)

  • Filter: ((id_responsable = 6,787) AND (nodo_status = '3'::bpchar))
  • Rows Removed by Filter: 82,915
6. 4.826 4.826 ↑ 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.003..0.003 rows=1 loops=4,826)

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

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

  • Buckets: 131,072 Batches: 1 Memory Usage: 8,288kB
8. 9.414 9.414 ↑ 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..9.414 rows=32,179 loops=3)

9. 0.556 1.504 ↑ 1.0 2,196 3 / 3

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

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

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

Planning time : 1.970 ms
Execution time : 58.357 ms