explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jsK8

Settings
# exclusive inclusive rows x rows loops node
1. 1,356.620 1,738.204 ↑ 1.0 1 1

Aggregate (cost=48,889.69..48,889.70 rows=1 width=32) (actual time=1,738.203..1,738.204 rows=1 loops=1)

2.          

CTE objdb

3. 147.100 147.100 ↓ 4.5 115,821 1

Index Scan using report_analytic_portfolio_date_loan_id_uniq on report_analytic_portfolio (cost=0.43..48,239.06 rows=26,025 width=160) (actual time=0.024..147.100 rows=115,821 loops=1)

  • Index Cond: (date = '2018-11-30'::date)
4. 381.584 381.584 ↓ 4.5 115,821 1

CTE Scan on objdb (cost=0.00..520.50 rows=26,025 width=24) (actual time=0.035..381.584 rows=115,821 loops=1)