explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PU1o

Settings
# exclusive inclusive rows x rows loops node
1. 0.269 43.188 ↑ 123.2 319 1

Result (cost=188.41..2,808.13 rows=39,300 width=338) (actual time=1.806..43.188 rows=319 loops=1)

2. 38.898 42.919 ↑ 123.2 319 1

ProjectSet (cost=188.41..1,530.88 rows=39,300 width=338) (actual time=1.803..42.919 rows=319 loops=1)

3. 0.682 4.021 ↑ 1.2 319 1

Nested Loop Left Join (cost=188.41..1,325.54 rows=393 width=324) (actual time=1.631..4.021 rows=319 loops=1)

4. 0.307 3.020 ↑ 1.2 319 1

Merge Left Join (cost=188.12..723.25 rows=393 width=234) (actual time=1.618..3.020 rows=319 loops=1)

  • Merge Cond: (f.id = c.id_facturap)
5. 0.114 1.199 ↓ 1.0 318 1

Nested Loop Left Join (cost=82.82..611.45 rows=308 width=183) (actual time=0.136..1.199 rows=318 loops=1)

6. 0.050 0.449 ↓ 1.0 318 1

Merge Left Join (cost=82.54..105.01 rows=308 width=101) (actual time=0.100..0.449 rows=318 loops=1)

  • Merge Cond: (f.id = s.id_anticipo)
7. 0.062 0.382 ↓ 1.0 318 1

Merge Left Join (cost=41.34..60.04 rows=308 width=69) (actual time=0.080..0.382 rows=318 loops=1)

  • Merge Cond: (f.id = i.id_anticipo)
8. 0.298 0.298 ↓ 1.0 318 1

Index Scan using web_factura_preoveedor_pkey on web_factura_proveedor f (cost=0.15..15.08 rows=308 width=37) (actual time=0.053..0.298 rows=318 loops=1)

9. 0.011 0.022 ↓ 0.0 0 1

Sort (cost=41.19..41.69 rows=200 width=36) (actual time=0.022..0.022 rows=0 loops=1)

  • Sort Key: i.id_anticipo
  • Sort Method: quicksort Memory: 25kB
10. 0.001 0.011 ↓ 0.0 0 1

Subquery Scan on i (cost=29.05..33.55 rows=200 width=36) (actual time=0.011..0.011 rows=0 loops=1)

11. 0.004 0.010 ↓ 0.0 0 1

HashAggregate (cost=29.05..31.55 rows=200 width=36) (actual time=0.010..0.010 rows=0 loops=1)

  • Group Key: web_facturap_factura.id_anticipo
12. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on web_facturap_factura (cost=0.00..22.70 rows=1,270 width=18) (actual time=0.006..0.006 rows=0 loops=1)

13. 0.011 0.017 ↓ 0.0 0 1

Sort (cost=41.19..41.69 rows=200 width=36) (actual time=0.017..0.017 rows=0 loops=1)

  • Sort Key: s.id_anticipo
  • Sort Method: quicksort Memory: 25kB
14. 0.001 0.006 ↓ 0.0 0 1

Subquery Scan on s (cost=29.05..33.55 rows=200 width=36) (actual time=0.006..0.006 rows=0 loops=1)

15. 0.002 0.005 ↓ 0.0 0 1

HashAggregate (cost=29.05..31.55 rows=200 width=36) (actual time=0.005..0.005 rows=0 loops=1)

  • Group Key: web_facturap_embarque.id_anticipo
16. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on web_facturap_embarque (cost=0.00..22.70 rows=1,270 width=18) (actual time=0.003..0.003 rows=0 loops=1)

17. 0.636 0.636 ↑ 1.0 1 318

Index Scan using clientes_pkey on clientes e (cost=0.29..1.64 rows=1 width=90) (actual time=0.002..0.002 rows=1 loops=318)

  • Index Cond: (id = f.id_proveedor)
18. 0.117 1.514 ↑ 1.2 319 1

Sort (cost=105.30..106.28 rows=393 width=55) (actual time=1.479..1.514 rows=319 loops=1)

  • Sort Key: c.id_facturap
  • Sort Method: quicksort Memory: 50kB
19. 0.108 1.397 ↑ 1.2 319 1

Hash Left Join (cost=75.41..88.37 rows=393 width=55) (actual time=1.320..1.397 rows=319 loops=1)

  • Hash Cond: (c.claveunidad = u.id)
20. 0.030 0.030 ↑ 1.2 319 1

Seq Scan on web_facturap_conceptos c (cost=0.00..11.93 rows=393 width=31) (actual time=0.008..0.030 rows=319 loops=1)

21. 0.677 1.259 ↑ 1.0 2,418 1

Hash (cost=45.18..45.18 rows=2,418 width=26) (actual time=1.259..1.259 rows=2,418 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 171kB
22. 0.582 0.582 ↑ 1.0 2,418 1

Seq Scan on web_cfdi_claveunidad u (cost=0.00..45.18 rows=2,418 width=26) (actual time=0.013..0.582 rows=2,418 loops=1)

23. 0.319 0.319 ↑ 1.0 1 319

Index Scan using web_cfdi_claveprodserv_id on web_cfdi_claveprodserv p (cost=0.29..1.53 rows=1 width=37) (actual time=0.001..0.001 rows=1 loops=319)

  • Index Cond: (id = c.claveprod)
Planning time : 2.702 ms