explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FMB

Settings
# exclusive inclusive rows x rows loops node
1. 2,078.074 286,653.252 ↑ 1.1 47 1

HashAggregate (cost=206,947.96..206,948.47 rows=51 width=32) (actual time=286,653.243..286,653.252 rows=47 loops=1)

  • Group Key: comm_flds.name, evs.company_id
2. 41,928.805 284,575.178 ↓ 17.9 8,341,131 1

Hash Join (cost=117,949.01..204,614.83 rows=466,626 width=32) (actual time=213,178.304..284,575.178 rows=8,341,131 loops=1)

  • Hash Cond: (comm.comm_ev_id = evs.ev_id)
3. 18,284.162 127,205.822 ↓ 18.7 20,996,104 1

Merge Join (cost=44,017.54..108,435.59 rows=1,124,861 width=32) (actual time=72,781.894..127,205.822 rows=20,996,104 loops=1)

  • Merge Cond: (comm.comm_id = comm_flds.comm_id)
4. 24,465.137 24,465.137 ↓ 1.0 1,932,630 1

Index Scan using comm_pk on comm (cost=0.43..60,236.25 rows=1,932,580 width=16) (actual time=0.018..24,465.137 rows=1,932,630 loops=1)

  • Filter: ((comm_type)::text = 'EVENT'::text)
  • Rows Removed by Filter: 272
5. 84,456.523 84,456.523 ↓ 164.5 185,053,461 1

Index Scan using comm_flds_name_left_xappprop_pidx on comm_flds (cost=0.57..45,045.25 rows=1,125,048 width=32) (actual time=0.187..84,456.523 rows=185,053,461 loops=1)

6. 860.280 115,440.551 ↓ 1.0 819,291 1

Hash (cost=59,995.04..59,995.04 rows=801,714 width=16) (actual time=115,440.551..115,440.551 rows=819,291 loops=1)

  • Buckets: 262144 Batches: 8 Memory Usage: 6840kB
7. 114,580.271 114,580.271 ↓ 1.0 819,291 1

Index Scan using idx_evs_cdate on evs (cost=0.43..59,995.04 rows=801,714 width=16) (actual time=582.484..114,580.271 rows=819,291 loops=1)

  • Index Cond: (creation_date > '2019-01-31 18:54:01.464-08'::timestamp with time zone)