explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l6l9 : temp_view

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

Aggregate (cost=10,140.64..10,140.66 rows=1 width=32) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=5,579.02..9,948.10 rows=19,254 width=16) (actual rows= loops=)

  • Hash Cond: ((mmi.portfolio_id = monthly_merchant_metadata.portfolio_id) AND (mmi.merchant_id = monthly_merchant_metadata.merchant_id))
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on monthly_merchant_misc mmi (cost=1,069.41..5,256.26 rows=34,708 width=40) (actual rows= loops=)

  • Recheck Cond: (data_month_year = '2018-01-01'::date)
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on pk_monthly_merchant_misc (cost=0.00..1,060.73 rows=34,708 width=0) (actual rows= loops=)

  • Index Cond: (data_month_year = '2018-01-01'::date)
5. 0.000 0.000 ↓ 0.0

Hash (cost=3,995.49..3,995.49 rows=34,275 width=24) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on monthly_merchant_metadata (cost=1,058.05..3,995.49 rows=34,275 width=24) (actual rows= loops=)

  • Recheck Cond: (data_month_year = '2018-01-01'::date)
7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on pk_monthly_merchant_metadata (cost=0.00..1,049.48 rows=34,275 width=0) (actual rows= loops=)

  • Index Cond: (data_month_year = '2018-01-01'::date)