explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I8fr

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

Custom Scan (Citus Router) (cost=0.00..0.00 rows=0 width=0) (actual time=1,028.295..1,028.301 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.706 ms
  • Execution time: 1126.828 ms
2. 34.745 1,115.344 ↓ 141.0 141 1

GroupAggregate (cost=41,326.13..41,326.15 rows=1 width=16) (actual time=1,059.196..1,115.344 rows=141 loops=1)

  • Group Key: my_meetings.company_user_id
3.          

CTE my_meetings

4. 116.501 241.413 ↑ 1.2 98,308 1

Sort (cost=37,907.46..38,191.03 rows=113,426 width=243) (actual time=223.320..241.413 rows=98,308 loops=1)

  • Sort Key: meetings.id
  • Sort Method: quicksort Memory: 36911kB
5. 84.562 124.912 ↑ 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.295..124.912 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
6. 40.350 40.350 ↑ 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.349..40.350 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))
7. 73.703 1,080.599 ↓ 160,065.0 160,065 1

Sort (cost=3,135.10..3,135.10 rows=1 width=8) (actual time=1,058.958..1,080.599 rows=160,065 loops=1)

  • Sort Key: my_meetings.company_user_id
  • Sort Method: quicksort Memory: 13648kB
8. 51.615 1,006.896 ↓ 160,065.0 160,065 1

Nested Loop (cost=0.56..3,135.09 rows=1 width=8) (actual time=223.365..1,006.896 rows=160,065 loops=1)

9. 365.433 365.433 ↓ 32,769.3 98,308 1

CTE Scan on my_meetings (cost=0.00..3,119.22 rows=3 width=24) (actual time=223.329..365.433 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))
10. 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 = 3) OR (target_entity_type = 21))
  • Rows Removed by Filter: 1
  • Heap Fetches: 142388