explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 114a

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

Custom Scan (Citus Router) (cost=0.00..0.00 rows=0 width=0) (actual time=509.666..509.672 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.452 ms
  • Execution time: 932.711 ms
  • Planning time: 0.370 ms
  • Execution time: 509.698 ms
2. 0.133 931.093 ↑ 13.0 141 1

Finalize GroupAggregate (cost=115,021.53..115,067.48 rows=1,838 width=16) (actual time=930.939..931.093 rows=141 loops=1)

  • Group Key: meetings.company_user_id
3. 0.000 930.960 ↑ 8.8 417 1

Sort (cost=115,021.53..115,030.72 rows=3,676 width=16) (actual time=930.922..930.960 rows=417 loops=1)

  • Sort Key: meetings.company_user_id
  • Sort Method: quicksort Memory: 44kB
4. 62.467 932.072 ↑ 8.8 417 1

Gather (cost=114,417.86..114,803.84 rows=3,676 width=16) (actual time=768.790..932.072 rows=417 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 53.978 869.605 ↑ 13.2 139 3

Partial HashAggregate (cost=113,417.86..113,436.24 rows=1,838 width=16) (actual time=869.559..869.605 rows=139 loops=3)

  • Group Key: meetings.company_user_id
6. 126.970 815.627 ↓ 3.6 78,217 3

Merge Join (cost=29,248.71..113,309.29 rows=21,715 width=8) (actual time=352.943..815.627 rows=78,217 loops=3)

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

Sort (cost=29,248.10..29,366.25 rows=47,261 width=24) (actual time=88.731..96.389 rows=32,769 loops=3)

  • Sort Key: meetings.id
  • Sort Method: quicksort Memory: 2624kB
8. 40.404 65.565 ↑ 1.4 32,769 3

Parallel Bitmap Heap Scan on meetings_108749 meetings (cost=2,322.61..25,578.67 rows=47,261 width=24) (actual time=24.397..65.565 rows=32,769 loops=3)

  • Recheck Cond: ((company_id = 2928) AND (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))
  • Heap Blocks: exact=3138
9. 25.161 25.161 ↑ 1.2 98,308 1

Bitmap Index Scan on temp_activity_report_index_108749 (cost=0.00..2,294.25 rows=113,426 width=0) (actual time=25.161..25.161 rows=98,308 loops=1)

  • Index Cond: ((company_id = 2928) AND (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))
10. 592.268 592.268 ↓ 1.6 439,510 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.053..592.268 rows=439,510 loops=3)

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