explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3Vlc

Settings
# exclusive inclusive rows x rows loops node
1. 26.096 13,445.049 ↓ 16.0 32 1

Unique (cost=330.13..330.25 rows=2 width=528) (actual time=13,417.633..13,445.049 rows=32 loops=1)

  • Output: t001.column2, t004.column9, t002.column2, t002.column3, t001.column11, t004.column1, t011.column1, (DECODE( t003.column35 , nvl(t015.column1, '@ET006TY@'::character varying) , t015.column4 , nvl(t001.column9, t004.column6) )), (DECODE( t003.column35 , nvl(t015.column1, '@ET006TY@'::character varying) , (((((t015.column5)::text || ' ( '::text) || (t012.column3)::text) || ' )'::text))::character varying , nvl(nvl(nvl(t001.column10, t001.column9), ((SubPlan 1))::character varying), t004.column9) )), (nvl(t003.column5, t001.column3)), t013.column3, (CASE WHEN (t003.column35 IS NULL) THEN DECODE( t004.column6 , t001.column9 , '1'::character varying , '2'::character varying ) ELSE t015.column5 END), t003.column10, t014a.column3, t014a.column4, t012.column3, t001.column7, t001.column5, t001.column6, t001.column1, t014a.column4, t004.column6, t003.column35, t015.column4, t014b.column3
  • Buffers: shared hit=1,249,258 read=8,011
2. 185.073 13,418.953 ↓ 2,430.0 4,860 1

Sort (cost=330.13..330.14 rows=2 width=528) (actual time=13,417.629..13,418.953 rows=4,860 loops=1)

  • Output: t001.column2, t004.column9, t002.column2, t002.column3, t001.column11, t004.column1, t011.column1, (DECODE( t003.column35 , nvl(t015.column1, '@ET006TY@'::character varying) , t015.column4 , nvl(t001.column9, t004.column6) )), (DECODE( t003.column35 , nvl(t015.column1, '@ET006TY@'::character varying) , (((((t015.column5)::text || ' ( '::text) || (t012.column3)::text) || ' )'::text))::character varying , nvl(nvl(nvl(t001.column10, t001.column9), ((SubPlan 1))::character varying), t004.column9) )), (nvl(t003.column5, t001.column3)), t013.column3, (CASE WHEN (t003.column35 IS NULL) THEN DECODE( t004.column6 , t001.column9 , '1'::character varying , '2'::character varying ) ELSE t015.column5 END), t003.column10, t014a.column3, t014a.column4, t012.column3, t001.column7, t001.column5, t001.column6, t001.column1, t014a.column4, t004.column6, t003.column35, t015.column4, t014b.column3
  • Sort Key: t001.column2, t004.column9, t002.column2, t002.column3, t001.column11, t004.column1, (DECODE( t003.column35 , nvl(t015.column1, '@ET006TY@'::character varying) , t015.column4 , nvl(t001.column9, t004.column6) )), (DECODE( t003.column35 , nvl(t015.column1, '@ET006TY@'::character varying) , (((((t015.column5)::text || ' ( '::text) || (t012.column3)::text) || ' )'::text))::character varying , nvl(nvl(nvl(t001.column10, t001.column9), ((SubPlan 1))::character varying), t004.column9) )), (nvl(t003.column5, t001.column3)), t013.column3, (CASE WHEN (t003.column35 IS NULL) THEN DECODE( t004.column6 , t001.column9 , '1'::character varying , '2'::character varying ) ELSE t015.column5 END), t003.column10, t014a.column3, t014a.column4, t001.column7, t001.column5, t001.column6, t001.column1, t004.column6, t003.column35, t015.column4, t014b.column3
  • Sort Method: quicksort Memory: 2,698kB
  • Buffers: shared hit=1,249,258 read=8,011
3. 360.507 13,233.880 ↓ 2,430.0 4,860 1

