explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z4Jh

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 11.655 ↑ 1.0 30 1

Limit (cost=210.62..210.70 rows=30 width=192) (actual time=11.646..11.655 rows=30 loops=1)

  • Output: e."productInfo", NULL::bigint, e."fldUpdateTime", NULL::character varying, NULL::character varying, NULL::character varying, NULL::character varying, NULL::bigint, NULL::bigint
  • Buffers: shared hit=122
2. 0.419 11.651 ↑ 44.1 30 1

Sort (cost=210.62..213.93 rows=1,322 width=192) (actual time=11.645..11.651 rows=30 loops=1)

  • Output: e."productInfo", NULL::bigint, e."fldUpdateTime", NULL::character varying, NULL::character varying, NULL::character varying, NULL::character varying, NULL::bigint, NULL::bigint
  • Sort Key: e."fldUpdateTime" DESC
  • Sort Method: top-N heapsort Memory: 137kB
  • Buffers: shared hit=122
3. 0.093 11.232 ↑ 2.7 493 1

Subquery Scan on e (cost=145.14..171.58 rows=1,322 width=192) (actual time=11.031..11.232 rows=493 loops=1)

  • Output: e."productInfo", NULL::bigint, e."fldUpdateTime", NULL::character varying, NULL::character varying, NULL::character varying, NULL::character varying, NULL::bigint, NULL::bigint
  • Buffers: shared hit=122
4. 2.761 11.139 ↑ 2.7 493 1

HashAggregate (cost=145.14..158.36 rows=1,322 width=82) (actual time=11.030..11.139 rows=493 loops=1)

  • Output: ((p.json_data)::text), p."fldUpdateTime", p."fldSerialNumber", p."fldProductName", p.scan_time
  • Group Key: ((p.json_data)::text), p."fldUpdateTime", p."fldSerialNumber", p."fldProductName", p.scan_time
  • Buffers: shared hit=122
5. 2.668 8.378 ↑ 2.8 493 1

Sort (cost=110.14..113.64 rows=1,400 width=266) (actual time=8.068..8.378 rows=493 loops=1)

  • Output: ((p.json_data)::text), p."fldUpdateTime", p."fldSerialNumber", p."fldProductName", p.scan_time, NULL::text, p."fldUpdateTime", NULL::character varying, NULL::character varying, NULL::character varying, NULL::character varying, NULL::bigint, NULL::bigint
  • Sort Key: p."fldUpdateTime" DESC
  • Sort Method: quicksort Memory: 1860kB
  • Buffers: shared hit=122
6. 2.638 5.710 ↑ 2.8 493 1

Nested Loop (cost=0.29..36.98 rows=1,400 width=266) (actual time=0.070..5.710 rows=493 loops=1)

  • Output: (p.json_data)::text, p."fldUpdateTime", p."fldSerialNumber", p."fldProductName", p.scan_time, NULL::text, p."fldUpdateTime", NULL::character varying, NULL::character varying, NULL::character varying, NULL::character varying, NULL::bigint, NULL::bigint
  • Buffers: shared hit=122
7. 1.593 1.593 ↓ 35.2 493 1

Index Scan using ix_mvw_product_info_scan_time on public.mvw_product_info p (cost=0.28..1.97 rows=14 width=1,322) (actual time=0.043..1.593 rows=493 loops=1)

  • Output: p."fldProductId", p.cid, p."brandId", p."fldGroupId", p."fldProductName", p."fldSerialNumber", p."fldStoreShelvesName", p."fldProductStatus", p."shareBrandKeys", p."fldUpdateTime", p."sizeSetId", p."subGroup", p."sizeSetCustomizeId", p.scan_time, p.fld_scan_status, p.pipeline_status, p."productTags", p."mainId", p."subId", p.json_data
  • Index Cond: ((p.scan_time >= '1554825600000'::bigint) AND (p.scan_time <= '1562687999999'::bigint))
  • Filter: (p."fldProductStatus" = ANY ('{2,1}'::smallint[]))
  • Buffers: shared hit=122
8. 1.479 1.479 ↑ 100.0 1 493

Function Scan on pg_catalog.unnest t (cost=0.01..1.00 rows=100 width=0) (actual time=0.002..0.003 rows=1 loops=493)

  • Output: t.tags
  • Function Call: unnest(COALESCE(NULLIF(p."productTags", '{}'::text[]), '{""}'::text[]))
Planning time : 1.257 ms