explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m6Bj

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 640.357 ↓ 0.0 141 1

Custom Scan (Citus Router) (cost=0.00..0.00 rows=0 width=0) (actual time=640.351..640.357 rows=141 loops=1)

  • Task Count: 1
  • Tasks Shown: All
  • -> Task
  • Node: host=ec2-3-91-129-165.compute-1.amazonaws.com port=5432 dbname=citus
  • Planning time: 0.436 ms
  • Execution time: 722.794 ms
  • Planning time: 0.359 ms
  • Execution time: 640.385 ms
2. 0.064 722.674 ↑ 13.0 141 1

Finalize GroupAggregate (cost=116,212.90..116,258.85 rows=1,838 width=16) (actual time=722.596..722.674 rows=141 loops=1)

  • Group Key: meetings.company_user_id
3. 0.044 722.610 ↑ 8.8 418 1

Sort (cost=116,212.90..116,222.09 rows=3,676 width=16) (actual time=722.592..722.610 rows=418 loops=1)

  • Sort Key: meetings.company_user_id
  • Sort Method: quicksort Memory: 44kB
4. 15.314 722.566 ↑ 8.8 418 1

Gather (cost=115,609.22..115,995.20 rows=3,676 width=16) (actual time=722.416..722.566 rows=418 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 29.295 707.252 ↑ 13.2 139 3

Partial HashAggregate (cost=114,609.22..114,627.60 rows=1,838 width=16) (actual time=707.213..707.252 rows=139 loops=3)

  • Group Key: meetings.company_user_id
6. 100.424 677.957 ↓ 3.6 78,217 3

Merge Join (cost=30,440.08..114,500.65 rows=21,715 width=8) (actual time=356.826..677.957 rows=78,217 loops=3)

  • Merge Cond: (meetings.id = entity_associations.source_entity_id)
7. 35.487 219.206 ↑ 1.4 32,769 3

Sort (cost=30,439.47..30,557.62 rows=47,261 width=24) (actual time=205.097..219.206 rows=32,769 loops=3)

  • Sort Key: meetings.id
  • Sort Method: quicksort Memory: 2656kB
8. 183.719 183.719 ↑ 1.4 32,769 3

Parallel Seq Scan on meetings_108749 meetings (cost=0.00..26,770.04 rows=47,261 width=24) (actual time=0.019..183.719 rows=32,769 loops=3)

  • Filter: ((end_time >= '2017-08-04 00:00:00+00'::timestamp with time zone) AND (end_time <= '2018-09-04 23:59:59.999999+00'::timestamp with time zone) AND (company_id = 2928))
  • Rows Removed by Filter: 165678
9. 358.327 358.327 ↓ 1.6 439,518 3

Index Only Scan using entity_associations_source_to_target_107725 on entity_associations_107725 entity_associations (cost=0.56..231,638.15 rows=273,549 width=16) (actual time=0.064..358.327 rows=439,518 loops=3)

  • Index Cond: ((company_id = 2928) AND (source_entity_type = 27))
  • Heap Fetches: 283995