explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VLVw

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

Hash Join (cost=365.44..1,696,026.61 rows=3,716,010 width=168) (actual rows= loops=)

  • Hash Cond: ((pti.cobol_key = gl.cobol_key) AND (pt.company = gl.company_number))
2. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=13.71..882,920.95 rows=10,697,846 width=136) (actual rows= loops=)

  • Merge Cond: (pt.id = tir.transaction_id)
  • Join Filter: ((pti.lineno = tir.lineno) AND (pti.item_type = tir.item_type))
3. 0.000 0.000 ↓ 0.0

Merge Join (cost=13.44..856,091.05 rows=10,697,846 width=97) (actual rows= loops=)

  • Merge Cond: (pt.id = pti.transaction_id)
4. 0.000 0.000 ↓ 0.0

Index Scan using posted_transaction_pkey on posted_transaction pt (cost=0.43..97,965.62 rows=1,679,927 width=52) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using idx__posted_transaction_item__transaction_id on posted_transaction_item pti (cost=0.43..620,208.88 rows=10,697,846 width=49) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Materialize (cost=0.27..37.41 rows=389 width=49) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using posted_transaction_item_reference_pkey on posted_transaction_item_reference tir (cost=0.27..36.44 rows=389 width=49) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=232.49..232.49 rows=7,949 width=44) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on gl (cost=0.00..232.49 rows=7,949 width=44) (actual rows= loops=)