explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qHig

Settings
# exclusive inclusive rows x rows loops node
1. 55.299 640.884 ↑ 2.6 16 1

Gather (cost=88,412.23..96,480.83 rows=41 width=62) (actual time=549.782..640.884 rows=16 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 58.682 585.585 ↑ 3.4 5 3 / 3

Merge Join (cost=87,412.23..95,476.61 rows=17 width=62) (actual time=557.868..585.585 rows=5 loops=3)

  • Merge Cond: (h.c60987_activityid = t10562_emaildistinctactivitydomains.c60761_activityid)
  • Join Filter: (((t10562_emaildistinctactivitydomains.start_stamp > '1558418795069'::bigint) AND (t10562_emaildistinctactivitydomains.start_stamp <= '1558818795069'::bigint) AND (h.start_stamp <= t10562_emaildistinctactivitydomains.start_stamp) AND (h.end_stamp > t10562_emaildistinctactivitydomains.start_stamp)) OR ((h.start_stamp > '1558418795069'::bigint) AND (h.start_stamp <= '1558818795069'::bigint) AND (t10562_emaildistinctactivitydomains.start_stamp <= h.start_stamp) AND (t10562_emaildistinctactivitydomains.end_stamp > h.start_stamp)))
  • Rows Removed by Join Filter: 95,501
3. 111.810 184.841 ↑ 1.3 127,225 3 / 3

Sort (cost=40,006.79..40,406.11 rows=159,726 width=33) (actual time=168.747..184.841 rows=127,225 loops=3)

  • Sort Key: h.c60987_activityid
  • Sort Method: external merge Disk: 4,816kB
4. 73.031 73.031 ↑ 1.3 127,225 3 / 3

Parallel Seq Scan on t10763_emaildomainactivityaccounthierarchy h (cost=0.00..21,834.28 rows=159,726 width=33) (actual time=0.006..73.031 rows=127,225 loops=3)

  • Filter: ((c60988_activitydomainsid IS NULL) OR (c60988_activitydomainsid = 12))
  • Rows Removed by Filter: 237,418
5. 30.235 342.062 ↓ 1.0 286,512 3 / 3

Materialize (cost=47,405.30..48,824.43 rows=283,825 width=28) (actual time=269.318..342.062 rows=286,512 loops=3)

6. 191.351 311.827 ↓ 1.0 286,512 3 / 3

Sort (cost=47,405.30..48,114.86 rows=283,825 width=28) (actual time=269.313..311.827 rows=286,512 loops=3)

  • Sort Key: t10562_emaildistinctactivitydomains.c60761_activityid
  • Sort Method: external merge Disk: 10,664kB
7. 120.476 120.476 ↓ 1.0 286,519 3 / 3

Seq Scan on t10562_emaildistinctactivitydomains (cost=0.00..14,904.86 rows=283,825 width=28) (actual time=3.398..120.476 rows=286,519 loops=3)

  • Filter: ((NOT deleted) AND (NOT c60762_customdeletedparticipant))
  • Rows Removed by Filter: 380,459
Planning time : 0.644 ms
Execution time : 643.263 ms