explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0Kj5

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 0.549 ↑ 6.0 2 1

HashAggregate (cost=93.18..93.33 rows=12 width=238) (actual time=0.548..0.549 rows=2 loops=1)

  • Group Key: g.agent, g.datetime
2.          

CTE geo_per_day

3. 0.026 0.532 ↑ 6.0 2 1

Hash Right Join (cost=66.75..92.85 rows=12 width=29) (actual time=0.506..0.532 rows=2 loops=1)

  • Hash Cond: (tag.age_id = age.age_id)
4. 0.014 0.014 ↑ 38.7 30 1

Seq Scan on teamagent tag (cost=0.00..21.60 rows=1,160 width=16) (actual time=0.003..0.014 rows=30 loops=1)

5. 0.003 0.492 ↑ 1.0 2 1

Hash (cost=66.72..66.72 rows=2 width=37) (actual time=0.492..0.492 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
6. 0.046 0.489 ↑ 1.0 2 1

Hash Join (cost=61.36..66.72 rows=2 width=37) (actual time=0.476..0.489 rows=2 loops=1)

  • Hash Cond: (age.age_id = geo.age_id)
7. 0.065 0.065 ↑ 1.4 113 1

Seq Scan on agent age (cost=0.00..4.56 rows=156 width=22) (actual time=0.007..0.065 rows=113 loops=1)

8. 0.004 0.378 ↑ 1.0 2 1

Hash (cost=61.34..61.34 rows=2 width=23) (actual time=0.378..0.378 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
9. 0.374 0.374 ↑ 1.0 2 1

Seq Scan on geocoordinate geo (cost=0.00..61.34 rows=2 width=23) (actual time=0.026..0.374 rows=2 loops=1)

  • Filter: (geo_distancelastexecution > 0::numeric)
  • Rows Removed by Filter: 2185
10. 0.537 0.537 ↑ 6.0 2 1

CTE Scan on geo_per_day g (cost=0.00..0.24 rows=12 width=238) (actual time=0.509..0.537 rows=2 loops=1)