explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WKh

Settings
# exclusive inclusive rows x rows loops node
1. 0.486 8.588 ↑ 6.2 90 1

Unique (cost=1,378.05..1,393.48 rows=561 width=177) (actual time=7.996..8.588 rows=90 loops=1)

  • Buffers: shared hit=1697
2. 1.503 8.102 ↓ 1.6 886 1

Sort (cost=1,378.05..1,379.46 rows=561 width=177) (actual time=7.995..8.102 rows=886 loops=1)

  • Sort Key: partners_lppartneroffer.order_pos, mfi_offer.conversion_rate DESC NULLS LAST, mfi_offer.earn_per_lead DESC NULLS LAST, mfi_offer.id, mfi_offer.logo, mfi_offer.loan_type, mfi_offer.mfi_id, mfi_offer.mobile_logo, mfi_offer.name, microfinanc (...)
  • Sort Method: quicksort Memory: 311kB
  • Buffers: shared hit=1697
3. 2.309 6.599 ↓ 1.6 886 1

Nested Loop Left Join (cost=6.00..1,352.44 rows=561 width=177) (actual time=0.172..6.599 rows=886 loops=1)

  • Filter: (((mfi_offer.regions)::text = 'a'::text) OR (mfi_offer_kladr_region_list.kladr_id = 180185))
  • Rows Removed by Filter: 9780
  • Buffers: shared hit=1697
4. 0.009 0.930 ↑ 1.0 96 1

Nested Loop (cost=5.58..492.64 rows=96 width=179) (actual time=0.089..0.930 rows=96 loops=1)

  • Buffers: shared hit=582
5. 0.239 0.633 ↑ 1.0 96 1

Nested Loop (cost=5.30..438.22 rows=96 width=137) (actual time=0.080..0.633 rows=96 loops=1)

  • Buffers: shared hit=294
6. 0.061 0.106 ↑ 1.0 96 1

Bitmap Heap Scan on partners_lppartneroffer (cost=5.02..24.70 rows=96 width=8) (actual time=0.064..0.106 rows=96 loops=1)

  • Recheck Cond: (partner_id = 1)
  • Filter: (((landing_slug)::text = 'consumer_loans'::text) OR (landing_id = 46))
  • Heap Blocks: exact=2
  • Buffers: shared hit=5
7. 0.045 0.045 ↑ 1.0 96 1

Bitmap Index Scan on partners_lppartneroffer_partner_id_a6570be4 (cost=0.00..5.00 rows=96 width=0) (actual time=0.045..0.045 rows=96 loops=1)

  • Index Cond: (partner_id = 1)
  • Buffers: shared hit=3
8. 0.288 0.288 ↑ 1.0 1 96

Index Scan using mfi_offer_pkey on mfi_offer (cost=0.28..4.30 rows=1 width=133) (actual time=0.003..0.003 rows=1 loops=96)

  • Index Cond: (id = partners_lppartneroffer.offer_id)
  • Buffers: shared hit=289
9. 0.288 0.288 ↑ 1.0 1 96

Index Scan using microfinance_mfi_pkey on microfinance_mfi (cost=0.28..0.56 rows=1 width=42) (actual time=0.002..0.003 rows=1 loops=96)

  • Index Cond: (id = mfi_offer.mfi_id)
  • Buffers: shared hit=288
10. 3.360 3.360 ↑ 1.5 111 96

Index Scan using mfi_offer_kladr_region_list_bf98d991 on mfi_offer_kladr_region_list (cost=0.42..6.42 rows=169 width=8) (actual time=0.005..0.035 rows=111 loops=96)

  • Index Cond: (mfi_offer.id = offer_id)
  • Buffers: shared hit=1115
Planning time : 1.646 ms
Execution time : 8.896 ms