explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sgaO

Settings
# exclusive inclusive rows x rows loops node
1. 83.753 594.247 ↑ 2.4 21 1

HashAggregate (cost=64,191.28..64,191.79 rows=51 width=32) (actual time=594.244..594.247 rows=21 loops=1)

  • Group Key: comm_flds.name, evs.company_id
2. 47.778 510.494 ↓ 19.5 400,656 1

Gather (cost=12,166.18..64,088.43 rows=20,571 width=32) (actual time=293.321..510.494 rows=400,656 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
3. 233.660 462.716 ↓ 15.1 100,164 4

Nested Loop (cost=11,166.18..61,031.33 rows=6,636 width=32) (actual time=287.273..462.716 rows=100,164 loops=4)

4. 79.961 229.033 ↑ 1.2 9,658 4

Hash Join (cost=11,165.61..36,705.14 rows=11,401 width=16) (actual time=220.105..229.033 rows=9,658 loops=4)

  • Hash Cond: (comm.comm_ev_id = evs.ev_id)
5. 94.683 94.683 ↑ 1.3 483,158 4

Parallel Seq Scan on comm (cost=0.00..23,902.96 rows=623,455 width=16) (actual time=0.022..94.683 rows=483,158 loops=4)

  • Filter: ((comm_type)::text = 'EVENT'::text)
  • Rows Removed by Filter: 68
6. 9.244 54.389 ↓ 1.1 38,630 4

Hash (cost=10,723.85..10,723.85 rows=35,341 width=16) (actual time=54.389..54.389 rows=38,630 loops=4)

  • Buckets: 65536 Batches: 1 Memory Usage: 2323kB
7. 45.145 45.145 ↓ 1.1 38,630 4

Index Scan using idx_evs_cdate on evs (cost=0.43..10,723.85 rows=35,341 width=16) (actual time=0.061..45.145 rows=38,630 loops=4)

  • Index Cond: (creation_date > '2019-02-05 02:00:53.426-08'::timestamp with time zone)
8. 0.023 0.023 ↓ 2.0 10 38,630

Index Scan using comm_flds_name_left_xappprop_pidx on comm_flds (cost=0.57..2.08 rows=5 width=32) (actual time=0.019..0.023 rows=10 loops=38,630)

  • Index Cond: (comm_id = comm.comm_id)