explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HPgD

Settings
# exclusive inclusive rows x rows loops node
1. 0.032 715.450 ↑ 1.0 1 1

Aggregate (cost=20,799.81..20,799.82 rows=1 width=32) (actual time=715.449..715.450 rows=1 loops=1)

2. 0.002 715.418 ↑ 10.0 1 1

Limit (cost=16,580.48..20,799.69 rows=10 width=13) (actual time=535.414..715.418 rows=1 loops=1)

3. 0.012 715.416 ↑ 48.0 1 1

Nested Loop Left Join (cost=16,580.48..36,832.67 rows=48 width=13) (actual time=535.413..715.416 rows=1 loops=1)

4. 135.288 715.377 ↑ 48.0 1 1

Hash Join (cost=16,580.06..36,637.89 rows=48 width=13) (actual time=535.375..715.377 rows=1 loops=1)

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

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

6. 0.000 451.580 ↑ 46.5 2 1

Hash (cost=16,578.90..16,578.90 rows=93 width=17) (actual time=451.579..451.580 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 10.080 451.669 ↑ 46.5 2 1

Gather (cost=1,000.00..16,578.90 rows=93 width=17) (actual time=451.571..451.669 rows=2 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
8. 441.589 441.589 ↑ 39.0 1 3

Parallel Seq Scan on client_phone p (cost=0.00..15,569.60 rows=39 width=17) (actual time=441.485..441.589 rows=1 loops=3)

  • Filter: (lower(main) ~~ '%+380931355176%'::text)
  • Rows Removed by Filter: 310805
9. 0.027 0.027 ↓ 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.027..0.027 rows=0 loops=1)

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