Nested Loop (cost=12.30..330.12 rows=2 width=528) (actual time=501.382..13,233.880 rows=4,860 loops=1)

  • Output: t001.column2, t004.column9, t002.column2, t002.column3, t001.column11, t004.column1, t011.column1, DECODE( t003.column35 , nvl(t015.column1, '@ET006TY@'::character varying) , t015.column4 , nvl(t001.column9, t004.column6) ), DECODE( t003.column35 , nvl(t015.column1, '@ET006TY@'::character varying) , (((((t015.column5)::text || ' ( '::text) || (t012.column3)::text) || ' )'::text))::character varying , nvl(nvl(nvl(t001.column10, t001.column9), ((SubPlan 1))::character varying), t004.column9) ), nvl(t003.column5, t001.column3), t013.column3, CASE WHEN (t003.column35 IS NULL) THEN DECODE( t004.column6 , t001.column9 , '1'::character varying , '2'::character varying ) ELSE t015.column5 END, t003.column10, t014a.column3, t014a.column4, t012.column3, t001.column7, t001.column5, t001.column6, t001.column1, t014a.column4, t004.column6, t003.column35, t015.column4, t014b.column3
  • Join Filter: ((t012.column14)::text = (t014b.column1)::text)
  • Rows Removed by Join Filter: 374,220
  • Buffers: shared hit=1,249,255 read=8,011
4. 11.030 12,466.753 ↓ 1,620.0 1,620 1

Nested Loop Left Join (cost=12.30..297.15 rows=1 width=791) (actual time=500.028..12,466.753 rows=1,620 loops=1)

  • Output: t001.column2, t001.column11, t001.column9, t001.column10, t001.column3, t001.column7, t001.column5, t001.column6, t001.column1, t002.column2, t002.column3, t003.column35, t003.column5, t003.column10, t004.column9, t004.column1, t004.column6, t011.column1, t012.column3, t012.column14, t013.column3, t014a.column3, t014a.column4, t015.column1, t015.column4, t015.column5
  • Join Filter: ((t003.column2)::text = (t004.column1)::text)
  • Buffers: shared hit=1,226,581 read=8,005
5. 3.064 12,450.863 ↓ 1,620.0 1,620 1

Nested Loop Left Join (cost=12.16..295.83 rows=1 width=390) (actual time=499.994..12,450.863 rows=1,620 loops=1)

  • Output: t001.column2, t001.column11, t001.column9, t001.column10, t001.column3, t001.column7, t001.column5, t001.column6, t001.column1, t002.column2, t002.column3, t003.column35, t003.column5, t003.column10, t003.column2, t004.column9, t004.column1, t004.column6, t011.column1, t012.column3, t012.column14, t013.column3, t014a.column3, t014a.column4
  • Buffers: shared hit=1,224,961 read=8,005
6. 1.741 12,433.399 ↓ 576.0 576 1

Nested Loop Left Join (cost=11.89..295.52 rows=1 width=370) (actual time=499.351..12,433.399 rows=576 loops=1)

  • Output: t001.column2, t001.column11, t001.column9, t001.column10, t001.column3, t001.column7, t001.column5, t001.column6, t001.column1, t002.column2, t002.column3, t003.column35, t003.column5, t003.column10, t003.column2, t004.column9, t004.column1, t004.column6, t011.column1, t012.column3, t012.column14, t013.column3
  • Buffers: shared hit=1,222,947 read=8,003
7. 1.870 12,422.442 ↓ 288.0 288 1

Nested Loop (cost=11.62..292.01 rows=1 width=400) (actual time=498.413..12,422.442 rows=288 loops=1)

  • Output: t001.column2, t001.column11, t001.column9, t001.column10, t001.column3, t001.column7, t001.column5, t001.column6, t001.column1, t002.column2, t002.column3, t003.column35, t003.column5, t003.column10, t003.column2, t004.column9, t004.column1, t004.column6, t004.column16, t011.column1, t012.column3, t012.column14
  • Join Filter: ((t001.column5)::text = (t012.column1)::text)
  • Buffers: shared hit=1,221,798 read=8,000
