explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w5Qz

Settings
# exclusive inclusive rows x rows loops node
1. 0.622 62.492 ↓ 2.0 2 1

GroupAggregate (cost=7,304.57..7,304.59 rows=1 width=9) (actual time=62.047..62.492 rows=2 loops=1)

  • Group Key: smsrequest0_.read
2. 1.531 61.870 ↓ 6,491.0 6,491 1

Sort (cost=7,304.57..7,304.57 rows=1 width=9) (actual time=61.505..61.870 rows=6,491 loops=1)

  • Sort Key: smsrequest0_.read
  • Sort Method: quicksort Memory: 497kB
3. 4.836 60.339 ↓ 6,491.0 6,491 1

Nested Loop (cost=148.71..7,304.56 rows=1 width=9) (actual time=1.009..60.339 rows=6,491 loops=1)

  • Join Filter: (smsrequest0_.ac_id = providerli2_.activation_code_id)
4. 0.000 16.557 ↓ 12.3 6,491 1

Nested Loop (cost=148.29..7,047.65 rows=526 width=44) (actual time=0.982..16.557 rows=6,491 loops=1)

5. 3.534 4.200 ↓ 12.3 6,491 1

Bitmap Heap Scan on sms_request smsrequest0_ (cost=147.85..2,629.69 rows=526 width=17) (actual time=0.975..4.200 rows=6,491 loops=1)

  • Recheck Cond: ((type)::text = 'RESULTAT'::text)
  • Filter: (message IS NOT NULL)
  • Rows Removed by Filter: 166
  • Heap Blocks: exact=1605
6. 0.666 0.666 ↓ 1.1 6,657 1

Bitmap Index Scan on idx_sms_request_type_read (cost=0.00..147.72 rows=6,307 width=0) (actual time=0.666..0.666 rows=6,657 loops=1)

  • Index Cond: ((type)::text = 'RESULTAT'::text)
7. 12.982 12.982 ↑ 1.0 1 6,491

Index Scan using activation_code_pkey on activation_code activation1_ (cost=0.43..8.39 rows=1 width=27) (actual time=0.001..0.002 rows=1 loops=6,491)

  • Index Cond: (id = smsrequest0_.ac_id)
8. 38.946 38.946 ↑ 1.0 1 6,491

Index Scan using provider_link_activation_code on provider_link providerli2_ (cost=0.43..0.48 rows=1 width=27) (actual time=0.006..0.006 rows=1 loops=6,491)

  • Index Cond: ((activation_code)::text = (activation1_.activation_code)::text)
  • Filter: (((link_state)::text = 'ACTIVE'::text) AND (activation1_.id = activation_code_id) AND (activation1_.provider_id = provider_id))
  • Rows Removed by Filter: 0
Planning time : 0.867 ms