explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vFeT : Test

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

Aggregate (cost=6,437.67..6,437.67 rows=1 width=14) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,372.98..6,437.14 rows=211 width=14) (actual rows= loops=)

  • Hash Cond: (outer.invoiceid = inner.id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on duepayment d (cost=0.00..3,432.37 rows=125,937 width=18) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=2,372.47..2,372.47 rows=204 width=4) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using idx_invoice_invoiceidasoc on invoice i (cost=0.00..2,372.47 rows=204 width=4) (actual rows= loops=)

  • Index Cond: (invoiceidasoc = 1000)
  • Filter: ((sdate)::timestamp with time zone <= now())