explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qDAC

Settings
# exclusive inclusive rows x rows loops node
1. 0.557 132.984 ↓ 2.0 303 1

Sort (cost=3,577.45..3,577.83 rows=151 width=2,865) (actual time=132.943..132.984 rows=303 loops=1)

  • Sort Key: c0.inserted_at DESC
  • Sort Method: quicksort Memory: 596kB
2. 39.618 132.427 ↓ 2.0 303 1

HashAggregate (cost=3,568.97..3,570.48 rows=151 width=2,865) (actual time=132.269..132.427 rows=303 loops=1)

  • Group Key: c0.id
3. 76.756 92.809 ↓ 30.2 196,349 1

Hash Right Join (cost=2,988.08..3,552.72 rows=6,498 width=2,865) (actual time=14.285..92.809 rows=196,349 loops=1)

  • Hash Cond: (c4.company_id = c0.id)
4. 1.800 1.800 ↑ 1.0 17,641 1

Seq Scan on company_specializations c4 (cost=0.00..389.41 rows=17,641 width=34) (actual time=0.008..1.800 rows=17,641 loops=1)

5. 5.680 14.253 ↓ 6.0 2,611 1

Hash (cost=2,982.64..2,982.64 rows=435 width=2,865) (actual time=14.253..14.253 rows=2,611 loops=1)

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 3819kB
6. 2.790 8.573 ↓ 6.0 2,611 1

Hash Right Join (cost=2,894.55..2,982.64 rows=435 width=2,865) (actual time=5.251..8.573 rows=2,611 loops=1)

  • Hash Cond: (c3.company_id = c0.id)
7. 0.574 0.574 ↑ 1.0 3,399 1

Seq Scan on company_industries c3 (cost=0.00..70.99 rows=3,399 width=24) (actual time=0.011..0.574 rows=3,399 loops=1)

8. 1.099 5.209 ↓ 2.0 303 1

Hash (cost=2,892.67..2,892.67 rows=151 width=2,865) (actual time=5.209..5.209 rows=303 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 455kB
9. 4.110 4.110 ↓ 2.0 303 1

Seq Scan on companies c0 (cost=0.00..2,892.67 rows=151 width=2,865) (actual time=0.886..4.110 rows=303 loops=1)

  • Filter: (hub_active AND ((features ->> 'supplier'::text))::boolean)
  • Rows Removed by Filter: 878