explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WY6Z

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

Custom Scan (Citus Router) (cost=0.00..0.00 rows=0 width=0) (actual time=1,023.292..1,023.298 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.651 ms
  • Execution time: 1117.584 ms
2. 34.952 1,109.297 ↓ 141.0 141 1

GroupAggregate (cost=31,519.65..31,519.67 rows=1 width=16) (actual time=1,052.414..1,109.297 rows=141 loops=1)

  • Group Key: my_meetings.company_user_id
3.          

CTE my_meetings

4. 95.511 136.021 ↑ 1.2 98,308 1

Bitmap Heap Scan on meetings_108749 meetings (cost=3,970.61..28,384.56 rows=113,426 width=243) (actual time=43.286..136.021 rows=98,308 loops=1)

  • 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=14238
5. 40.510 40.510 ↑ 1.2 98,308 1

Bitmap Index Scan on nb_meetings_on_co_id_end_time_108749 (cost=0.00..3,942.25 rows=113,426 width=0) (actual time=40.510..40.510 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))
6. 75.095 1,074.345 ↓ 160,065.0 160,065 1

Sort (cost=3,135.08..3,135.09 rows=1 width=8) (actual time=1,052.157..1,074.345 rows=160,065 loops=1)

  • Sort Key: my_meetings.company_user_id
  • Sort Method: quicksort Memory: 13648kB
7. 78.075 999.250 ↓ 160,065.0 160,065 1

Nested Loop (cost=0.56..3,135.07 rows=1 width=8) (actual time=43.332..999.250 rows=160,065 loops=1)

8. 331.327 331.327 ↓ 32,769.3 98,308 1

CTE Scan on my_meetings (cost=0.00..3,119.22 rows=3 width=24) (actual time=43.295..331.327 rows=98,308 loops=1)

  • 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))
9. 589.848 589.848 ↓ 2.0 2 98,308

Index Only Scan using entity_associations_source_to_target_107725 on entity_associations_107725 entity_associations (cost=0.56..5.28 rows=1 width=16) (actual time=0.005..0.006 rows=2 loops=98,308)

  • Index Cond: ((company_id = 2928) AND (source_entity_type = 27) AND (source_entity_id = my_meetings.id))
  • Filter: (target_entity_type = ANY ('{3,21}'::integer[]))
  • Rows Removed by Filter: 1
  • Heap Fetches: 142388