explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cCJR

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 0.117 ↑ 1.0 2 1

GroupAggregate (cost=23.68..23.78 rows=2 width=108) (actual time=0.114..0.117 rows=2 loops=1)

  • Group Key: c.team_company, a.odesk_team_user_id, d.contract_id
2. 0.021 0.103 ↑ 1.0 2 1

Sort (cost=23.68..23.68 rows=2 width=80) (actual time=0.101..0.103 rows=2 loops=1)

  • Sort Key: c.team_company, a.odesk_team_user_id, d.contract_id
  • Sort Method: quicksort Memory: 25kB
3. 0.008 0.082 ↑ 1.0 2 1

Nested Loop (cost=0.85..23.67 rows=2 width=80) (actual time=0.048..0.082 rows=2 loops=1)

4. 0.002 0.064 ↑ 1.0 2 1

Nested Loop (cost=0.42..22.01 rows=2 width=66) (actual time=0.039..0.064 rows=2 loops=1)

5. 0.002 0.048 ↑ 1.0 2 1

Append (cost=0.00..5.12 rows=2 width=42) (actual time=0.028..0.048 rows=2 loops=1)

6. 0.004 0.004 ↓ 0.0 0 1

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

  • Filter: ((worked_date >= '2019-09-12 00:00:00'::timestamp without time zone) AND (worked_date <= '2019-10-03 00:00:00'::timestamp without time zone) AND ('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
7. 0.042 0.042 ↓ 2.0 2 1

Seq Scan on part_data_contracttime_days_201909 d_1 (cost=0.00..5.12 rows=1 width=37) (actual time=0.024..0.042 rows=2 loops=1)

  • Filter: ((worked_date >= '2019-09-12 00:00:00'::timestamp without time zone) AND (worked_date <= '2019-10-03 00:00:00'::timestamp without time zone) AND ('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 92
8. 0.014 0.014 ↑ 1.0 1 2

Index Scan using dim_assignments_pkey on dim_assignments a (cost=0.42..8.44 rows=1 width=32) (actual time=0.007..0.007 rows=1 loops=2)

  • Index Cond: (id = d.contract_id)
9. 0.010 0.010 ↑ 1.0 1 2

Index Scan using dim_companies_pkey on dim_companies c (cost=0.43..0.82 rows=1 width=30) (actual time=0.005..0.005 rows=1 loops=2)

  • Index Cond: (id = a.company_id)