explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WQcH

Settings
# exclusive inclusive rows x rows loops node
1. 245.988 1,603.038 ↑ 1.0 1 1

Gather (cost=1,000.00..262,618.64 rows=1 width=426) (actual time=1,598.795..1,603.038 rows=1 loops=1)

  • Output: aoguid, formalname, regioncode, autocode, areacode, citycode, ctarcode, placecode, plancode, streetcode, extrcode, sextcode, offname, postalcode, ifnsfl, terrifnsfl, ifnsul, terrifnsul, okato, oktmo, updatedate, shortname, aolevel, parentguid, aoid, previd, nextid, code, plaincode, actstatus, centstatus, operstatus, currstatus, startdate, enddate, normdoc, livestatus, divtype
  • Workers Planned: 2
  • Workers Launched: 2
  • JIT for worker 0:
  • Functions: 2
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 1.766 ms, Inlining 0.000 ms, Optimization 1.970 ms, Emission 15.472 ms, Total 19.208 ms
  • JIT for worker 1:
  • Functions: 2
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 2.116 ms, Inlining 0.000 ms, Optimization 2.305 ms, Emission 19.264 ms, Total 23.685 ms
  • Functions: 6
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 4.990 ms, Inlining 0.000 ms, Optimization 5.226 ms, Emission 44.173 ms, Total 54.389 ms
2. 1,357.050 1,357.050 ↓ 0.0 0 3 / 3

Parallel Seq Scan on fias.addrobj a (cost=0.00..261,618.54 rows=1 width=426) (actual time=923.986..1,357.050 rows=0 loops=3)

  • Output: aoguid, formalname, regioncode, autocode, areacode, citycode, ctarcode, placecode, plancode, streetcode, extrcode, sextcode, offname, postalcode, ifnsfl, terrifnsfl, ifnsul, terrifnsul, okato, oktmo, updatedate, shortname, aolevel, parentguid, aoid, previd, nextid, code, plaincode, actstatus, centstatus, operstatus, currstatus, startdate, enddate, normdoc, livestatus, divtype
  • Filter: ((a.aolevel = 7) AND (a.actstatus = 1) AND ((a.parentguid)::text = '0c5b2444-70a0-4932-980c-b4dc0d3f02b5'::text) AND (lower((a.formalname)::text) ~* 'краснобогатырская'::text))
  • Rows Removed by Filter: 1414739
  • Worker 0: actual time=1147.442..1147.443 rows=0 loops=1
  • Worker 1: actual time=27.267..1326.457 rows=1 loops=1
Execution time : 1,604.296 ms