explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Sycr

Settings
# exclusive inclusive rows x rows loops node
1. 51.480 51.557 ↓ 0.0 0 1

Gather (cost=1,897.86..29,488.10 rows=1 width=62) (actual time=48.141..51.557 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.001 0.077 ↓ 0.0 0 3 / 3

Hash Join (cost=897.86..28,488.00 rows=1 width=62) (actual time=0.077..0.077 rows=0 loops=3)

  • Hash Cond: (h.c7798_accountdomainsid = t1402_accountdomaindistinct.c7147_domainsid)
  • Join Filter: (((t1402_accountdomaindistinct.start_stamp > '1558418973263'::bigint) AND (t1402_accountdomaindistinct.start_stamp <= '1558429040077'::bigint) AND (h.start_stamp <= t1402_accountdomaindistinct.start_stamp) AND (h.end_stamp > t1402_accountdomaindistinct.start_stamp)) OR ((h.start_stamp > '1558418973263'::bigint) AND (h.start_stamp <= '1558529040077'::bigint) AND (t1402_accountdomaindistinct.start_stamp <= h.start_stamp) AND (t1402_accountdomaindistinct.end_stamp > h.start_stamp)))
3. 0.070 0.076 ↓ 0.0 0 3 / 3

Parallel Bitmap Heap Scan on t1665_emaildomainactivityaccounthierarchy h (cost=204.07..26,799.87 rows=3,069 width=37) (actual time=0.076..0.076 rows=0 loops=3)

  • Recheck Cond: ((sid IS NULL) OR (sid = 53))
4. 0.000 0.006 ↓ 0.0 0 1 / 3

BitmapOr (cost=204.07..204.07 rows=7,366 width=0) (actual time=0.018..0.018 rows=0 loops=1)

5. 0.003 0.003 ↓ 0.0 0 1 / 3

Bitmap Index Scan on idx_1422_t1665_emaildomainactivityaccounthierarchy_sid_end_stam (cost=0.00..4.57 rows=1 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (sid IS NULL)
6. 0.003 0.003 ↓ 0.0 0 1 / 3

Bitmap Index Scan on t1665_emaildomainactivityaccounthierarchy_sidendstamp (cost=0.00..195.81 rows=7,366 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (sid = 53)
7. 0.000 0.000 ↓ 0.0 0 / 3

Hash (cost=457.82..457.82 rows=18,878 width=28) (never executed)

8. 0.000 0.000 ↓ 0.0 0 / 3

Seq Scan on t1402_accountdomaindistinct (cost=0.00..457.82 rows=18,878 width=28) (never executed)

  • Filter: (NOT deleted)