explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mByQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.639 2,472.526 ↑ 1.3 610 1

Hash Right Join (cost=71,296.11..71,430.44 rows=789 width=164) (actual time=2,468.539..2,472.526 rows=610 loops=1)

  • Hash Cond: (traffic_sessions.iccid = (sims.iccid)::text)
2. 2.889 2,470.962 ↑ 1.9 1,147 1

Finalize GroupAggregate (cost=71,167.88..71,274.00 rows=2,234 width=71) (actual time=2,467.365..2,470.962 rows=1,147 loops=1)

  • Group Key: traffic_sessions.iccid, traffic_sessions.carrier_country_code
3. 25.602 2,468.073 ↑ 1.3 3,324 1

Sort (cost=71,167.88..71,179.05 rows=4,468 width=71) (actual time=2,467.336..2,468.073 rows=3,324 loops=1)

  • Sort Key: traffic_sessions.iccid, traffic_sessions.carrier_country_code
  • Sort Method: quicksort Memory: 564kB
4. 19.638 2,442.471 ↑ 1.3 3,324 1

Gather (cost=70,422.27..70,897.00 rows=4,468 width=71) (actual time=2,436.532..2,442.471 rows=3,324 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 387.250 2,422.833 ↑ 2.0 1,108 3 / 3

Partial HashAggregate (cost=69,422.27..69,450.20 rows=2,234 width=71) (actual time=2,421.388..2,422.833 rows=1,108 loops=3)

  • Group Key: traffic_sessions.iccid, traffic_sessions.carrier_country_code
6. 2,035.583 2,035.583 ↑ 1.2 548,461 3 / 3

Parallel Seq Scan on traffic_sessions (cost=0.00..61,075.80 rows=667,718 width=39) (actual time=0.103..2,035.583 rows=548,461 loops=3)

  • Filter: ((end >= '2019-08-27 06:00:00+00'::timestamp with time zone) AND (end <= '2019-09-28 05:59:59.999+00'::timestamp with time zone))
  • Rows Removed by Filter: 266,191
7. 0.271 0.925 ↓ 1.0 610 1

Hash (cost=120.90..120.90 rows=586 width=112) (actual time=0.925..0.925 rows=610 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 110kB
8. 0.654 0.654 ↓ 1.0 610 1

Seq Scan on sims (cost=0.00..120.90 rows=586 width=112) (actual time=0.010..0.654 rows=610 loops=1)

  • Filter: ((NOT archived) AND ((clientSlug)::text = 'aware360'::text) AND ((providerSlug)::text = 'telus'::text))
  • Rows Removed by Filter: 1,050
Planning time : 5.748 ms
Execution time : 2,473.440 ms