explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6zjx

Settings
# exclusive inclusive rows x rows loops node
1. 1.762 6.573 ↑ 1.0 1,541 1

HashAggregate (cost=179.70..195.11 rows=1,541 width=238) (actual time=6.188..6.573 rows=1,541 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. 3.611 4.811 ↓ 1.2 1,835 1

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

  • 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.341 0.341 ↑ 1.0 1,578 1

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

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

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

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

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

Planning time : 0.778 ms
Execution time : 6.825 ms