8. 0.778 12,415.100 ↓ 288.0 288 1

Nested Loop (cost=11.62..290.86 rows=1 width=364) (actual time=497.973..12,415.100 rows=288 loops=1)

  • Output: t001.column2, t001.column11, t001.column9, t001.column10, t001.column3, t001.column7, t001.column5, t001.column6, t001.column1, t002.column2, t002.column3, t003.column35, t003.column5, t003.column10, t003.column2, t004.column9, t004.column1, t004.column6, t004.column16, t011.column1
  • Buffers: shared hit=1,221,511 read=7,999
9. 1.136 12,403.090 ↓ 288.0 288 1

Nested Loop (cost=11.34..282.54 rows=1 width=364) (actual time=494.809..12,403.090 rows=288 loops=1)

  • Output: t001.column2, t001.column11, t001.column9, t001.column10, t001.column3, t001.column7, t001.column5, t001.column6, t001.column1, t002.column2, t002.column3, t003.column35, t003.column5, t003.column10, t003.column2, t004.column9, t004.column1, t004.column6, t004.column16, t010.column2
  • Buffers: shared hit=1,220,650 read=7,996
10. 266.177 12,392.738 ↓ 288.0 288 1

Nested Loop (cost=10.92..281.10 rows=1 width=430) (actual time=493.939..12,392.738 rows=288 loops=1)

  • Output: t001.column2, t001.column11, t001.column9, t001.column10, t001.column3, t001.column7, t001.column5, t001.column6, t001.column1, t002.column2, t002.column3, t003.column35, t003.column5, t003.column10, t003.column2, t004.column9, t004.column1, t004.column6, t004.column16, t008.column2, t010.column3, t010.column2
  • Buffers: shared hit=1,219,500 read=7,994
11. 181.099 7,332.459 ↓ 141,003.0 141,003 1

Nested Loop (cost=10.51..279.72 rows=1 width=364) (actual time=16.077..7,332.459 rows=141,003 loops=1)

  • Output: t001.column2, t001.column11, t001.column9, t001.column10, t001.column3, t001.column7, t001.column5, t001.column6, t001.column1, t002.column2, t002.column3, t003.column35, t003.column5, t003.column10, t003.column2, t004.column9, t004.column1, t004.column6, t004.column16, t008.column2
  • Buffers: shared hit=493,056 read=7,328
12. 95.162 4,217.135 ↓ 27,945.0 27,945 1

Nested Loop (cost=10.09..269.33 rows=1 width=364) (actual time=14.410..4,217.135 rows=27,945 loops=1)

  • Output: t001.column2, t001.column11, t001.column9, t001.column10, t001.column3, t001.column7, t001.column5, t001.column6, t001.column1, t002.column2, t002.column3, t003.column35, t003.column5, t003.column10, t003.column2, t004.column9, t004.column1, t004.column6, t004.column16, t005.column1
  • Buffers: shared hit=280,846 read=1,441
13. 205.672 3,451.293 ↓ 27,945.0 27,945 1

Nested Loop (cost=9.81..262.91 rows=1 width=282) (actual time=13.778..3,451.293 rows=27,945 loops=1)

  • Output: t001.column2, t001.column11, t001.column9, t001.column10, t001.column3, t001.column7, t001.column5, t001.column6, t001.column1, t002.column2, t002.column3, t003.column35, t003.column5, t003.column10, t003.column2, t005.column1
  • Join Filter: ((t001.column4)::text = (t002.column1)::text)
  • Rows Removed by Join Filter: 55,890
  • Buffers: shared hit=196,847 read=1,200
14. 97.595 2,127.821 ↓ 27,945.0 27,945 1

Nested Loop (cost=9.81..261.56 rows=1 width=300) (actual time=13.711..2,127.821 rows=27,945 loops=1)

  • Output: t001.column2, t001.column11, t001.column9, t001.column10, t001.column3, t001.column7, t001.column5, t001.column6, t001.column1, t001.column4, t003.column35, t003.column5, t003.column10, t003.column2, t005.column1
  • Buffers: shared hit=168,902 read=1,200
