explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nUoN

Settings
# exclusive inclusive rows x rows loops node
1. 0.106 15.590 ↑ 1.0 1,000 1

Limit (cost=266.00..3,043,799.89 rows=1,000 width=8) (actual time=8.346..15.590 rows=1,000 loops=1)

2. 5.285 15.484 ↑ 25.8 1,000 1

Hash Join (cost=266.00..78,371,263.77 rows=25,750 width=8) (actual time=8.346..15.484 rows=1,000 loops=1)

  • Hash Cond: ((rcs.start_date = week."Effective Date") AND ((rcs.crm_id)::text = (week."Submitting BP ID")::text) AND (rcs.country_id = week.country_id))
3. 2.535 2.535 ↑ 2,102.0 17,500 1

Seq Scan on victory_lenovo_chan_man_all_records_complete_simulation rcs (cost=0.00..845,585.64 rows=36,785,364 width=76) (actual time=0.027..2.535 rows=17,500 loops=1)

4. 4.266 7.664 ↓ 2.4 13,421 1

Hash (cost=168.00..168.00 rows=5,600 width=68) (actual time=7.664..7.664 rows=13,421 loops=1)

5. 3.398 3.398 ↓ 2.4 13,421 1

Seq Scan on victory_lenovo_chan_man_week_records_simulation week (cost=0.00..168.00 rows=5,600 width=68) (actual time=0.012..3.398 rows=13,421 loops=1)