explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MvjP

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

Custom Scan (Citus Router) (cost=0.00..0.00 rows=0 width=0) (actual rows= loops=)

  • Task Count: 1
  • Tasks Shown: All
  • -> Task
  • Node: host=ec2-34-235-32-34.compute-1.amazonaws.com port=5,432 dbname=citus
2. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=50,234.64..50,510.24 rows=200 width=112) (actual rows= loops=)

  • Group Key: params_with_time_zone.agent
3.          

CTE params

4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on agent_activity_102155 agent_activity (cost=7,174.10..44,052.71 rows=134,803 width=24) (actual rows= loops=)

  • Recheck Cond: (app = '1308634746881'::bigint)
  • Filter: ((created_at >= '2019-05-29 00:00:00'::timestamp without time zone) AND (created_at <= '2019-09-27 14:51:55'::timestamp without time zone))
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on app_id_agent_activity_idx_102155 (cost=0.00..7,140.40 rows=492,263 width=0) (actual rows= loops=)

  • Index Cond: (app = '1308634746881'::bigint)
6.          

CTE params_with_time_zone

7. 0.000 0.000 ↓ 0.0

HashAggregate (cost=4,718.11..4,987.71 rows=13,480 width=44) (actual rows= loops=)

  • Group Key: params.agent, (timezone('Asia/Calcutta'::text, timezone('UTC'::text, params.created_at)))::date
8. 0.000 0.000 ↓ 0.0

CTE Scan on params (cost=0.00..3,707.08 rows=134,803 width=20) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Sort (cost=1,194.23..1,227.93 rows=13,480 width=40) (actual rows= loops=)

  • Sort Key: params_with_time_zone.agent
10. 0.000 0.000 ↓ 0.0

CTE Scan on params_with_time_zone (cost=0.00..269.60 rows=13,480 width=40) (actual rows= loops=)