explain.depesz.com

PostgreSQL's explain analyze made readable

Result: afpp

Settings
# exclusive inclusive rows x rows loops node
1. 323.716 22,622.406 ↓ 7.4 112,985 1

Gather (cost=3,393,996.23..3,610,471.78 rows=15,353 width=62) (actual time=22,093.628..22,622.406 rows=112,985 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 1,662.046 22,298.690 ↓ 5.9 37,662 3 / 3

Merge Join (cost=3,392,996.23..3,607,891.70 rows=6,397 width=62) (actual time=22,135.599..22,298.690 rows=37,662 loops=3)

  • Merge Cond: (h.c8052_activityid = t1949_emaildistinctactivitydomains.c8293_activityid)
  • Join Filter: (((t1949_emaildistinctactivitydomains.start_stamp > '1558418795069'::bigint) AND (t1949_emaildistinctactivitydomains.start_stamp <= '1558818795069'::bigint) AND (h.start_stamp <= t1949_emaildistinctactivitydomains.start_stamp) AND (h.end_stamp > t1949_emaildistinctactivitydomains.start_stamp)) OR ((h.start_stamp > '1558418795069'::bigint) AND (h.start_stamp <= '1558818795069'::bigint) AND (t1949_emaildistinctactivitydomains.start_stamp <= h.start_stamp) AND (t1949_emaildistinctactivitydomains.end_stamp > h.start_stamp)))
  • Rows Removed by Join Filter: 3,029,536
3. 4,578.962 6,346.261 ↑ 1.3 3,537,608 3 / 3

Sort (cost=1,444,395.33..1,455,692.17 rows=4,518,733 width=33) (actual time=5,846.331..6,346.261 rows=3,537,608 loops=3)

  • Sort Key: h.c8052_activityid
  • Sort Method: external merge Disk: 154,984kB
4. 1,767.299 1,767.299 ↑ 1.3 3,537,608 3 / 3

Parallel Seq Scan on t1817_emaildomainactivityaccounthierarchy h (cost=0.00..697,785.18 rows=4,518,733 width=33) (actual time=0.006..1,767.299 rows=3,537,608 loops=3)

  • Filter: ((c8053_activitydomainsid IS NULL) OR (c8053_activitydomainsid = 12))
  • Rows Removed by Filter: 8,683,539
5. 826.959 14,290.383 ↑ 1.0 9,196,392 3 / 3

Materialize (cost=1,948,598.64..1,994,891.18 rows=9,258,508 width=28) (actual time=12,271.973..14,290.383 rows=9,196,392 loops=3)

6. 11,043.950 13,463.424 ↑ 1.0 9,196,392 3 / 3

Sort (cost=1,948,598.64..1,971,744.91 rows=9,258,508 width=28) (actual time=12,271.967..13,463.424 rows=9,196,392 loops=3)

  • Sort Key: t1949_emaildistinctactivitydomains.c8293_activityid
  • Sort Method: external merge Disk: 343,320kB
7. 2,419.474 2,419.474 ↑ 1.0 9,231,482 3 / 3

Seq Scan on t1949_emaildistinctactivitydomains (cost=0.00..434,243.56 rows=9,258,508 width=28) (actual time=976.655..2,419.474 rows=9,231,482 loops=3)

  • Filter: ((NOT deleted) AND (NOT c8294_customdeletedparticipant))
  • Rows Removed by Filter: 10,201,521
Planning time : 1.841 ms
Execution time : 22,702.709 ms