15. 131.875 1,178.718 ↓ 27,468.0 27,468 1

Nested Loop (cost=9.52..253.98 rows=1 width=158) (actual time=12.658..1,178.718 rows=27,468 loops=1)

  • Output: t003.column35, t003.column5, t003.column10, t003.column3, t003.column2, t005.column1
  • Buffers: shared hit=86,486 read=762
16. 20.081 195.335 ↓ 9,156.0 27,468 1

Nested Loop (cost=9.24..252.79 rows=3 width=66) (actual time=11.250..195.335 rows=27,468 loops=1)

  • Output: t005.column2, t005.column1
  • Buffers: shared hit=3,949 read=490
17. 0.042 2.382 ↓ 9.0 9 1

Nested Loop (cost=4.30..16.06 rows=1 width=33) (actual time=1.961..2.382 rows=9 loops=1)

  • Output: t006.column1
  • Join Filter: ((t006.column16)::text = (t007.column1)::text)
  • Buffers: shared hit=6 read=5
18. 0.861 1.956 ↓ 3.0 3 1

Bitmap Heap Scan on ebbase.t006 (cost=4.30..12.95 rows=1 width=66) (actual time=1.916..1.956 rows=3 loops=1)

  • Output: t006.column1, t006.column2, t006.column3, t006.column4, t006.column5, t006.column6, t006.column7, t006.column8, t006.column9, t006.column10, t006.column11, t006.column12, t006.column13, t006.column14, t006.column15, t006.column16, t006.column17, t006.column18, t006.column19, t006.column20, t006.column21, t006.column22, t006.column23, t006.column24, t006.column25, t006.column26, t006.column27, t006.column28, t006.column29, t006.column30, t006.column31, t006.column32, t006.column33, t006.column34, t006.column35, t006.column36, t006.column37, t006.column38, t006.column39, t006.column40, t006.column41, t006.column42, t006.column43, t006.column44
  • Recheck Cond: ((t006.column2)::text = 'PORT001'::text)
  • Filter: ((nvl(t006.column20, 'N'::character varying))::text = 'N'::text)
  • Heap Blocks: exact=3
  • Buffers: shared hit=1 read=4
19. 1.095 1.095 ↑ 1.0 3 1

Bitmap Index Scan on "uk_t_t006#column2" (cost=0.00..4.29 rows=3 width=0) (actual time=1.095..1.095 rows=3 loops=1)

  • Index Cond: ((t006.column2)::text = 'PORT001'::text)
  • Buffers: shared read=2
20. 0.384 0.384 ↓ 3.0 3 3

Seq Scan on ebbase.t007 (cost=0.00..3.10 rows=1 width=33) (actual time=0.018..0.128 rows=3 loops=3)

  • Output: t007.column1, t007.column2, t007.column3, t007.column4, t007.column5, t007.column6, t007.column7, t007.column8, t007.column9, t007.column10, t007.column11, t007.column12, t007.column13, t007.column14, t007.column15, t007.column16, t007.column17, t007.column18, t007.column19, t007.column20, t007.column21, t007.column22
  • Filter: (((t007.column2)::text = 'PORT'::text) AND ((nvl(t007.column16, 'N'::character varying))::text = 'N'::text))
  • Rows Removed by Filter: 60
  • Buffers: shared hit=5 read=1
21. 156.825 172.872 ↓ 35.9 3,052 9

Bitmap Heap Scan on ebbase.t005 (cost=4.94..235.88 rows=85 width=99) (actual time=2.401..19.208 rows=3,052 loops=9)

  • Output: t005.column1, t005.column2, t005.column3, t005.column4, t005.column5, t005.column6, t005.column7, t005.column8, t005.column9, t005.column10, t005.column11, t005.column12, t005.column13, t005.column14, t005.column15, t005.column16
  • Recheck Cond: ((t005.column3)::text = (t006.column1)::text)
  • Filter: ((nvl(t005.column7, 'N'::character varying))::text = 'N'::text)
  • Heap Blocks: exact=4,212
  • Buffers: shared hit=3,943 read=485
