explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y2uy

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 43,809.946 ↑ 5.8 6,920 1

Finalize GroupAggregate (cost=988,108.43..999,742.41 rows=40,000 width=136) (actual time=43,794.068..43,809.946 rows=6,920 loops=1)

  • Group Key: a_1.domain_id, a_1.post_id
2. 163.847 43,951.610 ↑ 5.2 15,491 1

Gather Merge (cost=988,108.43..997,442.41 rows=80,000 width=72) (actual time=43,793.289..43,951.610 rows=15,491 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 2.514 43,787.763 ↑ 7.7 5,164 3 / 3

Sort (cost=987,108.41..987,208.41 rows=40,000 width=72) (actual time=43,787.321..43,787.763 rows=5,164 loops=3)

  • Sort Key: a_1.post_id
  • Sort Method: quicksort Memory: 545kB
  • Worker 0: Sort Method: quicksort Memory: 652kB
  • Worker 1: Sort Method: quicksort Memory: 629kB
4. 117.457 43,785.249 ↑ 7.7 5,164 3 / 3

Partial HashAggregate (cost=983,450.86..984,050.86 rows=40,000 width=72) (actual time=43,780.385..43,785.249 rows=5,164 loops=3)

  • Group Key: a_1.domain_id, a_1.post_id
5. 20.957 43,667.792 ↑ 1.3 223,983 3 / 3

Parallel Append (cost=0.43..979,945.76 rows=280,408 width=20) (actual time=32.644..43,667.792 rows=223,983 loops=3)

6. 9,894.779 9,894.779 ↓ 2.3 276,265 1 / 3

Parallel Index Scan using stat_d1588_201910_exclude_traffic_idx on stat_d1588_201910 a_1 (cost=0.43..245,307.54 rows=119,009 width=20) (actual time=3.655..29,684.338 rows=276,265 loops=1)

  • Index Cond: (exclude_traffic = ANY ('{1,3,2}'::integer[]))
  • 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))
  • Rows Removed by Filter: 584116
7. 6,507.345 6,507.345 ↓ 2.2 183,242 1 / 3

Parallel Index Scan using stat_d1588_201909_exclude_traffic_idx on stat_d1588_201909 a (cost=0.43..216,389.97 rows=82,962 width=20) (actual time=88.524..19,522.036 rows=183,242 loops=1)

  • Index Cond: (exclude_traffic = ANY ('{1,3,2}'::integer[]))
  • 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))
  • Rows Removed by Filter: 585847
8. 3,323.260 3,323.260 ↓ 2.7 47,212 1 / 3

Parallel Index Scan using stat_d1588_202001_exclude_traffic_idx on stat_d1588_202001 a_4 (cost=0.43..194,757.24 rows=17,347 width=20) (actual time=4.542..9,969.781 rows=47,212 loops=1)

  • Index Cond: (exclude_traffic = ANY ('{1,3,2}'::integer[]))
  • 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))
  • Rows Removed by Filter: 1088961
9. 17,566.802 17,566.802 ↑ 1.2 19,531 3 / 3

Parallel Index Scan using stat_d1588_201912_exclude_traffic_idx on stat_d1588_201912 a_3 (cost=0.43..172,271.53 rows=23,168 width=20) (actual time=2.903..17,566.802 rows=19,531 loops=3)

  • Index Cond: (exclude_traffic = ANY ('{1,3,2}'::integer[]))
  • 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))
  • Rows Removed by Filter: 308687
10. 6,354.648 6,354.648 ↓ 2.8 106,635 1 / 3

Parallel Index Scan using stat_d1588_201911_exclude_traffic_idx on stat_d1588_201911 a_2 (cost=0.43..149,817.44 rows=37,922 width=20) (actual time=5.745..19,063.945 rows=106,635 loops=1)

  • Index Cond: (exclude_traffic = ANY ('{1,3,2}'::integer[]))
  • 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))
  • Rows Removed by Filter: 728229
Planning time : 0.798 ms
Execution time : 43,969.799 ms