explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xfbv

Settings
# exclusive inclusive rows x rows loops node
1. 547.180 1,037.774 ↓ 0.0 1 1

Custom Scan (Citus Router) (cost=0.00..0.00 rows=0 width=0) (actual time=1,037.773..1,037.774 rows=1 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.453 ms
  • Execution time: 490.647 ms
  • Planning time: 0.524 ms
  • Execution time: 1037.797 ms
2. 2.454 490.594 ↑ 1.0 1 1

Limit (cost=12,489.03..12,489.04 rows=1 width=91) (actual time=488.141..490.594 rows=1 loops=1)

3. 0.000 488.140 ↑ 1.0 1 1

Sort (cost=12,489.03..12,489.04 rows=1 width=91) (actual time=488.140..488.140 rows=1 loops=1)

  • Sort Key: meetings.start_time
  • Sort Method: top-N heapsort Memory: 25kB
4. 4.983 490.491 ↓ 138.0 138 1

Gather (cost=2,241.25..12,489.02 rows=1 width=91) (actual time=186.741..490.491 rows=138 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
5. 353.372 485.508 ↓ 69.0 69 2

Nested Loop (cost=1,241.25..11,488.92 rows=1 width=91) (actual time=184.610..485.508 rows=69 loops=2)

6. 102.338 132.133 ↓ 70.4 103,032 2

Parallel Bitmap Heap Scan on entity_associations_107725 entity_associations (cost=1,240.82..6,002.85 rows=1,463 width=16) (actual time=41.536..132.133 rows=103,032 loops=2)

  • Recheck Cond: ((company_id = 2928) AND (target_entity_type = 21) AND (source_entity_type = 27))
  • Heap Blocks: exact=31797
7. 29.795 29.795 ↓ 83.7 208,147 1

Bitmap Index Scan on entity_associations_target_to_source_107725 (cost=0.00..1,240.20 rows=2,487 width=0) (actual time=29.795..29.795 rows=208,147 loops=1)

  • Index Cond: ((company_id = 2928) AND (target_entity_type = 21) AND (source_entity_type = 27))
8. 0.003 0.003 ↓ 0.0 0 206,065

Index Scan using virtual_pkey_a_id_meetings_108749 on meetings_108749 meetings (cost=0.42..3.75 rows=1 width=99) (actual time=0.003..0.003 rows=0 loops=206,065)

  • Index Cond: (id = entity_associations.source_entity_id)
  • Filter: ((start_time > '2019-01-30 22:11:06.662898'::timestamp without time zone) AND (company_id = 2928) AND (company_user_id = 81905))
  • Rows Removed by Filter: 1