explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wxW

Settings
# exclusive inclusive rows x rows loops node
1. 805.567 122,990.558 ↑ 1.3 39 1

HashAggregate (cost=160,438.07..160,438.58 rows=51 width=32) (actual time=122,990.546..122,990.558 rows=39 loops=1)

  • Group Key: comm_flds.name, evs.company_id
2. 824.093 122,184.991 ↓ 22.3 2,702,679 1

Gather (cost=142,891.40..159,831.22 rows=121,370 width=32) (actual time=119,140.470..122,184.991 rows=2,702,679 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 22,575.038 121,360.898 ↓ 17.8 540,536 5

Merge Join (cost=141,891.40..146,694.22 rows=30,342 width=32) (actual time=119,133.136..121,360.898 rows=540,536 loops=5)

  • Merge Cond: (comm.comm_id = comm_flds.comm_id)
4. 29.828 869.157 ↓ 1.0 53,131 5

Sort (cost=92,582.29..92,712.16 rows=51,945 width=16) (actual time=861.104..869.157 rows=53,131 loops=5)

  • Sort Key: comm.comm_id
  • Sort Method: quicksort Memory: 4332kB
5. 373.437 839.329 ↓ 1.0 53,131 5

Nested Loop (cost=0.85..88,513.78 rows=51,945 width=16) (actual time=108.628..839.329 rows=53,131 loops=5)

6. 465.886 465.886 ↓ 1.0 53,131 5

Parallel Index Scan using idx_evs_cdate on evs (cost=0.43..55,136.06 rows=50,771 width=16) (actual time=60.824..465.886 rows=53,131 loops=5)

  • Index Cond: (creation_date > '2019-02-03 09:14:01.649+00'::timestamp with time zone)
7. 0.006 0.006 ↑ 1.0 1 265,655

Index Scan using comm_comm_ev_id_pidx on comm (cost=0.43..0.66 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=265,655)

  • Index Cond: (comm_ev_id = evs.ev_id)
8. 97,916.703 97,916.703 ↓ 164.6 185,207,227 5

Index Scan using comm_flds_name_left_xappprop_pidx on comm_flds (cost=0.57..50,798.59 rows=1,125,204 width=32) (actual time=0.090..97,916.703 rows=185,207,227 loops=5)