explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pgtt

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

Nested Loop (cost=0.39..24.50 rows=1 width=3,000) (actual time=0.011..0.011 rows=0 loops=1)

  • Join Filter: ((((ext.firstname)::text ~~* '%%'::text) AND ((ext.middlename)::text ~~* '%%'::text) AND ((ext.surname)::text ~~* '%%'::text) AND ((ext.name)
  • Buffers: shared hit=1
2. 0.000 0.010 ↓ 0.0 0 1

Nested Loop (cost=0.25..16.29 rows=1 width=3,136) (actual time=0.010..0.010 rows=0 loops=1)

  • Join Filter: (((wf.var_rec_1)::text = (ext.itemindex)::text) AND ((wf.var_rec_2)::text = (ext.itemtype)::text))
  • Buffers: shared hit=1
3. 0.010 0.010 ↓ 0.0 0 1

Index Scan using idx7_wfinstrumenttable on wfinstrumenttable wf (cost=0.12..8.14 rows=1 width=3,262) (actual time=0.009..0.010 rows=0 loops=1)

  • Buffers: shared hit=1
4. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ext_prospino on ext_prospino ext (cost=0.12..8.14 rows=1 width=1,142) (never executed)

5. 0.000 0.000 ↓ 0.0 0

Index Scan using indx2_lic_ppldetails_lv on lic_ppldetails_lv ppl (cost=0.14..8.16 rows=1 width=126) (never executed)

  • Index Cond: ((pid)::text = (wf.processinstanceid)::text)