22. 16.047 16.047 ↓ 35.9 3,052 9

Bitmap Index Scan on "ix_t005#column3" (cost=0.00..4.92 rows=85 width=0) (actual time=1.783..1.783 rows=3,052 loops=9)

  • Index Cond: ((t005.column3)::text = (t006.column1)::text)
  • Buffers: shared hit=193 read=23
23. 851.508 851.508 ↑ 1.0 1 27,468

Index Scan using "pk_t003#column1" on ebbase.t003 (cost=0.28..0.39 rows=1 width=158) (actual time=0.029..0.031 rows=1 loops=27,468)

  • Output: t003.column1, t003.column2, t003.column3, t003.column4, t003.column5, t003.column6, t003.column7, t003.column8, t003.column9, t003.column10, t003.column11, t003.column12, t003.column13, t003.column14, t003.column15, t003.column16, t003.column17, t003.column18, t003.column19, t003.column20, t003.column21, t003.column22, t003.column23, t003.column24, t003.column25, t003.column26, t003.column27, t003.column28, t003.column29, t003.column30, t003.column31, t003.column32, t003.column33, t003.column34, t003.column35, t003.column36
  • Index Cond: ((t003.column1)::text = (t005.column2)::text)
  • Filter: ((nvl(t003.column20, 'N'::character varying))::text = 'N'::text)
  • Buffers: shared hit=82,537 read=272
24. 851.508 851.508 ↑ 1.0 1 27,468

