explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vMAQ

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

HashAggregate (cost=179.70..195.11 rows=1,541 width=238) (actual rows= loops=)

  • Group Key: carriers.id, carriers.name, carriers.dba_name, carriers.code, carriers.scac_number, carriers.dot_number, carriers.mc_number, carriers.duns_number, carriers.revenova_id, carriers.notes, carriers.created_at, carriers.updated_at, carriers.status, carriers.level, carriers.opportunity, carriers.phone_number
2. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=64.67..116.58 rows=1,578 width=238) (actual rows= loops=)

  • Hash Cond: (addresses.addressable_id = carriers.id)
  • Filter: (((carriers.name)::text ~~* '%A%'::text) OR ((carriers.dba_name)::text ~~* '%A%'::text) OR ((carriers.code)::text ~~* '%A%'::text) OR ((carriers.scac_number)::text ~~* '%A%'::text) OR ((carriers.dot_number)::text ~~* '%A%'::text) OR ((carriers.mc_number)::text ~~* '%A%'::text) OR ((carriers.duns_number)::text ~~* '%A%'::text) OR ((carriers.phone_number)::text ~~* '%A%'::text) OR ((carriers.revenova_id)::text ~~* '%A%'::text) OR (((addresses.locality)::text ~~* '%A%'::text) AND ((addresses.administrative_area1_code)::text ~~* '%%'::text)))
3. 0.000 0.000 ↓ 0.0

Seq Scan on addresses (cost=0.00..47.73 rows=1,578 width=28) (actual rows= loops=)

  • Filter: ((addressable_type)::text = 'Carrier'::text)
4. 0.000 0.000 ↓ 0.0

Hash (cost=45.41..45.41 rows=1,541 width=238) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on carriers (cost=0.00..45.41 rows=1,541 width=238) (actual rows= loops=)