explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VnSp

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 3,263.904 ↓ 0.0 141 1
→

Custom Scan (Citus Router) (cost=0.00..0.00 rows=0 width=0) (actual time=3,263.899..3,263.904 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.875 ms
  • Execution time: 3357.715 ms
2. 0.000 3,354.868 ↑ 12.7 141 1
→

Finalize GroupAggregate (cost=29,837.22..30,076.29 rows=1,792 width=16) (actual time=3,222.767..3,354.868 rows=141 loops=1)

  • Group Key: meetings.company_user_id
3. 0.000 3,356.815 ↑ 4.1 416 1
→

Gather Merge (cost=29,837.22..30,049.81 rows=1,712 width=16) (actual time=3,212.791..3,356.815 rows=416 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 80.805 9,703.941 ↑ 6.2 139 3
→

Partial GroupAggregate (cost=28,837.19..28,852.17 rows=856 width=16) (actual time=3,186.376..3,234.647 rows=139 loops=3)

  • Group Key: meetings.company_user_id
5. 340.806 9,623.136 ↓ 62.3 53,354 3
→

Sort (cost=28,837.19..28,839.33 rows=856 width=8) (actual time=3,186.284..3,207.712 rows=53,354 loops=3)

  • Sort Key: meetings.company_user_id
  • Sort Method: quicksort Memory: 4039kB
6. 922.391 9,282.330 ↓ 62.3 53,354 3
→

Nested Loop (cost=0.99..28,795.50 rows=856 width=8) (actual time=485.505..3,094.110 rows=53,354 loops=3)

7. 1,771.299 1,771.299 ↓ 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.040..590.433 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: 78745
8. 6,588.640 6,588.640 ↓ 0.0 0 329,432
→

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

  • Index Cond: (id = entity_associations.source_entity_id)
  • 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: 1