explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ngJ3

Settings
# exclusive inclusive rows x rows loops node
1. 126.057 17,131.258 ↑ 49.0 1 1

Gather (cost=1,000.57..1,092,317.99 rows=49 width=327) (actual time=17,016.139..17,131.258 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Planning Time: 0.771 ms
  • Execution Time: 17131.331 ms
2. 1.003 17,005.122 ↓ 0.0 0 3

Nested Loop (cost=0.57..1,090,969.82 rows=20 width=53) (actual time=16,369.880..17,005.122 rows=0 loops=3)

3. 17,004.047 17,004.047 ↑ 92.3 13 3

Parallel Seq Scan on tgasnodes t1 (cost=0.00..1,080,374.59 rows=1,200 width=38) (actual time=560.164..17,004.047 rows=13 loops=3)

  • Filter: (((addrnewid)::text ~~ 'UKR004001009012%'::text) AND (addrvalid = ANY ('{A,S}'::bpchar[])) AND (innercount = 18))
  • Rows Removed by Filter: 18546182
4. 0.072 0.072 ↓ 0.0 0 39

Index Scan using trefgasnodename_pkey on trefgasnodename t2 (cost=0.57..8.83 rows=1 width=29) (actual time=0.072..0.072 rows=0 loops=39)

  • Index Cond: (((addrouterid)::text = (t1.addrouterid)::text) AND (langcode = 'RUS'::bpchar) AND (nodetypeid = 9))
  • Filter: (lower((addrname)::text) = '1'::text)
  • Rows Removed by Filter: 1
5.          

SubPlan (forGather)

6. 0.079 0.079 ↑ 1.0 1 1

Index Scan using treftypename_pkey on treftypename (cost=0.28..7.01 rows=1 width=18) (actual time=0.077..0.079 rows=1 loops=1)

  • Index Cond: (typecodeid = t2.typecodeid)
  • Filter: ((langcode)::bpchar = t2.langcode)
  • Rows Removed by Filter: 4