explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0vAI

Settings
# exclusive inclusive rows x rows loops node
1. 38.341 409.441 ↓ 27.0 42,536 1

Gather (cost=1,000.99..20,388.72 rows=1,573 width=8) (actual time=123.663..409.441 rows=42,536 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 293.840 371.100 ↓ 21.6 14,179 3

Nested Loop (cost=0.99..19,231.42 rows=655 width=8) (actual time=155.805..371.100 rows=14,179 loops=3)

3. 77.254 77.254 ↓ 12.1 41,125 3

Parallel Index Only Scan using entity_associations_source_to_target_107725 on entity_associations_107725 entity_associations (cost=0.56..9,529.29 rows=3,388 width=16) (actual time=0.027..77.254 rows=41,125 loops=3)

  • Index Cond: ((company_id = 2928) AND (source_entity_type = 27) AND (target_entity_type = 3))
  • Heap Fetches: 27412
4. 0.006 0.006 ↓ 0.0 0 123,376

Index Scan using virtual_pkey_a_id_meetings_108749 on meetings_108749 meetings (cost=0.42..2.86 rows=1 width=24) (actual time=0.006..0.006 rows=0 loops=123,376)

  • 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