Index Scan using "pk_t001#column1" on ebbase.t001 (cost=0.29..7.57 rows=1 width=175) (actual time=0.030..0.031 rows=1 loops=27,468)

  • Output: t001.column1, t001.column2, t001.column3, t001.column4, t001.column5, t001.column6, t001.column7, t001.column8, t001.column9, t001.column10, t001.column11, t001.column12, t001.column13, t001.column14, t001.column15, t001.column16, t001.column17, t001.column18, t001.column19, t001.column20, t001.column21, t001.column22, t001.column23, t001.column24, t001.column25, t001.column26, t001.column27, t001.column28, t001.column29, t001.column30, t001.column31, t001.column32, t001.column33, t001.column34, t001.column35, t001.column36, t001.column37, t001.column38, t001.column39, t001.column40, t001.column41, t001.column42, t001.column43, t001.column44, t001.column45, t001.column46, t001.column47, t001.column48, t001.column49, t001.column50
  • Index Cond: ((t001.column1)::text = (t003.column3)::text)
  • Filter: ((nvl(t001.column12, 'N'::character varying))::text = 'N'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=82,416 read=438
25. 1,117.800 1,117.800 ↓ 3.0 3 27,945

Seq Scan on ebbase.t002 (cost=0.00..1.34 rows=1 width=48) (actual time=0.007..0.040 rows=3 loops=27,945)

  • Output: t002.column1, t002.column2, t002.column3, t002.column4, t002.column5, t002.column6, t002.column7, t002.column8, t002.column9, t002.column10, t002.column11, t002.column12, t002.column13, t002.column14, t002.column15, t002.column16, t002.column17, t002.column18, t002.column19, t002.column20, t002.column21, t002.column22, t002.column23
  • Filter: (((t002.column2)::text = ANY ('{01,05,18}'::text[])) AND ((nvl(t002.column16, 'N'::character varying))::text = 'N'::text))
  • Rows Removed by Filter: 15
  • Buffers: shared hit=27,945
26. 670.680 670.680 ↑ 1.0 1 27,945

Index Scan using "pk_t004#column1" on ebbase.t004 (cost=0.28..6.41 rows=1 width=82) (actual time=0.023..0.024 rows=1 loops=27,945)

  • Output: t004.column1, t004.column2, t004.column3, t004.column4, t004.column5, t004.column6, t004.column7, t004.column8, t004.column9, t004.column10, t004.column11, t004.column12, t004.column13, t004.column14, t004.column15, t004.column16, t004.column17, t004.column18, t004.column19, t004.column20, t004.column21, t004.column22, t004.column23, t004.column24, t004.column25, t004.column26, t004.column27, t004.column28, t004.column29, t004.column30, t004.column31, t004.column32, t004.column33, t004.column34, t004.column35, t004.column36, t004.column37, t004.column38, t004.column39, t004.column40, t004.column41, t004.column42, t004.column43, t004.column44, t004.column45, t004.column46, t004.column47, t004.column48, t004.column49, t004.column50, t004.column51, t004.column52, t004.column53, t004.column54, t004.column55, t004.column56, t004.column57, t004.column58, t004.column59, t004.column60, t004.column61, t004.column62, t004.column63, t004.column64, t004.column65, t004.column66, t004.column67, t004.column68, t004.column69, t004.column70, t004.column71, t004.column72, t004.column73, t004.column74, t004.column75, t004.column76, t004.column77, t004.column78, t004.column79, t004.column80, t004.column81, t004.column82, t004.column83, t004.column84, t004.column85, t004.column86, t004.column87, t004.column88, t004.column89, t004.column90, t004.column91, t004.column92
  • Index Cond: ((t004.column1)::text = (t003.column2)::text)
  • Filter: ((nvl(t004.column35, 'N'::character varying))::text = 'N'::text)
  • Buffers: shared hit=83,999 read=241
27. 2,934.225 2,934.225 ↓ 5.0 5 27,945

Index Scan using "ix_t008#c#01" on ebbase.t008 (cost=0.42..10.38 rows=1 width=66) (actual time=0.060..0.105 rows=5 loops=27,945)

  • Output: t008.column1, t008.column2, t008.column3, t008.column4, t008.column5, t008.column6, t008.column7, t008.column8, t008.column9, t008.column10, t008.column11, t008.column12, t008.column13, t008.column14, t008.column15, t008.column16, t008.column17, t008.column18, t008.column19, t008.column20, t008.column21, t008.column22
  • Index Cond: ((t008.column3)::text = (t005.column1)::text)
  • Filter: ((nvl(t008.column5, 'N'::character varying))::text = 'N'::text)
  • Buffers: shared hit=212,210 read=5,887
28. 4,794.102 4,794.102 ↓ 0.0 0 141,003

Index Scan using "ix_t010#cugi" on ebbase.t010 (cost=0.41..1.37 rows=1 width=66) (actual time=0.034..0.034 rows=0 loops=141,003)

  • Output: t010.column1, t010.column2, t010.column3, t010.column4, t010.column5, t010.column6, t010.column7, t010.column8, t010.column9, t010.column10, t010.column11, t010.column12, t010.column13, t010.column14, t010.column15, t010.column16, t010.column17, t010.column18, t010.column19, t010.column20
  • Index Cond: ((t010.column3)::text = (t008.column2)::text)
  • Filter: (((t010.column2)::text = '0D5447C11AE0440F971CA9786269DC6E'::text) AND ((nvl(t010.column5, 'N'::character varying))::text = 'N'::text))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=726,444 read=666
29. 9.216 9.216 ↑ 1.0 1 288

Index Scan using "pk_t009#column1" on ebbase.t009 (cost=0.41..1.43 rows=1 width=33) (actual time=0.030..0.032 rows=1 loops=288)

  • Output: t009.column1, t009.column2, t009.column3, t009.column4, t009.column5, t009.column6, t009.column7, t009.column8, t009.column9, t009.column10, t009.column11, t009.column12, t009.column13, t009.column14, t009.column15, t009.column16, t009.column17, t009.column18, t009.column19, t009.column20, t009.column21, t009.column22, t009.column23, t009.column24, t009.column25, t009.column26, t009.column27, t009.column28, t009.column29, t009.column30, t009.column31, t009.column32, t009.column33, t009.column34, t009.column35, t009.column36, t009.column37
  • Index Cond: ((t009.column1)::text = (t008.column2)::text)
  • Filter: ((nvl(t009.column17, 'N'::character varying))::text = 'N'::text)
  • Buffers: shared hit=1,150 read=2
30. 11.232 11.232 ↑ 1.0 1 288

Index Scan using "pk_t011#column1" on ebbase.t011 (cost=0.29..8.31 rows=1 width=33) (actual time=0.037..0.039 rows=1 loops=288)

  • Output: t011.column1, t011.column2, t011.column3, t011.column4, t011.column5, t011.column6, t011.column7, t011.column8, t011.column9, t011.column10, t011.column11, t011.column12, t011.column13, t011.column14, t011.column15, t011.column16, t011.column17, t011.column18, t011.column19, t011.column20, t011.column21, t011.column22, t011.column23, t011.column24, t011.column25, t011.column26, t011.column27, t011.column28, t011.column29, t011.column30, t011.column31, t011.column32, t011.column33, t011.column34, t011.column35, t011.column36, t011.column37, t011.column38, t011.column39, t011.column40, t011.column41, t011.column42, t011.column43, t011.column44, t011.column45, t011.column46, t011.column47, t011.column48, t011.column49, t011.column50, t011.column51, t011.column52, t011.column53, t011.column54, t011.column55, t011.column56, t011.column57, t011.column58, t011.column59, t011.column60, t011.column61
  • Index Cond: ((t011.column1)::text = '0D5447C11AE0440F971CA9786269DC6E'::text)
  • Filter: ((nvl(t011.column27, 'N'::character varying))::text = 'N'::text)
  • Buffers: shared hit=861 read=3
31. 5.472 5.472 ↑ 1.0 1 288

Seq Scan on ebbase.t012 (cost=0.00..1.14 rows=1 width=69) (actual time=0.007..0.019 rows=1 loops=288)

  • Output: t012.column1, t012.column2, t012.column3, t012.column4, t012.column5, t012.column6, t012.column7, t012.column8, t012.column9, t012.column10, t012.column11, t012.column12, t012.column13, t012.column14, t012.column15, t012.column16, t012.column17, t012.column18, t012.column19, t012.column20, t012.column21, t012.column22, t012.column23, t012.column24, t012.column25, t012.column26, t012.column27, t012.column28, t012.column29, t012.column30
  • Filter: (('HK'::text = (t012.column3)::text) AND ((nvl(t012.column19, 'N'::character varying))::text = 'N'::text))
  • Rows Removed by Filter: 7
  • Buffers: shared hit=287 read=1
32. 9.216 9.216 ↓ 2.0 2 288

Index Scan using "pk_t013#column1" on ebbase.t013 (cost=0.27..3.50 rows=1 width=36) (actual time=0.023..0.032 rows=2 loops=288)

  • Output: t013.column1, t013.column2, t013.column3, t013.column4, t013.column5, t013.column6, t013.column7, t013.column8, t013.column9, t013.column10, t013.column11, t013.column12, t013.column13, t013.column14, t013.column15, t013.column16, t013.column17, t013.column18, t013.column19, t013.column20, t013.column21, t013.column22, t013.column23, t013.column24, t013.column25, t013.column26, t013.column27, t013.column28
  • Index Cond: ((t013.column1)::text = (t004.column16)::text)
  • Filter: ((nvl(t013.column16, 'N'::character varying))::text = 'N'::text)
  • Buffers: shared hit=1,149 read=3
33. 14.400 14.400 ↓ 3.0 3 576

Index Scan using "pk_t014#column1" on ebbase.t014 t014a (cost=0.27..0.30 rows=1 width=53) (actual time=0.016..0.025 rows=3 loops=576)

  • Output: t014a.column1, t014a.column2, t014a.column3, t014a.column4, t014a.column5, t014a.column6, t014a.column7, t014a.column8, t014a.column9, t014a.column10, t014a.column11, t014a.column12, t014a.column13, t014a.column14, t014a.column15, t014a.column16, t014a.column17, t014a.column18, t014a.column19, t014a.column20, t014a.column21, t014a.column22, t014a.column23, t014a.column24, t014a.column25, t014a.column26, t014a.column27, t014a.column28, t014a.column29, t014a.column30, t014a.column31, t014a.column32, t014a.column33
  • Index Cond: ((t014a.column1)::text = (t001.column7)::text)
  • Filter: ((nvl(t014a.column22, 'N'::character varying))::text = 'N'::text)
  • Buffers: shared hit=2,014 read=2
34. 4.860 4.860 ↓ 0.0 0 1,620

Index Scan using "pk_t015#column1" on ebbase.t015 (cost=0.14..1.31 rows=1 width=434) (actual time=0.003..0.003 rows=0 loops=1,620)

  • Output: t015.column1, t015.column2, t015.column3, t015.column4, t015.column5, t015.column6, t015.column7, t015.column8, t015.column9, t015.column10, t015.column11, t015.column12, t015.column13, t015.column14, t015.column15, t015.column16, t015.column17, t015.column18, t015.column19, t015.column20, t015.column21, t015.column22, t015.column23, t015.column24, t015.column25, t015.column26, t015.column27
  • Index Cond: ((t003.column35)::text = (t015.column1)::text)
  • Buffers: shared hit=1,620
35. 192.780 192.780 ↑ 1.0 234 1,620

Seq Scan on ebbase.t014 t014b (cost=0.00..7.34 rows=234 width=36) (actual time=0.009..0.119 rows=234 loops=1,620)

  • Output: t014b.column1, t014b.column2, t014b.column3, t014b.column4, t014b.column5, t014b.column6, t014b.column7, t014b.column8, t014b.column9, t014b.column10, t014b.column11, t014b.column12, t014b.column13, t014b.column14, t014b.column15, t014b.column16, t014b.column17, t014b.column18, t014b.column19, t014b.column20, t014b.column21, t014b.column22, t014b.column23, t014b.column24, t014b.column25, t014b.column26, t014b.column27, t014b.column28, t014b.column29, t014b.column30, t014b.column31, t014b.column32, t014b.column33
  • Buffers: shared hit=8,097 read=3
36.          

SubPlan (for Nested Loop)

37. 43.740 213.840 ↑ 1.0 1 4,860

Aggregate (cost=11.32..11.33 rows=1 width=32) (actual time=0.044..0.044 rows=1 loops=4,860)

  • Output: max((ta1.column10)::text)
  • Buffers: shared hit=14,577 read=3
38. 170.100 170.100 ↓ 2.0 4 4,860

Index Scan using "ix_t001#column9" on ebbase.t001 ta1 (cost=0.29..11.31 rows=2 width=8) (actual time=0.032..0.035 rows=4 loops=4,860)

  • Output: ta1.column1, ta1.column2, ta1.column3, ta1.column4, ta1.column5, ta1.column6, ta1.column7, ta1.column8, ta1.column9, ta1.column10, ta1.column11, ta1.column12, ta1.column13, ta1.column14, ta1.column15, ta1.column16, ta1.column17, ta1.column18, ta1.column19, ta1.column20, ta1.column21, ta1.column22, ta1.column23, ta1.column24, ta1.column25, ta1.column26, ta1.column27, ta1.column28, ta1.column29, ta1.column30, ta1.column31, ta1.column32, ta1.column33, ta1.column34, ta1.column35, ta1.column36, ta1.column37, ta1.column38, ta1.column39, ta1.column40, ta1.column41, ta1.column42, ta1.column43, ta1.column44, ta1.column45, ta1.column46, ta1.column47, ta1.column48, ta1.column49, ta1.column50
  • Index Cond: (((ta1.column9)::text = (t004.column6)::text) AND ((nvl(ta1.column12, 'N'::character varying))::text = 'N'::text))
  • Buffers: shared hit=14,577 read=3