explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r1Bq

Settings
# exclusive inclusive rows x rows loops node
1. 4.453 36.864 ↓ 1.0 4,284 1

Hash Left Join (cost=802.58..2,306.18 rows=4,283 width=382) (actual time=11.549..36.864 rows=4,284 loops=1)

  • Hash Cond: (((s.cdama)::text = (re.cdama)::text) AND (s.rgpresta = re.rgpresta))
2. 2.387 30.297 ↓ 1.0 4,284 1

Hash Left Join (cost=657.38..2,063.54 rows=4,283 width=282) (actual time=9.373..30.297 rows=4,284 loops=1)

  • Hash Cond: (((s.cdama)::text = (eserv.cdama)::text) AND ((s.cdestadoserv)::text = (eserv.cdestadoserv)::text))
3. 2.195 27.893 ↓ 1.0 4,284 1

Hash Left Join (cost=656.10..2,039.35 rows=4,283 width=270) (actual time=9.344..27.893 rows=4,284 loops=1)

  • Hash Cond: ((s.cdcliente = cli.cdcliente) AND ((s.cdama)::text = (cli.cdama)::text))
4. 2.426 25.610 ↓ 1.0 4,284 1

Hash Left Join (cost=649.10..2,009.73 rows=4,283 width=254) (actual time=9.242..25.610 rows=4,284 loops=1)

  • Hash Cond: (((s.cdama)::text = (serv.cdama)::text) AND (s.cdservicio = serv.cdservicio))
5. 2.356 22.547 ↓ 1.0 4,284 1

Hash Left Join (cost=600.10..1,938.16 rows=4,283 width=238) (actual time=8.585..22.547 rows=4,284 loops=1)

  • Hash Cond: (((s.cdama)::text = (r.cdama)::text) AND ((s.cdriesgo)::text = (r.cdriesgo)::text))
6. 2.891 20.169 ↓ 1.0 4,284 1

Hash Left Join (cost=599.08..1,912.15 rows=4,283 width=228) (actual time=8.546..20.169 rows=4,284 loops=1)

  • Hash Cond: (((s.cdama)::text = (pman.cdama)::text) AND ((asig.cdprovee)::text = (pman.cdprovee)::text))
7. 4.582 11.305 ↓ 1.0 4,284 1

Hash Left Join (cost=152.22..1,442.81 rows=4,283 width=199) (actual time=2.448..11.305 rows=4,284 loops=1)

  • Hash Cond: (((s.cdama)::text = (asig.cdama)::text) AND (s.rgpresta = asig.rgpresta))
8. 4.345 4.345 ↓ 1.0 4,284 1

Seq Scan on siniestro s (cost=0.00..1,268.10 rows=4,283 width=173) (actual time=0.017..4.345 rows=4,284 loops=1)

  • Filter: (status <> ALL ('{c,f}'::text[]))
  • Rows Removed by Filter: 125
9. 1.207 2.378 ↓ 1.0 4,172 1

Hash (cost=89.69..89.69 rows=4,169 width=33) (actual time=2.378..2.378 rows=4,172 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 335kB
10. 1.171 1.171 ↓ 1.0 4,172 1

Seq Scan on asignacion asig (cost=0.00..89.69 rows=4,169 width=33) (actual time=0.011..1.171 rows=4,172 loops=1)

11. 2.755 5.973 ↓ 1.0 10,360 1

Hash (cost=292.74..292.74 rows=10,274 width=38) (actual time=5.972..5.973 rows=10,360 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 859kB
12. 3.218 3.218 ↓ 1.0 10,360 1

Seq Scan on proveedor_manual pman (cost=0.00..292.74 rows=10,274 width=38) (actual time=0.015..3.218 rows=10,360 loops=1)

13. 0.009 0.022 ↓ 23.0 23 1

Hash (cost=1.01..1.01 rows=1 width=17) (actual time=0.022..0.022 rows=23 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
14. 0.013 0.013 ↓ 23.0 23 1

Seq Scan on riesgo r (cost=0.00..1.01 rows=1 width=17) (actual time=0.009..0.013 rows=23 loops=1)

15. 0.319 0.637 ↓ 1.0 1,299 1

Hash (cost=29.80..29.80 rows=1,280 width=27) (actual time=0.637..0.637 rows=1,299 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 94kB
16. 0.318 0.318 ↓ 1.0 1,299 1

Seq Scan on servicio serv (cost=0.00..29.80 rows=1,280 width=27) (actual time=0.011..0.318 rows=1,299 loops=1)

17. 0.044 0.088 ↑ 1.3 152 1

Hash (cost=4.00..4.00 rows=200 width=23) (actual time=0.088..0.088 rows=152 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
18. 0.044 0.044 ↑ 1.3 152 1

Seq Scan on cliente cli (cost=0.00..4.00 rows=200 width=23) (actual time=0.013..0.044 rows=152 loops=1)

19. 0.009 0.017 ↓ 1.7 19 1

Hash (cost=1.11..1.11 rows=11 width=20) (actual time=0.017..0.017 rows=19 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
20. 0.008 0.008 ↓ 1.7 19 1

Seq Scan on estado_servicio eserv (cost=0.00..1.11 rows=11 width=20) (actual time=0.005..0.008 rows=19 loops=1)

21. 0.970 2.114 ↓ 1.0 4,213 1

Hash (cost=82.08..82.08 rows=4,208 width=17) (actual time=2.114..2.114 rows=4,213 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 265kB
22. 1.144 1.144 ↓ 1.0 4,213 1

Seq Scan on retraso re (cost=0.00..82.08 rows=4,208 width=17) (actual time=0.011..1.144 rows=4,213 loops=1)

Planning time : 5.395 ms