explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wuHTb : 1

Settings
# exclusive inclusive rows x rows loops node
1. 2,171.079 425,464.002 ↑ 3.6 18,728 3

Parallel Hash Left Join (cost=956,571.67..6,696,473.79 rows=67,599 width=115) (actual time=141,216.708..141,821.334 rows=18,728 loops=3)

  • Hash Cond: ((rc.mkt_id)::numeric = h.market_id)
2. 4,945.878 419,338.737 ↑ 3.4 18,400 3

Parallel Hash Left Join (cost=709,072.00..6,399,905.99 rows=63,016 width=56) (actual time=138,276.406..139,779.579 rows=18,400 loops=3)

  • Hash Cond: (((rc.mkt_id)::numeric = rstat.market_id) AND (rc.id = rstat.runner_id))
3. 401,787.285 401,787.285 ↑ 2.8 18,400 3

Parallel Seq Scan on fb_runner_changes rc (cost=0.00..4,763,818.12 rows=51,890 width=36) (actual time=39,795.606..133,929.095 rows=18,400 loops=3)

  • Filter: (("timestamp" >= '2016-02-18 00:00:00'::timestamp without time zone) AND ("timestamp" <= '2016-02-19 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 95,381,897
4. 7,585.962 12,605.574 ↑ 1.3 11,153,431 3

Parallel Hash (cost=418,254.00..418,254.00 rows=13,941,800 width=20) (actual time=4,201.858..4,201.858 rows=11,153,431 loops=3)

  • Buckets: 1,048,576 Batches: 32 Memory Usage: 65,632kB
5. 5,019.612 5,019.612 ↑ 1.3 11,153,431 3

Parallel Seq Scan on fb_runners rstat (cost=0.00..418,254.00 rows=13,941,800 width=20) (actual time=0.054..1,673.204 rows=11,153,431 loops=3)

6. 2,691.024 3,954.186 ↑ 1.3 2,730,416 3

Parallel Hash (cost=158,125.74..158,125.74 rows=3,414,874 width=81) (actual time=1,318.062..1,318.062 rows=2,730,416 loops=3)

  • Buckets: 524,288 Batches: 16 Memory Usage: 63,904kB
7. 1,263.162 1,263.162 ↑ 1.3 2,730,416 3

Parallel Seq Scan on fb_historical h (cost=0.00..158,125.74 rows=3,414,874 width=81) (actual time=0.012..421.054 rows=2,730,416 loops=3)