explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qMp1

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 139.291 ↑ 1.0 1 1

Aggregate (cost=22,117.89..22,117.90 rows=1 width=32) (actual time=139.291..139.291 rows=1 loops=1)

2. 0.001 139.288 ↓ 0.0 0 1

Limit (cost=15,758.06..22,117.76 rows=10 width=13) (actual time=139.288..139.288 rows=0 loops=1)

3. 0.001 139.287 ↓ 0.0 0 1

Nested Loop Left Join (cost=15,758.06..45,648.66 rows=47 width=13) (actual time=139.287..139.287 rows=0 loops=1)

4. 0.003 139.286 ↓ 0.0 0 1

Hash Join (cost=15,757.77..45,314.02 rows=47 width=13) (actual time=139.286..139.286 rows=0 loops=1)

  • Hash Cond: (c.phone_id = p.id)
5. 0.014 0.014 ↑ 466,237.0 1 1

Seq Scan on client c (cost=0.00..28,332.37 rows=466,237 width=48) (actual time=0.014..0.014 rows=1 loops=1)

6. 0.000 139.269 ↓ 0.0 0 1

Hash (cost=15,756.64..15,756.64 rows=90 width=17) (actual time=139.269..139.269 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
7. 5.089 140.802 ↓ 0.0 0 1

Gather (cost=1,000.00..15,756.64 rows=90 width=17) (actual time=139.268..140.802 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
8. 135.713 135.713 ↓ 0.0 0 3

Parallel Seq Scan on client_phone p (cost=0.00..14,747.64 rows=38 width=17) (actual time=135.713..135.713 rows=0 loops=3)

  • Filter: (lower(main) ~~ '%+380931355176%'::text)
  • Rows Removed by Filter: 300674
9. 0.000 0.000 ↓ 0.0 0

Index Scan using scoring_telephone_blocking_tel_index on scoring_telephone_blocking sbtel (cost=0.29..7.11 rows=1 width=14) (never executed)

  • Index Cond: (tel = p.main)
  • Filter: (scoring_telephone_blocking_type_id = 1)
Planning time : 2.281 ms
Execution time : 709.055 ms