explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iB18

Settings
# exclusive inclusive rows x rows loops node
1. 41.792 143.697 ↓ 1.0 34,307 1

Nested Loop Left Join (cost=2,353.81..6,080.36 rows=33,912 width=213) (actual time=31.705..143.697 rows=34,307 loops=1)

2.          

CTE geojson

3. 0.002 0.002 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=1)

4. 17.460 101.905 ↓ 1.0 34,307 1

Hash Left Join (cost=2,353.80..4,808.64 rows=33,912 width=197) (actual time=31.684..101.905 rows=34,307 loops=1)

  • Hash Cond: (((pm.cdama)::text = (cpm.cdama)::text) AND ((pm.cdprovee)::text = (cpm.cdprovee)::text))
5. 10.561 70.058 ↓ 1.0 34,300 1

Hash Left Join (cost=1,279.07..3,082.15 rows=33,912 width=204) (actual time=17.116..70.058 rows=34,300 loops=1)

  • Hash Cond: (((pm.cdama)::text = (e.cdama)::text) AND ((pw.cdestadoprov)::text = (e.cdestadoprov)::text))
6. 10.969 59.484 ↓ 1.0 34,300 1

Hash Left Join (cost=1,277.77..2,901.98 rows=33,912 width=195) (actual time=17.086..59.484 rows=34,300 loops=1)

  • Hash Cond: (((pm.cdama)::text = (pw.cdama)::text) AND ((pm.cdprovee)::text = (pw.cdprovee)::text))
7. 17.641 48.464 ↓ 1.0 34,300 1

Hash Left Join (cost=1,274.82..2,721.00 rows=33,912 width=193) (actual time=17.017..48.464 rows=34,300 loops=1)

  • Hash Cond: (((b.cdama)::text = (pm.cdama)::text) AND ((b.cdprovee)::text = (pm.cdprovee)::text))
8. 13.926 13.926 ↓ 1.0 34,300 1

Seq Scan on base b (cost=0.00..1,268.12 rows=33,912 width=151) (actual time=0.013..13.926 rows=34,300 loops=1)

9. 8.642 16.897 ↑ 1.0 33,534 1

Hash (cost=771.53..771.53 rows=33,553 width=42) (actual time=16.896..16.897 rows=33,534 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2684kB
10. 8.255 8.255 ↑ 1.0 33,534 1

Seq Scan on proveedor_manual pm (cost=0.00..771.53 rows=33,553 width=42) (actual time=0.005..8.255 rows=33,534 loops=1)

11. 0.027 0.051 ↑ 1.0 78 1

Hash (cost=1.78..1.78 rows=78 width=12) (actual time=0.051..0.051 rows=78 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
12. 0.024 0.024 ↑ 1.0 78 1

Seq Scan on proveedor_web pw (cost=0.00..1.78 rows=78 width=12) (actual time=0.013..0.024 rows=78 loops=1)

13. 0.006 0.013 ↑ 1.0 12 1

Hash (cost=1.12..1.12 rows=12 width=14) (actual time=0.012..0.013 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
14. 0.007 0.007 ↑ 1.0 12 1

Seq Scan on estado_proveedor e (cost=0.00..1.12 rows=12 width=14) (actual time=0.005..0.007 rows=12 loops=1)

15. 8.529 14.387 ↓ 1.0 32,925 1

Hash (cost=594.29..594.29 rows=32,029 width=13) (actual time=14.387..14.387 rows=32,925 loops=1)

  • Buckets: 65536 (originally 32768) Batches: 1 (originally 1) Memory Usage: 1959kB
16. 5.858 5.858 ↓ 1.0 32,925 1

Seq Scan on centro_proveedor_manual cpm (cost=0.00..594.29 rows=32,029 width=13) (actual time=0.007..5.858 rows=32,925 loops=1)

17. 0.000 0.000 ↑ 1.0 1 34,307

CTE Scan on geojson (cost=0.00..0.02 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=34,307)

18.          

SubPlan (for Nested Loop Left Join)

19. 0.000 0.000 ↑ 1.0 1 34,307

Result (cost=0.00..0.01 rows=1 width=218) (actual time=0.000..0.000 rows=1 loops=34,307)

Planning time : 0.960 ms
Execution time : 145.293 ms