explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nDz

Settings
# exclusive inclusive rows x rows loops node
1. 1.069 1,036,231.564 ↑ 3.6 295 1

Unique (cost=125,776,682.47..125,776,695.65 rows=1,055 width=219) (actual time=1,036,230.069..1,036,231.564 rows=295 loops=1)

2. 42.317 1,036,230.495 ↓ 5.8 6,080 1

Sort (cost=125,776,682.47..125,776,685.10 rows=1,055 width=219) (actual time=1,036,230.067..1,036,230.495 rows=6,080 loops=1)

  • Sort Key: e.model_name, (date(e.start_time)), e.reconcile_id, d.original_member
  • Sort Method: quicksort Memory: 1,812kB
3. 7,035.095 1,036,188.178 ↓ 5.8 6,080 1

Nested Loop (cost=1,000.00..125,776,629.49 rows=1,055 width=219) (actual time=1,026,081.328..1,036,188.178 rows=6,080 loops=1)

  • Join Filter: ((d.reconcile_id)::text = (e.reconcile_id)::text)
  • Rows Removed by Join Filter: 95,024,320
4. 11.363 11.363 ↓ 1.0 15,630 1

Seq Scan on reconcile_log_execution e (cost=0.00..3,868.22 rows=15,622 width=47) (actual time=0.015..11.363 rows=15,630 loops=1)

5. 3,621.700 1,029,141.720 ↓ 5.8 6,080 15,630

Materialize (cost=1,000.00..125,525,543.12 rows=1,055 width=190) (actual time=2.206..65.844 rows=6,080 loops=15,630)

6. 13.927 1,025,520.020 ↓ 5.8 6,080 1

Gather (cost=1,000.00..125,525,537.84 rows=1,055 width=190) (actual time=34,473.795..1,025,520.020 rows=6,080 loops=1)

  • Workers Planned: 11
  • Workers Launched: 11
7. 1,025,506.093 1,025,506.093 ↓ 5.3 507 12 / 12

Parallel Seq Scan on reconcile_log_details d (cost=0.00..125,524,432.34 rows=96 width=190) (actual time=49,534.037..1,025,506.093 rows=507 loops=12)

  • Filter: ((old_member_id)::text = ':Year_445_7:7,421,161'::text)
  • Rows Removed by Filter: 69,331,124
Planning time : 0.649 ms