explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yLtS

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.167 ↓ 0.0 0 1

Unique (cost=2,658.36..2,659.76 rows=80 width=59) (actual time=0.166..0.167 rows=0 loops=1)

2. 0.011 0.166 ↓ 0.0 0 1

Sort (cost=2,658.36..2,658.56 rows=80 width=59) (actual time=0.166..0.166 rows=0 loops=1)

  • Sort Key: topo2g.bsc_num, topo2g.bsc_name, spg2g2.resulttime, (((((((spg2g2.zch900z_internalinter_cellhandoverattemptsperbsc_1800_1900_900_)::double precision + (spg2g2.zch900y_internalinter_cellhan
  • Sort Method: quicksort Memory: 25kB
3. 0.001 0.155 ↓ 0.0 0 1

Nested Loop (cost=10.84..2,655.84 rows=80 width=59) (actual time=0.155..0.155 rows=0 loops=1)

  • Join Filter: (((spg2g2.objectname)::text = (spg2g1.objectname)::text) AND ((spg2g2.resulttime)::text = (spg2g1.resulttime)::text))
4. 0.154 0.154 ↓ 0.0 0 1

Seq Scan on spago2g1 spg2g1 (cost=0.00..7.58 rows=1 width=55) (actual time=0.154..0.154 rows=0 loops=1)

  • Filter: ((zk3003_successfulsdcchseizuresperbsc IS NOT NULL) AND ((zk3003_successfulsdcchseizuresperbsc)::text <> ''::text) AND (to_timestamp((resulttime)::text, 'YYYY.MM.DD HH24.MI'::tex
  • Rows Removed by Filter: 125
5. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=10.84..2,642.86 rows=80 width=134) (never executed)

  • Hash Cond: (replace(replace(topo2g.bsc_name, '+'::text, ''::text), '-'::text, ''::text) = replace(replace(spg2g2.bsc_name, '+'::text, ''::text), '-'::text, ''::text))
6. 0.000 0.000 ↓ 0.0 0

Seq Scan on topologies topo2g (cost=0.00..2,490.36 rows=16,098 width=18) (never executed)

  • Filter: (omc = 'lu2kradio31ch'::text)
7. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.83..10.83 rows=1 width=129) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.27..10.83 rows=1 width=129) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Seq Scan on spago2g3 spg2g3 (cost=0.00..6.58 rows=1 width=56) (never executed)

  • Filter: ((zta330_numberofpagingrequestsontheabisinterfaceperbsc_csservice IS NOT NULL) AND ((zta330_numberofpagingrequestsontheabisinterfaceperbsc_csservice)::text <> '
10. 0.000 0.000 ↓ 0.0 0

Index Scan using ct1_spago2g2 on spago2g2 spg2g2 (cost=0.27..4.24 rows=1 width=73) (never executed)

  • Index Cond: (((resulttime)::text = (spg2g3.resulttime)::text) AND (resulttime IS NOT NULL) AND ((objectname)::text = (spg2g3.objectname)::text))
  • Filter: ((zch900z_internalinter_cellhandoverattemptsperbsc_1800_1900_900_ IS NOT NULL) AND (zch900y_internalinter_cellhandoverattemptsperbsc_900_850_810_18 IS NOT NULL)
Planning time : 1.210 ms
Execution time : 0.298 ms