explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fTER

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

Custom Scan (Citus Router) (cost=0.00..0.00 rows=0 width=0) (actual time=1,152.524..1,152.529 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.782 ms
  • Execution time: 2568.744 ms
2. 0.090 2,568.059 ↑ 12.7 141 1

Finalize GroupAggregate (cost=29,837.22..30,076.29 rows=1,792 width=16) (actual time=2,460.523..2,568.059 rows=141 loops=1)

  • Group Key: meetings.company_user_id
3. 0.000 2,567.969 ↑ 4.1 416 1

Gather Merge (cost=29,837.22..30,049.81 rows=1,712 width=16) (actual time=2,460.360..2,567.969 rows=416 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 182.259 7,583.928 ↑ 6.2 139 3

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

  • Group Key: meetings.company_user_id
5. 346.572 7,401.669 ↓ 62.3 53,354 3

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

  • Sort Key: meetings.company_user_id
  • Sort Method: quicksort Memory: 3926kB
6. 815.454 7,055.097 ↓ 62.3 53,354 3

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

7. 1,298.163 1,298.163 ↓ 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.028..432.721 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: 78268
8. 4,941.480 4,941.480 ↓ 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.015..0.015 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