explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fCYt

Settings
# exclusive inclusive rows x rows loops node
1. 0.486 61.082 ↑ 1.0 2 1

GroupAggregate (cost=7,325.28..7,329.18 rows=2 width=9) (actual time=60.724..61.082 rows=2 loops=1)

  • Group Key: smsrequest0_.read
2. 1.587 60.596 ↓ 12.5 6,491 1

Sort (cost=7,325.28..7,326.57 rows=518 width=9) (actual time=60.287..60.596 rows=6,491 loops=1)

  • Sort Key: smsrequest0_.read
  • Sort Method: quicksort Memory: 497kB
3. 3.462 59.009 ↓ 12.5 6,491 1

Nested Loop Semi Join (cost=148.71..7,301.93 rows=518 width=9) (actual time=0.981..59.009 rows=6,491 loops=1)

4. 2.981 3.619 ↓ 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.934..3.619 rows=6,491 loops=1)

  • Recheck Cond: ((type)::text = 'RESULTAT'::text)
  • Filter: (message IS NOT NULL)
  • Rows Removed by Filter: 166
  • Heap Blocks: exact=1,605
5. 0.638 0.638 ↓ 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.638..0.638 rows=6,657 loops=1)

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

Nested Loop (cost=0.86..8.87 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=6,491)

7. 12.982 12.982 ↑ 1.0 1 6,491

Index Scan using activation_code_pkey on activation_code activation2_ (cost=0.43..8.39 rows=1 width=27) (actual time=0.002..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 providerli1_ (cost=0.43..0.47 rows=1 width=19) (actual time=0.006..0.006 rows=1 loops=6,491)

  • Index Cond: ((activation_code)::text = (activation2_.activation_code)::text)
  • Filter: (((link_state)::text = 'ACTIVE'::text) AND (activation2_.provider_id = provider_id))
  • Rows Removed by Filter: 0