explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ENtD

Settings
# exclusive inclusive rows x rows loops node
1. 0.359 276.651 ↑ 1.0 1 1

Aggregate (cost=4,576.18..4,576.19 rows=1 width=32) (actual time=276.651..276.651 rows=1 loops=1)

2. 0.004 276.292 ↑ 10.0 1 1

Limit (cost=356.84..4,576.05 rows=10 width=13) (actual time=91.303..276.292 rows=1 loops=1)

3. 0.528 276.288 ↑ 48.0 1 1

Nested Loop Left Join (cost=356.84..20,609.04 rows=48 width=13) (actual time=91.301..276.288 rows=1 loops=1)

4. 134.670 275.192 ↑ 48.0 1 1

Hash Join (cost=356.43..20,414.26 rows=48 width=13) (actual time=90.207..275.192 rows=1 loops=1)

  • Hash Cond: (c.phone_id = p.id)
5. 129.827 129.827 ↓ 1.0 482,761 1

Seq Scan on client c (cost=0.00..18,792.66 rows=481,966 width=48) (actual time=0.013..129.827 rows=482,761 loops=1)

6. 0.656 10.695 ↑ 46.5 2 1

Hash (cost=355.27..355.27 rows=93 width=17) (actual time=10.695..10.695 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.040 10.039 ↑ 46.5 2 1

Bitmap Heap Scan on client_phone p (cost=9.13..355.27 rows=93 width=17) (actual time=10.032..10.039 rows=2 loops=1)

  • Recheck Cond: (lower(main) ~~ '%+380931355176%'::text)
  • Heap Blocks: exact=1
8. 9.999 9.999 ↑ 46.5 2 1

Bitmap Index Scan on client_phone_main_trgr (cost=0.00..9.11 rows=93 width=0) (actual time=9.999..9.999 rows=2 loops=1)

  • Index Cond: (lower(main) ~~ '%+380931355176%'::text)
9. 0.568 0.568 ↓ 0.0 0 1

Index Only Scan using scoring_telephone_blocking_tel_scoring_telephone_blocking_t_key on scoring_telephone_blocking sbtel (cost=0.41..4.05 rows=1 width=13) (actual time=0.567..0.568 rows=0 loops=1)

  • Index Cond: ((tel = p.main) AND (scoring_telephone_blocking_type_id = 1))
  • Heap Fetches: 0
Planning time : 44.935 ms
Execution time : 297.430 ms