explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a7Pv

Settings
# exclusive inclusive rows x rows loops node
1. 77.688 732.816 ↓ 1.0 55,736 1

Gather (cost=22,508.18..40,572.40 rows=55,710 width=438) (actual time=504.581..732.816 rows=55,736 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 67.150 655.128 ↑ 1.2 27,868 2

Hash Left Join (cost=21,508.18..34,001.40 rows=32,771 width=438) (actual time=493.024..655.128 rows=27,868 loops=2)

  • Hash Cond: (dcom.cco_id = cue.cco_id)
3. 12.658 587.630 ↑ 1.2 27,868 2

Hash Left Join (cost=21,492.96..28,819.76 rows=32,771 width=181) (actual time=492.580..587.630 rows=27,868 loops=2)

  • Hash Cond: (emp.ent_id = ent1.ent_id)
4. 129.004 570.684 ↑ 1.2 27,868 2

Parallel Hash Left Join (cost=21,267.58..28,508.31 rows=32,771 width=158) (actual time=488.257..570.684 rows=27,868 loops=2)

  • Hash Cond: (ddo.dco_id = dcom.dco_id)
5. 11.394 208.017 ↑ 1.2 27,868 2

Hash Left Join (cost=5,176.72..9,515.42 rows=32,771 width=158) (actual time=91.846..208.017 rows=27,868 loops=2)

  • Hash Cond: (ddo.ddo_agente = emp.emp_id)
6. 10.355 196.579 ↑ 1.2 27,868 2

Hash Left Join (cost=5,173.96..9,422.89 rows=32,771 width=158) (actual time=91.775..196.579 rows=27,868 loops=2)

  • Hash Cond: (pve.alm_id = alm.alm_id)
7. 11.257 186.207 ↑ 1.2 27,868 2

Hash Left Join (cost=5,172.94..9,262.93 rows=32,771 width=158) (actual time=91.735..186.207 rows=27,868 loops=2)

  • Hash Cond: (ccm.pve_id = pve.pve_id)
8. 9.921 174.922 ↑ 1.2 27,868 2

Hash Left Join (cost=5,171.83..9,102.88 rows=32,771 width=154) (actual time=91.687..174.922 rows=27,868 loops=2)

  • Hash Cond: (ccm.cti_id = cti.cti_id)
9. 13.787 164.940 ↑ 1.2 27,868 2

Hash Left Join (cost=5,168.23..9,008.12 rows=32,771 width=154) (actual time=91.598..164.940 rows=27,868 loops=2)

  • Hash Cond: (cli.ent_id = ent.ent_id)
10. 15.442 148.195 ↑ 1.2 27,868 2

Hash Left Join (cost=4,942.86..8,696.67 rows=32,771 width=131) (actual time=88.582..148.195 rows=27,868 loops=2)

  • Hash Cond: (ddo.cli_id = cli.cli_id)
11. 62.242 128.725 ↑ 1.2 27,868 2

Parallel Hash Left Join (cost=4,678.71..8,346.44 rows=32,771 width=99) (actual time=84.528..128.725 rows=27,868 loops=2)

  • Hash Cond: (ddo.ccm_id = ccm.ccm_id)
12. 13.845 13.845 ↑ 1.2 27,868 2

Parallel Seq Scan on ddocumento ddo (cost=0.00..2,215.71 rows=32,771 width=79) (actual time=0.027..13.845 rows=27,868 loops=2)

13. 27.064 52.638 ↑ 1.2 75,819 2

Parallel Hash (cost=3,012.98..3,012.98 rows=90,698 width=24) (actual time=52.637..52.638 rows=75,819 loops=2)

  • Buckets: 65536 Batches: 8 Memory Usage: 1568kB
14. 25.574 25.574 ↑ 1.2 75,819 2

Parallel Seq Scan on ccomproba ccm (cost=0.00..3,012.98 rows=90,698 width=24) (actual time=0.034..25.574 rows=75,819 loops=2)

15. 1.671 4.028 ↑ 1.0 6,398 2

Hash (cost=182.40..182.40 rows=6,540 width=40) (actual time=4.028..4.028 rows=6,398 loops=2)

  • Buckets: 8192 Batches: 1 Memory Usage: 525kB
16. 2.357 2.357 ↑ 1.0 6,398 2

Seq Scan on cliente cli (cost=0.00..182.40 rows=6,540 width=40) (actual time=0.032..2.357 rows=6,398 loops=2)

17. 1.581 2.958 ↓ 1.0 6,157 2

Hash (cost=148.50..148.50 rows=6,150 width=31) (actual time=2.958..2.958 rows=6,157 loops=2)

  • Buckets: 8192 Batches: 1 Memory Usage: 463kB
18. 1.377 1.377 ↓ 1.0 6,157 2

Seq Scan on entidad ent (cost=0.00..148.50 rows=6,150 width=31) (actual time=0.032..1.377 rows=6,157 loops=2)

19. 0.017 0.061 ↑ 1.0 71 2

Hash (cost=2.71..2.71 rows=71 width=8) (actual time=0.061..0.061 rows=71 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
20. 0.044 0.044 ↑ 1.0 71 2

Seq Scan on ctipocom cti (cost=0.00..2.71 rows=71 width=8) (actual time=0.028..0.044 rows=71 loops=2)

21. 0.010 0.028 ↑ 1.0 5 2

Hash (cost=1.05..1.05 rows=5 width=12) (actual time=0.028..0.028 rows=5 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
22. 0.018 0.018 ↑ 1.0 5 2

Seq Scan on puntoventa pve (cost=0.00..1.05 rows=5 width=12) (actual time=0.017..0.018 rows=5 loops=2)

23. 0.004 0.017 ↑ 1.0 1 2

Hash (cost=1.01..1.01 rows=1 width=8) (actual time=0.017..0.017 rows=1 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
24. 0.013 0.013 ↑ 1.0 1 2

Seq Scan on almacen alm (cost=0.00..1.01 rows=1 width=8) (actual time=0.012..0.013 rows=1 loops=2)

25. 0.018 0.044 ↓ 1.0 81 2

Hash (cost=1.78..1.78 rows=78 width=8) (actual time=0.044..0.044 rows=81 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
26. 0.026 0.026 ↓ 1.0 81 2

Seq Scan on empleado emp (cost=0.00..1.78 rows=78 width=8) (actual time=0.016..0.026 rows=81 loops=2)

27. 126.163 233.663 ↓ 1.2 403,386 2

Parallel Hash (cost=10,455.05..10,455.05 rows=343,505 width=8) (actual time=233.663..233.663 rows=403,386 loops=2)

  • Buckets: 65536 Batches: 32 Memory Usage: 1536kB
28. 107.500 107.500 ↓ 1.2 403,386 2

Parallel Seq Scan on dcomproba dcom (cost=0.00..10,455.05 rows=343,505 width=8) (actual time=0.038..107.500 rows=403,386 loops=2)

29. 2.467 4.288 ↓ 1.0 6,157 2

Hash (cost=148.50..148.50 rows=6,150 width=31) (actual time=4.288..4.288 rows=6,157 loops=2)

  • Buckets: 8192 Batches: 1 Memory Usage: 463kB
30. 1.821 1.821 ↓ 1.0 6,157 2

Seq Scan on entidad ent1 (cost=0.00..148.50 rows=6,150 width=31) (actual time=0.020..1.821 rows=6,157 loops=2)

31. 0.180 0.348 ↑ 1.0 410 2

Hash (cost=10.10..10.10 rows=410 width=38) (actual time=0.348..0.348 rows=410 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
32. 0.168 0.168 ↑ 1.0 410 2

Seq Scan on cuenta_contable cue (cost=0.00..10.10 rows=410 width=38) (actual time=0.042..0.168 rows=410 loops=2)

Planning time : 2.922 ms