explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vbs7

Settings
# exclusive inclusive rows x rows loops node
1. 1,112.893 3,139.541 ↓ 0.0 187 1

Custom Scan (Citus Router) (cost=0.00..0.00 rows=0 width=0) (actual time=3,139.534..3,139.541 rows=187 loops=1)

  • Task Count: 1
  • Tasks Shown: All
  • -> Task
  • Node: host=ec2-3-83-194-151.compute-1.amazonaws.com port=5432 dbname=citus
  • Planning time: 0.767 ms
  • Execution time: 2029.564 ms
  • Planning time: 0.534 ms
  • Execution time: 3139.574 ms
2. 0.000 2,026.648 ↑ 9.6 187 1

Finalize GroupAggregate (cost=29,870.91..30,351.87 rows=1,792 width=16) (actual time=1,948.764..2,026.648 rows=187 loops=1)

  • Group Key: meetings.company_user_id
3. 0.000 2,028.165 ↑ 6.4 557 1

Gather Merge (cost=29,870.91..30,316.03 rows=3,584 width=16) (actual time=1,948.511..2,028.165 rows=557 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 119.484 6,013.452 ↑ 9.6 186 3

Partial GroupAggregate (cost=28,870.88..28,902.33 rows=1,792 width=16) (actual time=1,930.969..2,004.484 rows=186 loops=3)

  • Group Key: meetings.company_user_id
5. 458.811 5,893.968 ↓ 60.9 109,811 3

Sort (cost=28,870.88..28,875.39 rows=1,803 width=8) (actual time=1,930.715..1,964.656 rows=109,811 loops=3)

  • Sort Key: meetings.company_user_id
  • Sort Method: quicksort Memory: 8381kB
6. 801.439 5,435.157 ↓ 60.9 109,811 3

Nested Loop (cost=0.99..28,773.38 rows=1,803 width=8) (actual time=0.046..1,811.719 rows=109,811 loops=3)

7. 1,339.398 1,339.398 ↓ 24.8 109,811 3

Parallel Index Only Scan using entity_associations_source_to_target_107725 on entity_associations_107725 entity_associations (cost=0.56..17,206.68 rows=4,425 width=8) (actual time=0.032..446.466 rows=109,811 loops=3)

  • Index Cond: ((company_id = 2928) AND (source_entity_type = 27) AND (target_entity_type = ANY ('{3,21}'::integer[])))
  • Heap Fetches: 80938
8. 3,294.320 3,294.320 ↑ 1.0 1 329,432

Index Scan using virtual_pkey_a_id_meetings_108749 on meetings_108749 meetings (cost=0.42..2.61 rows=1 width=16) (actual time=0.010..0.010 rows=1 loops=329,432)

  • Index Cond: (id = entity_associations.source_entity_id)
  • Filter: (company_id = 2928)