explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uUB9

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

Limit (cost=35.08..35.09 rows=1 width=56) (actual time=0.038..0.038 rows=0 loops=1)

  • Output: itemsupers0_.tmid, gpmitem2_.tiid, lifecyclep3_.lfid, lifecyclep4_.lrid, item5_.tiid, lifecyclep6_.lfid, lifecyclep7_.lrid
  • Buffers: shared hit=8
2. 0.006 0.037 ↓ 0.0 0 1

Sort (cost=35.08..35.09 rows=1 width=56) (actual time=0.037..0.037 rows=0 loops=1)

  • Output: itemsupers0_.tmid, gpmitem2_.tiid, lifecyclep3_.lfid, lifecyclep4_.lrid, item5_.tiid, lifecyclep6_.lfid, lifecyclep7_.lrid
  • Sort Key: itemsupers0_.tmid
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=8
3. 0.000 0.031 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.55..35.07 rows=1 width=56) (actual time=0.031..0.031 rows=0 loops=1)

  • Output: itemsupers0_.tmid, gpmitem2_.tiid, lifecyclep3_.lfid, lifecyclep4_.lrid, item5_.tiid, lifecyclep6_.lfid, lifecyclep7_.lrid
  • Buffers: shared hit=8
4. 0.000 0.031 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.41..34.90 rows=1 width=56) (actual time=0.031..0.031 rows=0 loops=1)

  • Output: itemsupers0_.tmid, gpmitem2_.tiid, lifecyclep3_.lfid, lifecyclep4_.lrid, item5_.tiid, item5_.lrid, lifecyclep6_.lfid
  • Buffers: shared hit=8
5. 0.000 0.031 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.26..34.73 rows=1 width=56) (actual time=0.031..0.031 rows=0 loops=1)

  • Output: itemsupers0_.tmid, gpmitem2_.tiid, lifecyclep3_.lfid, lifecyclep4_.lrid, item5_.tiid, item5_.lfid, item5_.lrid
  • Buffers: shared hit=8
6. 0.000 0.031 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.71..34.01 rows=1 width=54) (actual time=0.031..0.031 rows=0 loops=1)

  • Output: itemsupers0_.tmid, itemsupers0_.tpaliasid, itemsupers0_.tmalitprefix, itemsupers0_.tmalitid, gpmitem2_.tiid, lifecyclep3_.lfid, lifecyclep4_.lrid
  • Buffers: shared hit=8
7. 0.001 0.031 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.56..33.84 rows=1 width=54) (actual time=0.031..0.031 rows=0 loops=1)

  • Output: itemsupers0_.tmid, itemsupers0_.tpaliasid, itemsupers0_.tmalitprefix, itemsupers0_.tmalitid, gpmitem2_.tiid, gpmitem2_.lrid, lifecyclep3_.lfid
  • Buffers: shared hit=8
8. 0.000 0.030 ↓ 0.0 0 1

Nested Loop (cost=1.42..33.67 rows=1 width=54) (actual time=0.030..0.030 rows=0 loops=1)

  • Output: itemsupers0_.tmid, itemsupers0_.tpaliasid, itemsupers0_.tmalitprefix, itemsupers0_.tmalitid, gpmitem2_.tiid, gpmitem2_.lfid, gpmitem2_.lrid
  • Buffers: shared hit=8
9. 0.004 0.030 ↓ 0.0 0 1

Nested Loop (cost=0.99..33.08 rows=1 width=38) (actual time=0.030..0.030 rows=0 loops=1)

  • Output: itemsupers0_.tmid, itemsupers0_.tiid, itemsupers0_.tpaliasid, itemsupers0_.tmalitprefix, itemsupers0_.tmalitid
  • Buffers: shared hit=8
10. 0.010 0.010 ↑ 1.0 1 1

Index Scan using xpktradpaitem_ti on public.tradpaitem_ti item8_ (cost=0.43..8.45 rows=1 width=21) (actual time=0.010..0.010 rows=1 loops=1)

  • Output: item8_.tpid, item8_.tiprefix, item8_.tipaitid
  • Index Cond: (item8_.tiid = '1511342039861'::bigint)
  • Buffers: shared hit=4
11. 0.016 0.016 ↓ 0.0 0 1

