explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lS57 : Optimization for: plan #Bzb8

Settings

Optimization path:

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

HashAggregate (cost=1,728.76..1,743.68 rows=1,194 width=51) (actual rows= loops=)

  • Group Key: ag.uniqid, btrim((ar.host)::text), ar.port
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=258.74..1,719.80 rows=1,194 width=51) (actual rows= loops=)

  • Hash Cond: (ag.id = ar.agent_id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on ag (cost=0.00..1,352.36 rows=8,336 width=19) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=243.81..243.81 rows=1,194 width=25) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on ag_retrans ar (cost=0.00..243.81 rows=1,194 width=25) (actual rows= loops=)

  • Filter: ((format)::text ~~* 'EGTS'::text)