explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1S1a

Settings
# exclusive inclusive rows x rows loops node
1. 1.117 7.161 ↑ 1.1 976 1

HashAggregate (cost=158.82..169.38 rows=1,056 width=238) (actual time=6.893..7.161 rows=976 loops=1)

  • 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. 4.866 6.044 ↓ 1.1 1,163 1

Hash Right Join (cost=64.67..116.58 rows=1,056 width=238) (actual time=0.855..6.044 rows=1,163 loops=1)

  • Hash Cond: (addresses.addressable_id = carriers.id)
  • Filter: (((carriers.name)::text ~~* '%P%'::text) OR ((carriers.dba_name)::text ~~* '%P%'::text) OR ((carriers.code)::text ~~* '%P%'::text) OR ((carriers.scac_number)::text ~~* '%P%'::text) OR ((carriers.dot_number)::text ~~* '%P%'::text) OR ((carriers.mc_number)::text ~~* '%P%'::text) OR ((carriers.duns_number)::text ~~* '%P%'::text) OR ((carriers.phone_number)::text ~~* '%P%'::text) OR ((carriers.revenova_id)::text ~~* '%P%'::text) OR (((addresses.locality)::text ~~* '%P%'::text) AND ((addresses.administrative_area1_code)::text ~~* '%%'::text)))
  • Rows Removed by Filter: 672
3. 0.340 0.340 ↑ 1.0 1,578 1

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

  • Filter: ((addressable_type)::text = 'Carrier'::text)
4. 0.423 0.838 ↑ 1.0 1,541 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 247kB
5. 0.415 0.415 ↑ 1.0 1,541 1

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

Planning time : 0.789 ms
Execution time : 7.379 ms