explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ndlu

Settings
# exclusive inclusive rows x rows loops node
1. 0.609 17.853 ↓ 87.0 87 1

Sort (cost=2,949.35..2,949.35 rows=1 width=625) (actual time=17.779..17.853 rows=87 loops=1)

  • Sort Key: bsc.orgshort, a.actdate DESC, a.stime DESC, b.eventdesc
  • Sort Method: quicksort Memory: 69kB
2. 0.813 17.244 ↓ 87.0 87 1

Nested Loop Left Join (cost=758.97..2,949.34 rows=1 width=625) (actual time=12.521..17.244 rows=87 loops=1)

  • Join Filter: (a.apflag = (ff.itemid)::bpchar)
  • Rows Removed by Join Filter: 609
3. 0.286 15.300 ↓ 87.0 87 1

Nested Loop (cost=758.70..2,941.02 rows=1 width=561) (actual time=12.499..15.300 rows=87 loops=1)

  • Join Filter: ((a.orgid)::text = (bsc.orgid)::text)
4. 0.599 14.579 ↓ 87.0 87 1

Nested Loop (cost=758.56..2,940.83 rows=1 width=555) (actual time=12.490..14.579 rows=87 loops=1)

  • Join Filter: (((a.actid)::text = (b.actid)::text) AND ((a.actdate)::text = (b.actdate)::text) AND ((a.stime)::text = (b.stime)::text) AND ((a.etime)::text = (b.etime)::text))
  • Rows Removed by Join Filter: 251
5. 0.239 12.936 ↓ 6.7 87 1

Hash Join (cost=758.14..2,923.33 rows=13 width=561) (actual time=12.466..12.936 rows=87 loops=1)

  • Hash Cond: (((a.orgid)::text = (c.orgid)::text) AND ((a.actid)::text = (c.actid)::text))
6. 0.289 0.321 ↑ 7.2 87 1

Bitmap Heap Scan on act_bsc_apply a (cost=22.49..2,182.88 rows=623 width=478) (actual time=0.048..0.321 rows=87 loops=1)

  • Recheck Cond: (lower((insop)::text) = 'yifang0203@gmail.com'::text)
  • Filter: (((actdate)::text >= '2019-01-01'::text) AND ((actdate)::text <= '2019-04-01'::text))
  • Rows Removed by Filter: 15
  • Heap Blocks: exact=61
7. 0.032 0.032 ↑ 7.7 102 1

Bitmap Index Scan on act_bsc_apply_idx_2 (cost=0.00..22.34 rows=789 width=0) (actual time=0.031..0.032 rows=102 loops=1)

  • Index Cond: (lower((insop)::text) = 'yifang0203@gmail.com'::text)
8. 6.165 12.376 ↑ 1.0 5,706 1

Hash (cost=650.06..650.06 rows=5,706 width=83) (actual time=12.375..12.376 rows=5,706 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 710kB
9. 6.211 6.211 ↑ 1.0 5,706 1

Seq Scan on act_bsc_main c (cost=0.00..650.06 rows=5,706 width=83) (actual time=0.009..6.211 rows=5,706 loops=1)

10. 1.044 1.044 ↑ 1.2 4 87

Index Scan using pk_act_bsc_event on act_bsc_event b (cost=0.41..1.25 rows=5 width=79) (actual time=0.009..0.012 rows=4 loops=87)

  • Index Cond: ((actid)::text = (c.actid)::text)
11. 0.435 0.435 ↑ 1.0 1 87

Index Scan using nps_bsc_org_pkey on nps_bsc_org bsc (cost=0.14..0.18 rows=1 width=18) (actual time=0.004..0.005 rows=1 loops=87)

  • Index Cond: ((orgid)::text = (c.orgid)::text)
12. 1.131 1.131 ↓ 8.0 8 87

Index Scan using pk_sys_bsc_item on sys_bsc_item ff (cost=0.27..8.29 rows=1 width=16) (actual time=0.006..0.013 rows=8 loops=87)

  • Index Cond: (((tbln)::text = 'act_bsc_apply'::text) AND ((coln)::text = 'apflag'::text))
  • Filter: (dispflag = 'A'::bpchar)
  • Rows Removed by Filter: 1