explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pcrf : original

Settings
# exclusive inclusive rows x rows loops node
1. 16.771 235.465 ↑ 2.1 7,993 1

GroupAggregate (cost=301,404.96..302,293.21 rows=16,919 width=98) (actual time=213.781..235.465 rows=7,993 loops=1)

  • Group Key: c.team_company, a.odesk_team_user_id, d.contract_id
2. 45.921 218.694 ↑ 1.7 10,073 1

Sort (cost=301,404.96..301,447.26 rows=16,919 width=70) (actual time=213.760..218.694 rows=10,073 loops=1)

  • Sort Key: c.team_company, a.odesk_team_user_id, d.contract_id
  • Sort Method: quicksort Memory: 2,184kB
3. 8.816 172.773 ↑ 1.7 10,073 1

Nested Loop (cost=0.87..300,216.71 rows=16,919 width=70) (actual time=14.797..172.773 rows=10,073 loops=1)

4. 10.408 123.665 ↑ 1.7 10,073 1

Nested Loop (cost=0.43..221,065.66 rows=16,919 width=56) (actual time=14.788..123.665 rows=10,073 loops=1)

5. 4.572 72.965 ↑ 1.7 10,073 1

Append (cost=0.00..86,860.62 rows=16,919 width=37) (actual time=14.776..72.965 rows=10,073 loops=1)

6. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on data_contracttime_days d (cost=0.00..0.00 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND (worked_date = '2019-09-26'::date))
7. 55.945 68.392 ↑ 1.7 10,073 1

Bitmap Heap Scan on part_data_contracttime_days_201909 d_1 (cost=6,813.35..86,860.62 rows=16,918 width=37) (actual time=14.772..68.392 rows=10,073 loops=1)

  • Recheck Cond: (worked_date = '2019-09-26'::date)
  • Filter: ('{}'::smallint[] <> cells_offline)
  • Rows Removed by Filter: 90,126
  • Heap Blocks: exact=14,565
8. 12.447 12.447 ↑ 1.0 100,430 1

Bitmap Index Scan on part_data_contracttime_days_201909_ukey (cost=0.00..6,809.12 rows=103,009 width=0) (actual time=12.446..12.447 rows=100,430 loops=1)

  • Index Cond: (worked_date = '2019-09-26'::date)
9. 40.292 40.292 ↑ 1.0 1 10,073

Index Scan using dim_assignments_pkey on dim_assignments a (cost=0.43..7.92 rows=1 width=27) (actual time=0.004..0.004 rows=1 loops=10,073)

  • Index Cond: (id = d.contract_id)
10. 40.292 40.292 ↑ 1.0 1 10,073

Index Scan using dim_companies_pkey on dim_companies c (cost=0.43..4.67 rows=1 width=30) (actual time=0.003..0.004 rows=1 loops=10,073)

  • Index Cond: (id = a.company_id)