explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xdt34

Settings
# exclusive inclusive rows x rows loops node
1. 0.416 425.758 ↓ 1,335.0 1,335 1

Unique (cost=326.46..326.47 rows=1 width=78) (actual time=425.145..425.758 rows=1,335 loops=1)

  • Buffers: shared hit=96073 read=22283
2. 3.191 425.342 ↓ 1,387.0 1,387 1

Sort (cost=326.46..326.47 rows=1 width=78) (actual time=425.14..425.342 rows=1,387 loops=1)

  • Sort Key: sa.partner_ad_ref, sa.stream_ad_id DESC
  • Sort Method: quicksort Memory: 239kB
  • Buffers: shared hit=96073 read=22283
3. 9.640 422.151 ↓ 1,387.0 1,387 1

Nested Loop (cost=1.71..326.45 rows=1 width=78) (actual time=15.888..422.151 rows=1,387 loops=1)

  • Buffers: shared hit=96073 read=22283
4. 4.953 119.003 ↓ 24,459.0 24,459 1

Nested Loop (cost=1.28..325.98 rows=1 width=95) (actual time=0.066..119.003 rows=24,459 loops=1)

  • Buffers: shared hit=42 read=20251
5. 0.008 0.008 ↑ 1.0 1 1

Seq Scan on site s (cost=0..1.06 rows=1 width=4) (actual time=0.006..0.008 rows=1 loops=1)

  • Filter: (s.active AND (s.name = 'leboncoin'::text))
  • Buffers: shared hit=1
6. 6.504 114.042 ↓ 8,153.0 24,459 1

Nested Loop (cost=1.28..324.88 rows=3 width=99) (actual time=0.058..114.042 rows=24,459 loops=1)

  • Buffers: shared hit=41 read=20251
7. 0.004 0.042 ↓ 2.0 2 1

Nested Loop (cost=0.85..27.32 rows=1 width=8) (actual time=0.032..0.042 rows=2 loops=1)

  • Buffers: shared hit=14 read=3
8. 0.003 0.030 ↓ 1.3 4 1

Nested Loop (cost=0.71..26.82 rows=3 width=12) (actual time=0.02..0.03 rows=4 loops=1)

  • Buffers: shared hit=6 read=3
9. 0.016 0.016 ↑ 1.0 1 1

Index Scan using idx_cc_client_account_id on client_contract cc (cost=0.29..8.31 rows=1 width=4) (actual time=0.015..0.016 rows=1 loops=1)

  • Index Cond: (cc.client_account_id = 11)
  • Buffers: shared hit=1 read=2
10. 0.011 0.011 ↑ 1.0 4 1

Index Scan using idx_ccb_client_contract_id on client_contract_broadcast ccb (cost=0.42..18.48 rows=4 width=16) (actual time=0.003..0.011 rows=4 loops=1)

  • Index Cond: (ccb.client_contract_id = cc.client_contract_id)
  • Buffers: shared hit=5 read=1
11. 0.008 0.008 ↓ 0.0 0 4

Index Scan using partner_pkey on partner p (cost=0.14..0.16 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=4)

  • Index Cond: (p.partner_id = ccb.partner_id)
  • Filter: (p.active AND (p.name = 'talentplug'::text))
  • Buffers: shared hit=8
12. 107.496 107.496 ↓ 1.7 12,230 2

Index Scan using idx_sa_client_contract_broadcast_id on stream_ad sa (cost=0.43..224.48 rows=7,307 width=99) (actual time=0.026..53.748 rows=12,230 loops=2)

  • Index Cond: (sa.client_contract_broadcast_id = ccb.client_contract_broadcast_id)
  • Filter: (sa.vertical = 'job'::enum_vertical)
  • Buffers: shared hit=27 read=20248
13. 293.508 293.508 ↓ 0.0 0 24,459

Index Scan using stream_ad_online_external_ad_id_idx on stream_ad_online sao (cost=0.43..0.47 rows=1 width=20) (actual time=0.012..0.012 rows=0 loops=24,459)

  • Index Cond: (sao.external_ad_id = sa.external_ad_id)
  • Filter: (sao.status = ANY ('{online,pending}'::enum_stream_ad_online_status[]))
  • Buffers: shared hit=96031 read=2032
Planning time : 2.027 ms
Execution time : 425.994 ms