Index Scan using xak02traditemal_tm on public.traditemal_tm itemsupers0_ (cost=0.56..24.53 rows=10 width=38) (actual time=0.016..0.016 rows=0 loops=1)

  • Output: itemsupers0_.tmid, itemsupers0_.tmregtim, itemsupers0_.tmregid, itemsupers0_.tmchgtim, itemsupers0_.tmchgid, itemsupers0_.tmreadonly, itemsupers0_.tpaliasid, itemsupers0_.tmalitid, itemsupers0_.tmalityp, itemsupers0_.tiid, itemsupers0_.tmprio, itemsupers0_.tmvlftim, itemsupers0_.tmvlttim, itemsupers0_.tmrepqty, itemsupers0_.tmitname, itemsupers0_.tmstatus, itemsupers0_.tmstruct, itemsupers0_.tmrepltxt, itemsupers0_.tmconscod, itemsupers0_.tmleadti, itemsupers0_.tmleadtyp, itemsupers0_.tmad1var, itemsupers0_.tmad2var, itemsupers0_.tmad3var, itemsupers0_.tmad4var, itemsupers0_.tmad5var, itemsupers0_.tmad6var, itemsupers0_.tmad7var, itemsupers0_.tmad1num, itemsupers0_.tmad2num, itemsupers0_.tmad3num, itemsupers0_.tmad4num, itemsupers0_.tmad5num, itemsupers0_.tmad6num, itemsupers0_.tmad7num, itemsupers0_.tmad1tim, itemsupers0_.tmad2tim, itemsupers0_.tmad3tim, itemsupers0_.tmalitprefix, itemsupers0_.ppid, itemsupers0_.riid
  • Index Cond: ((itemsupers0_.tpaliasid = item8_.tpid) AND ((itemsupers0_.tmalitprefix)::text = (item8_.tiprefix)::text) AND ((itemsupers0_.tmalitid)::text = (item8_.tipaitid)::text))
  • Buffers: shared hit=4
12. 0.000 0.000 ↓ 0.0 0

Index Scan using xpktradpaitem_ti on public.tradpaitem_ti gpmitem2_ (cost=0.43..0.58 rows=1 width=24) (never executed)

  • Output: gpmitem2_.tiid, gpmitem2_.lfid, gpmitem2_.lrid
  • Index Cond: (gpmitem2_.tiid = itemsupers0_.tiid)
13. 0.000 0.000 ↓ 0.0 0

Index Only Scan using xpklifecycleprofile_lf on public.lifecycleprofile_lf lifecyclep3_ (cost=0.14..0.16 rows=1 width=8) (never executed)

  • Output: lifecyclep3_.lfid
  • Index Cond: (lifecyclep3_.lfid = gpmitem2_.lfid)
  • Heap Fetches: 0
14. 0.000 0.000 ↓ 0.0 0

Index Only Scan using xpklifecyclematcher_lr on public.lifecyclematcher_lr lifecyclep4_ (cost=0.14..0.16 rows=1 width=8) (never executed)

  • Output: lifecyclep4_.lrid
  • Index Cond: (lifecyclep4_.lrid = gpmitem2_.lrid)
  • Heap Fetches: 0
15. 0.000 0.000 ↓ 0.0 0

Index Scan using xak1tradpaitem_ti on public.tradpaitem_ti item5_ (cost=0.56..0.72 rows=1 width=45) (never executed)

  • Output: item5_.tiid, item5_.tpid, item5_.tiprefix, item5_.tipaitid, item5_.lfid, item5_.lrid
  • Index Cond: (((itemsupers0_.tmalitid)::text = (item5_.tipaitid)::text) AND ((itemsupers0_.tmalitprefix)::text = (item5_.tiprefix)::text) AND (itemsupers0_.tpaliasid = item5_.tpid))
16. 0.000 0.000 ↓ 0.0 0

Index Only Scan using xpklifecycleprofile_lf on public.lifecycleprofile_lf lifecyclep6_ (cost=0.14..0.16 rows=1 width=8) (never executed)

  • Output: lifecyclep6_.lfid
  • Index Cond: (lifecyclep6_.lfid = item5_.lfid)
  • Heap Fetches: 0
17. 0.000 0.000 ↓ 0.0 0

Index Only Scan using xpklifecyclematcher_lr on public.lifecyclematcher_lr lifecyclep7_ (cost=0.14..0.16 rows=1 width=8) (never executed)

  • Output: lifecyclep7_.lrid
  • Index Cond: (lifecyclep7_.lrid = item5_.lrid)
  • Heap Fetches: 0
Planning time : 55.564 ms
Execution time : 0.135 ms