explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BaTG

Settings
# exclusive inclusive rows x rows loops node
1. 0.101 590.577 ↑ 1.0 1 1

Aggregate (cost=4,582.76..4,582.77 rows=1 width=32) (actual time=590.577..590.577 rows=1 loops=1)

2. 0.015 590.476 ↑ 1.0 10 1

Limit (cost=356.91..4,582.64 rows=10 width=13) (actual time=397.270..590.476 rows=10 loops=1)

3. 0.081 590.461 ↑ 4.8 10 1

Nested Loop Left Join (cost=356.91..20,640.38 rows=48 width=13) (actual time=397.268..590.461 rows=10 loops=1)

4. 49.300 590.160 ↑ 4.8 10 1

Hash Join (cost=356.50..20,445.60 rows=48 width=13) (actual time=397.214..590.160 rows=10 loops=1)

  • Hash Cond: (c.phone_id = p.id)
5. 172.358 172.358 ↑ 2.6 186,322 1

Seq Scan on client c (cost=0.00..18,817.43 rows=484,443 width=48) (actual time=0.005..172.358 rows=186,322 loops=1)

6. 0.035 368.502 ↑ 1.3 71 1

Hash (cost=355.34..355.34 rows=93 width=17) (actual time=368.502..368.502 rows=71 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
7. 0.222 368.467 ↑ 1.3 71 1

Bitmap Heap Scan on client_phone p (cost=9.13..355.34 rows=93 width=17) (actual time=368.283..368.467 rows=71 loops=1)

  • Recheck Cond: (lower(main) ~~ '%093721%'::text)
  • Rows Removed by Index Recheck: 16
  • Heap Blocks: exact=60
8. 368.245 368.245 ↑ 1.1 87 1

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

  • Index Cond: (lower(main) ~~ '%093721%'::text)
9. 0.220 0.220 ↓ 0.0 0 10

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.022..0.022 rows=0 loops=10)

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