explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aRtr

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

Limit (cost=27,438.18..52,206.57 rows=51 width=256) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=27,438.18..402,363.52 rows=772 width=256) (actual rows= loops=)

  • Hash Cond: (i.contractid = pbh.infoid)
3. 0.000 0.000 ↓ 0.0

Seq Scan on inventories i (cost=0.00..176,675.74 rows=203,065 width=2,486) (actual rows= loops=)

  • Filter: (status = 0)
4. 0.000 0.000 ↓ 0.0

Hash (cost=27,428.53..27,428.53 rows=772 width=256) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on paidbillshistory pbh (cost=24,468.26..27,428.53 rows=772 width=256) (actual rows= loops=)

  • Recheck Cond: ((invoicedate >= '2019-11-01'::date) AND (invoicedate < '2019-12-02'::date) AND (glid = 322) AND (typeid = 3))
  • Filter: ((vendorid > '-1'::integer) AND (directbilling = 1))
6. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=24,468.26..24,468.26 rows=772 width=0) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on pbh_invoicedate (cost=0.00..4,825.33 rows=109,690 width=0) (actual rows= loops=)

  • Index Cond: ((invoicedate >= '2019-11-01'::date) AND (invoicedate < '2019-12-02'::date))
8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on pbh_glid (cost=0.00..6,790.53 rows=165,613 width=0) (actual rows= loops=)

  • Index Cond: (glid = 322)
9. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on pbh_typeid (cost=0.00..12,851.32 rows=313,452 width=0) (actual rows= loops=)

  • Index Cond: (typeid = 3)