explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d8Ia

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=235,637.52..235,660.02 rows=1,000 width=92) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Unique (cost=235,637.52..245,719.01 rows=448,066 width=92) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=235,637.52..236,757.69 rows=448,066 width=92) (actual rows= loops=)

  • Sort Key: f.id DESC, em.nom, f.data_creada, f.serie, f.interessat_principal_nom, f.tipus_factura_4d, f.referencia_centre_expedient, f.honoraris_total
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=141,016.43..170,605.02 rows=448,066 width=92) (actual rows= loops=)

  • Hash Cond: (p.empresa_id = em.id)
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=141,007.03..169,142.51 rows=448,066 width=72) (actual rows= loops=)

  • Hash Cond: (ex.project_id = p.id)
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=140,844.18..167,794.75 rows=448,066 width=72) (actual rows= loops=)

  • Hash Cond: (d.expedient_id = ex.id)
7. 0.000 0.000 ↓ 0.0

Hash Join (cost=111,903.18..137,677.57 rows=448,066 width=72) (actual rows= loops=)

  • Hash Cond: (fd.origen_id = d.id)
8. 0.000 0.000 ↓ 0.0

Hash Join (cost=63,454.80..88,053.00 rows=448,066 width=72) (actual rows= loops=)

  • Hash Cond: (fd.factura_id = f.id)
9. 0.000 0.000 ↓ 0.0

Seq Scan on factures_detalls fd (cost=0.00..14,167.01 rows=448,066 width=8) (actual rows= loops=)

  • Filter: (origen_tipus = 1)
10. 0.000 0.000 ↓ 0.0

Hash (cost=51,565.40..51,565.40 rows=490,912 width=68) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on factures f (cost=0.00..51,565.40 rows=490,912 width=68) (actual rows= loops=)

  • Filter: (tipus <> 108)
12. 0.000 0.000 ↓ 0.0

Hash (cost=42,612.06..42,612.06 rows=466,906 width=8) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on documents d (cost=0.00..42,612.06 rows=466,906 width=8) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Hash (cost=25,324.33..25,324.33 rows=289,333 width=8) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Seq Scan on expedients ex (cost=0.00..25,324.33 rows=289,333 width=8) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Hash (cost=155.71..155.71 rows=571 width=8) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Seq Scan on projectes p (cost=0.00..155.71 rows=571 width=8) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Hash (cost=9.18..9.18 rows=18 width=28) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Seq Scan on empreses em (cost=0.00..9.18 rows=18 width=28) (actual rows= loops=)