explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cjvb

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 10,877.927 ↑ 45.0 1 1

Limit (cost=0.22..760.57 rows=45 width=236) (actual time=4,416.355..10,877.927 rows=1 loops=1)

2. 10,877.922 10,877.922 ↑ 29,691.0 1 1

Index Scan using _reference1745_5 on _reference1745 t1 (cost=0.22..501,674.08 rows=29,691 width=236) (actual time=4,416.353..10,877.922 rows=1 loops=1)

  • Index Cond: (_fld1922 = '0'::numeric)
  • Filter: (_fld1746 ~~ '%38040101%'::mvarchar)
  • Rows Removed by Filter: 5950323