explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KTfN

Settings
# exclusive inclusive rows x rows loops node
1. 232.717 1,034.173 ↓ 279,486.0 279,486 1

Nested Loop (cost=1,051.95..31,983.38 rows=1 width=36) (actual time=4.337..1,034.173 rows=279,486 loops=1)

2. 0.000 66.166 ↓ 367,645.0 367,645 1

Gather (cost=1,051.81..31,983.22 rows=1 width=7) (actual time=1.967..66.166 rows=367,645 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 50.252 177.869 ↓ 122,548.0 122,548 3 / 3

Hash Left Join (cost=51.81..30,983.12 rows=1 width=7) (actual time=0.830..177.869 rows=122,548 loops=3)

  • Hash Cond: (p.id = pf.provider_id)
  • Filter: (pf.id IS NULL)
  • Rows Removed by Filter: 22
4. 127.287 127.287 ↑ 1.2 122,570 3 / 3

Parallel Seq Scan on providers p (cost=0.00..30,529.12 rows=153,212 width=7) (actual time=0.400..127.287 rows=122,570 loops=3)

5. 0.021 0.330 ↑ 1.0 65 3 / 3

Hash (cost=51.00..51.00 rows=65 width=8) (actual time=0.330..0.330 rows=65 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
6. 0.309 0.309 ↑ 1.0 65 3 / 3

Seq Scan on provider_flags pf (cost=0.00..51.00 rows=65 width=8) (actual time=0.024..0.309 rows=65 loops=3)

  • Filter: ((key)::text = 'marketing_birthday_sms_delivery'::text)
  • Rows Removed by Filter: 1,775
7. 735.290 735.290 ↑ 1.0 1 367,645

Index Scan using index_country_flags_on_country_code_and_key on country_flags cf (cost=0.14..0.16 rows=1 width=35) (actual time=0.002..0.002 rows=1 loops=367,645)

  • Index Cond: (((country_code)::text = (p.country_code)::text) AND ((key)::text = 'marketing_birthday_sms_delivery'::text))
  • Filter: (value IS NOT NULL)
Planning time : 0.346 ms
Execution time : 1,051.705 ms