explain.depesz.com

PostgreSQL's explain analyze made readable

Result: p9pg

Settings
# exclusive inclusive rows x rows loops node
1. 12.848 111.110 ↑ 1.1 4,825 1

Gather (cost=5,491.23..26,978.94 rows=5,116 width=182) (actual time=40.652..111.110 rows=4,825 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 1.182 98.262 ↑ 1.3 1,608 3 / 3

Hash Left Join (cost=4,491.23..25,467.34 rows=2,132 width=182) (actual time=32.851..98.262 rows=1,608 loops=3)

  • Hash Cond: (ag_nodo5__ticket_accion.id_ejecutivo_activacion = ag_users.id_user)
3. 3.320 94.910 ↑ 1.3 1,608 3 / 3

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

  • Hash Cond: (ag_nodo5__ticket_accion.id_empresa = ag_nodo5__empresa.id_nodo)
4. 2.069 62.468 ↑ 1.3 1,608 3 / 3

Nested Loop Left Join (cost=0.42..20,965.33 rows=2,132 width=111) (actual time=0.149..62.468 rows=1,608 loops=3)

5. 28.232 28.232 ↑ 1.3 1,608 3 / 3

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

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

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

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

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

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

9. 0.659 2.170 ↑ 1.0 2,196 3 / 3

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

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

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

Planning time : 2.472 ms
Execution time : 111.594 ms