explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2Alw

Settings
# exclusive inclusive rows x rows loops node
1. 390.834 22,950.587 ↓ 0.0 0 1

Gather (cost=3,358,853.28..3,596,622.74 rows=1 width=62) (actual time=22,946.660..22,950.587 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 1,798.868 22,559.753 ↓ 0.0 0 3 / 3

Merge Join (cost=3,357,853.28..3,595,622.64 rows=1 width=62) (actual time=22,559.753..22,559.753 rows=0 loops=3)

  • Merge Cond: (h.c7802_activityid = t1915_emaildistinctactivitydomains.c8252_activityid)
  • Join Filter: (((t1915_emaildistinctactivitydomains.start_stamp > '1558418973263'::bigint) AND (t1915_emaildistinctactivitydomains.start_stamp <= '1558429040077'::bigint) AND (h.start_stamp <= t1915_emaildistinctactivitydomains.start_stamp) AND (h.end_stamp > t1915_emaildistinctactivitydomains.start_stamp)) OR ((h.start_stamp > '1558418973263'::bigint) AND (h.start_stamp <= '1558429040077'::bigint) AND (t1915_emaildistinctactivitydomains.start_stamp <= h.start_stamp) AND (t1915_emaildistinctactivitydomains.end_stamp > h.start_stamp)))
  • Rows Removed by Join Filter: 3,056,731
3. 3,398.652 5,747.505 ↑ 1.3 3,525,657 3 / 3

Sort (cost=1,412,067.19..1,423,237.06 rows=4,467,948 width=33) (actual time=5,190.272..5,747.505 rows=3,525,657 loops=3)

  • Sort Key: h.c7802_activityid
  • Sort Method: external merge Disk: 141,880kB
4. 2,348.853 2,348.853 ↑ 1.3 3,525,657 3 / 3

Parallel Seq Scan on t1665_emaildomainactivityaccounthierarchy h (cost=0.00..674,213.95 rows=4,467,948 width=33) (actual time=0.009..2,348.853 rows=3,525,657 loops=3)

  • Filter: ((c7804_activitydomainsid IS NULL) OR (c7804_activitydomainsid = 45))
  • Rows Removed by Filter: 8,437,980
5. 889.232 15,013.380 ↑ 1.0 9,167,532 3 / 3

Materialize (cost=1,945,781.47..1,992,014.25 rows=9,246,555 width=28) (actual time=12,779.432..15,013.380 rows=9,167,532 loops=3)

6. 10,752.487 14,124.148 ↑ 1.0 9,167,532 3 / 3

Sort (cost=1,945,781.47..1,968,897.86 rows=9,246,555 width=28) (actual time=12,779.423..14,124.148 rows=9,167,532 loops=3)

  • Sort Key: t1915_emaildistinctactivitydomains.c8252_activityid
  • Sort Method: external merge Disk: 342,712kB
7. 3,371.661 3,371.661 ↑ 1.0 9,215,142 3 / 3

Seq Scan on t1915_emaildistinctactivitydomains (cost=0.00..433,469.66 rows=9,246,555 width=28) (actual time=1,401.430..3,371.661 rows=9,215,142 loops=3)

  • Filter: ((NOT deleted) AND (NOT c8253_customdeletedparticipant))
  • Rows Removed by Filter: 10,183,150