explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2q2

Settings
# exclusive inclusive rows x rows loops node
1. 739.695 83,913.610 ↑ 1.3 39 1

HashAggregate (cost=162,906.60..162,907.11 rows=51 width=32) (actual time=83,913.602..83,913.610 rows=39 loops=1)

  • Group Key: comm_flds.name, evs.company_id
2. 1,139.615 83,173.915 ↓ 22.7 2,763,305 1

Gather (cost=145,585.18..162,299.28 rows=121,464 width=32) (actual time=80,079.312..83,173.915 rows=2,763,305 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
3. 18,252.500 82,034.300 ↓ 17.6 690,826 4

Merge Join (cost=144,585.18..149,152.88 rows=39,182 width=32) (actual time=80,135.631..82,034.300 rows=690,826 loops=4)

  • Merge Cond: (comm.comm_id = comm_flds.comm_id)
4. 34.142 1,177.470 ↓ 1.0 67,902 4

Sort (cost=99,649.91..99,818.10 rows=67,279 width=16) (actual time=1,168.366..1,177.470 rows=67,902 loops=4)

  • Sort Key: comm.comm_id
  • Sort Method: quicksort Memory: 4367kB
5. 422.653 1,143.328 ↓ 1.0 67,902 4

Hash Join (cost=58,492.18..94,254.85 rows=67,279 width=16) (actual time=886.646..1,143.328 rows=67,902 loops=4)

  • Hash Cond: (comm.comm_ev_id = evs.ev_id)
6. 212.402 212.402 ↑ 1.3 483,204 4

Parallel Seq Scan on comm (cost=0.00..27,014.65 rows=623,628 width=16) (actual time=0.051..212.402 rows=483,204 loops=4)

  • Filter: ((comm_type)::text = 'EVENT'::text)
  • Rows Removed by Filter: 78
7. 134.470 508.273 ↓ 1.3 271,608 4

Hash (cost=54,865.35..54,865.35 rows=208,626 width=16) (actual time=508.273..508.273 rows=271,608 loops=4)

  • Buckets: 262144 (originally 262144) Batches: 4 (originally 2) Memory Usage: 6145kB
8. 373.803 373.803 ↓ 1.3 271,608 4

Index Scan using idx_evs_cdate on evs (cost=0.43..54,865.35 rows=208,626 width=16) (actual time=0.077..373.803 rows=271,608 loops=4)

  • Index Cond: (creation_date > '2019-02-03 09:14:01.649+00'::timestamp with time zone)
9. 62,604.330 62,604.330 ↓ 164.5 185,267,857 4

Index Scan using comm_flds_name_left_xappprop_pidx on comm_flds (cost=0.57..46,040.94 rows=1,126,074 width=32) (actual time=0.084..62,604.330 rows=185,267,857 loops=4)