explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UenU

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 5,703.751 ↑ 5.7 7,048 1

Finalize GroupAggregate (cost=1,163,066.97..1,175,700.96 rows=40,000 width=200) (actual time=5,671.077..5,703.751 rows=7,048 loops=1)

  • Group Key: stat_d1588_201910.domain_id, stat_d1588_201910.post_id
2. 165.524 5,829.557 ↑ 5.0 16,120 1

Gather Merge (cost=1,163,066.97..1,172,400.96 rows=80,000 width=136) (actual time=5,670.934..5,829.557 rows=16,120 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 2.726 5,664.033 ↑ 7.4 5,373 3 / 3

Sort (cost=1,162,066.95..1,162,166.95 rows=40,000 width=136) (actual time=5,663.483..5,664.033 rows=5,373 loops=3)

  • Sort Key: stat_d1588_201910.post_id
  • Sort Method: quicksort Memory: 972kB
  • Worker 0: Sort Method: quicksort Memory: 927kB
  • Worker 1: Sort Method: quicksort Memory: 946kB
4. 1,090.395 5,661.307 ↑ 7.4 5,373 3 / 3

Partial HashAggregate (cost=1,158,209.40..1,159,009.40 rows=40,000 width=136) (actual time=5,653.941..5,661.307 rows=5,373 loops=3)

  • Group Key: stat_d1588_201910.domain_id, stat_d1588_201910.post_id
5. 42.249 4,570.912 ↑ 1.3 421,250 3 / 3

Parallel Append (cost=0.00..1,090,928.04 rows=527,697 width=64) (actual time=0.075..4,570.912 rows=421,250 loops=3)

6. 1,111.074 1,111.074 ↓ 2.4 558,328 1 / 3

Parallel Seq Scan on stat_d1588_201910 (cost=0.00..269,612.45 rows=229,651 width=64) (actual time=0.044..3,333.223 rows=558,328 loops=1)

  • Filter: ((create_date >= '2019-09-01'::date) AND (create_date <= '2019-10-31'::date) AND (stat_date >= '2019-09-01'::date) AND (stat_date <= '2020-01-28'::date) AND (domain_id = 1588) AND (exclude_traffic <> ALL ('{1,3,2}'::integer[])))
  • Rows Removed by Filter: 1961112
7. 982.067 982.067 ↓ 2.5 361,228 1 / 3

Parallel Seq Scan on stat_d1588_201909 (cost=0.00..231,933.19 rows=146,596 width=64) (actual time=0.162..2,946.202 rows=361,228 loops=1)

  • Filter: ((create_date >= '2019-09-01'::date) AND (create_date <= '2019-10-31'::date) AND (stat_date >= '2019-09-01'::date) AND (stat_date <= '2020-01-28'::date) AND (domain_id = 1588) AND (exclude_traffic <> ALL ('{1,3,2}'::integer[])))
  • Rows Removed by Filter: 1789768
8. 770.078 770.078 ↑ 1.3 27,076 3 / 3

Parallel Seq Scan on stat_d1588_202001 (cost=0.00..226,421.57 rows=35,368 width=64) (actual time=0.067..770.078 rows=27,076 loops=3)

  • Filter: ((create_date >= '2019-09-01'::date) AND (create_date <= '2019-10-31'::date) AND (stat_date >= '2019-09-01'::date) AND (stat_date <= '2020-01-28'::date) AND (domain_id = 1588) AND (exclude_traffic <> ALL ('{1,3,2}'::integer[])))
  • Rows Removed by Filter: 1116003
9. 711.304 711.304 ↓ 1.1 48,482 2 / 3

Parallel Seq Scan on stat_d1588_201912 (cost=0.00..194,691.99 rows=44,772 width=64) (actual time=0.044..1,066.956 rows=48,482 loops=2)

  • Filter: ((create_date >= '2019-09-01'::date) AND (create_date <= '2019-10-31'::date) AND (stat_date >= '2019-09-01'::date) AND (stat_date <= '2020-01-28'::date) AND (domain_id = 1588) AND (exclude_traffic <> ALL ('{1,3,2}'::integer[])))
  • Rows Removed by Filter: 1396570
10. 954.139 954.139 ↓ 2.3 166,002 1 / 3

Parallel Seq Scan on stat_d1588_201911 (cost=0.00..165,630.35 rows=71,310 width=64) (actual time=0.014..2,862.418 rows=166,002 loops=1)

  • Filter: ((create_date >= '2019-09-01'::date) AND (create_date <= '2019-10-31'::date) AND (stat_date >= '2019-09-01'::date) AND (stat_date <= '2020-01-28'::date) AND (domain_id = 1588) AND (exclude_traffic <> ALL ('{1,3,2}'::integer[])))
  • Rows Removed by Filter: 2234994
Planning time : 4.063 ms
Execution time : 5,863.747 ms