explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mv99

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,654.847 ↓ 0.0 141 1

Custom Scan (Citus Router) (cost=0.00..0.00 rows=0 width=0) (actual time=2,654.841..2,654.847 rows=141 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.803 ms
  • Execution time: 2871.710 ms
  • Planning time: 0.429 ms
  • Execution time: 2654.873 ms
2. 0.134 2,865.513 ↑ 12.7 141 1

Finalize GroupAggregate (cost=56,281.20..56,326.00 rows=1,792 width=16) (actual time=2,865.335..2,865.513 rows=141 loops=1)

  • Group Key: meetings.company_user_id
3. 0.000 2,865.379 ↑ 8.6 419 1

Sort (cost=56,281.20..56,290.16 rows=3,584 width=16) (actual time=2,865.324..2,865.379 rows=419 loops=1)

  • Sort Key: meetings.company_user_id
  • Sort Method: quicksort Memory: 44kB
4. 96.486 2,870.784 ↑ 8.6 419 1

Gather (cost=55,693.29..56,069.61 rows=3,584 width=16) (actual time=2,738.107..2,870.784 rows=419 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 131.024 2,774.298 ↑ 12.8 140 3

Partial HashAggregate (cost=54,693.29..54,711.21 rows=1,792 width=16) (actual time=2,774.226..2,774.298 rows=140 loops=3)

  • Group Key: meetings.company_user_id
6. 368.606 2,643.274 ↓ 3.7 78,215 3

Merge Join (cost=30,400.40..54,587.79 rows=21,100 width=8) (actual time=1,322.632..2,643.274 rows=78,215 loops=3)

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

Sort (cost=30,399.79..30,518.31 rows=47,410 width=24) (actual time=889.538..921.579 rows=32,769 loops=3)

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

Parallel Seq Scan on meetings_108749 meetings (cost=0.00..26,717.71 rows=47,410 width=24) (actual time=0.059..821.888 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: 166139
9. 1,353.089 1,353.089 ↓ 1.7 438,089 3

Index Only Scan using entity_associations_source_to_target_107725 on entity_associations_107725 entity_associations (cost=0.56..65,910.75 rows=261,762 width=16) (actual time=0.087..1,353.089 rows=438,089 loops=3)

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