Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [
- {
- "Plan": {
- "Node Type": "Append",
- "Parallel Aware": false,
- "Startup Cost": 0.00,
- "Total Cost": 12964.42,
- "Plan Rows": 5,
- "Plan Width": 1600,
- "Actual Startup Time": 0.121,
- "Actual Total Time": 138462.049,
- "Actual Rows": 238052,
- "Actual Loops": 1,
- "Shared Hit Blocks": 148931046,
- "Shared Read Blocks": 429374,
- "Shared Dirtied Blocks": 2963,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 36892,
- "Temp Written Blocks": 36896,
- "I/O Read Time": 22728.594,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Result",
- "Parent Relationship": "Member",
- "Parallel Aware": false,
- "Startup Cost": 0.00,
- "Total Cost": 0.01,
- "Plan Rows": 1,
- "Plan Width": 1600,
- "Actual Startup Time": 0.120,
- "Actual Total Time": 0.120,
- "Actual Rows": 1,
- "Actual Loops": 1,
- "Output": ["'Filtros:'::text", "''::text", "''::text", "''::text", "''::text", "''::text", "to_char(CURRENT_TIMESTAMP, 'dd/mm/yyyy hh24:mi:ss'::text)", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text"],
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Member",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1.74,
- "Total Cost": 25.21,
- "Plan Rows": 1,
- "Plan Width": 1600,
- "Actual Startup Time": 0.398,
- "Actual Total Time": 1.233,
- "Actual Rows": 2,
- "Actual Loops": 1,
- "Output": ["((sem_acentos(a.segfilnom))::text || ':'::text)", "CASE WHEN (a.segfilcod = 1) THEN (SubPlan 2) WHEN (a.segfilcod = 2) THEN (((c.segfili01)::text || ' a '::text) || (c.segfili02)::text) WHEN (a.segfilcod = 3) THEN ((('R$'::text || replace((c.segfilv01)::text, '.'::text, ','::text)) || ' a R$'::text) || replace((c.segfilv02)::text, '.'::text, ','::text)) WHEN (a.segfilcod = 4) THEN ((to_char(((c.segfildt01)::date)::timestamp with time zone, 'dd/mm/yyyy'::text) || ' a '::text) || to_char(((c.segfildt02)::date)::timestamp with time zone, 'dd/mm/yyyy'::text)) WHEN (a.segfilcod = 5) THEN ((SubPlan 3))::text WHEN (a.segfilcod = 7) THEN upper((c.segfilc01)::text) WHEN (a.segfilcod = 8) THEN upper((c.segfilc01)::text) WHEN (a.segfilcod = 9) THEN (((c.segfili01)::text || ' a '::text) || (c.segfili02)::text) WHEN (a.segfilcod = 10) THEN ((SubPlan 4))::text WHEN (a.segfilcod = 11) THEN ((SubPlan 5))::text WHEN (a.segfilcod = 12) THEN ((to_char((c.segfild01)::timestamp with time zone, 'dd/mm/yyyy'::text) || ' a '::text) || to_char((c.segfild02)::timestamp with time zone, 'dd/mm/yyyy'::text)) WHEN (a.segfilcod = 13) THEN ((to_char((c.segfild01)::timestamp with time zone, 'dd/mm/yyyy'::text) || ' a '::text) || to_char((c.segfild02)::timestamp with time zone, 'dd/mm/yyyy'::text)) WHEN (a.segfilcod = 14) THEN ((to_char((c.segfild01)::timestamp with time zone, 'dd/mm/yyyy'::text) || ' a '::text) || to_char((c.segfild02)::timestamp with time zone, 'dd/mm/yyyy'::text)) WHEN (a.segfilcod = 15) THEN ((to_char((c.segfild01)::timestamp with time zone, 'dd/mm/yyyy'::text) || ' a '::text) || to_char((c.segfild02)::timestamp with time zone, 'dd/mm/yyyy'::text)) WHEN (a.segfilcod = 16) THEN 'SIM'::text WHEN (a.segfilcod = 17) THEN 'SIM'::text WHEN (a.segfilcod = 18) THEN CASE WHEN ((c.segfilc01)::text = 'F'::text) THEN 'FISICA'::text WHEN ((c.segfilc01)::text = 'J'::text) THEN 'JURIDICA'::text ELSE 'NAO INFORMADA'::text END WHEN (a.segfilcod = 19) THEN 'SIM'::text WHEN (a.segfilcod = 21) THEN 'SIM'::text WHEN (a.segfilcod = 22) THEN (c.segfilc01)::text WHEN (a.segfilcod = 23) THEN CASE WHEN (upper((c.segfilc01)::text) <> ''::text) THEN upper((c.segfilc01)::text) WHEN (c.segfili01 <> 0) THEN (c.segfili01)::text WHEN (c.segfilv01 <> 0.00) THEN (c.segfilv01)::text WHEN (c.segfildt01 <> '0001-01-01 00:00:00'::timestamp without time zone) THEN to_char((c.segfild01)::timestamp with time zone, 'dd/mm/yyyy'::text) ELSE NULL::text END WHEN (a.segfilcod = 24) THEN CASE WHEN (upper((c.segfilc01)::text) <> ''::text) THEN upper((c.segfilc01)::text) WHEN (c.segfili01 <> 0) THEN (c.segfili01)::text WHEN (c.segfilv01 <> 0.00) THEN (c.segfilv01)::text WHEN (c.segfildt01 <> '0001-01-01 00:00:00'::timestamp without time zone) THEN to_char((c.segfild01)::timestamp with time zone, 'dd/mm/yyyy'::text) ELSE NULL::text END WHEN (a.segfilcod = 25) THEN CASE WHEN (upper((c.segfilc01)::text) <> ''::text) THEN upper((c.segfilc01)::text) WHEN (c.segfili01 <> 0) THEN (c.segfili01)::text WHEN (c.segfilv01 <> 0.00) THEN (c.segfilv01)::text WHEN (c.segfildt01 <> '0001-01-01 00:00:00'::timestamp without time zone) THEN to_char((c.segfild01)::timestamp with time zone, 'dd/mm/yyyy'::text) ELSE NULL::text END WHEN (a.segfilcod = 29) THEN ((to_char((c.segfild01)::timestamp with time zone, 'dd/mm/yyyy'::text) || ' a '::text) || to_char((c.segfild02)::timestamp with time zone, 'dd/mm/yyyy'::text)) WHEN (a.segfilcod = 32) THEN upper((c.segfilc01)::text) WHEN (a.segfilcod = 33) THEN ((to_char((c.segfild01)::timestamp with time zone, 'dd/mm/yyyy'::text) || ' a '::text) || to_char((c.segfild02)::timestamp with time zone, 'dd/mm/yyyy'::text)) WHEN (a.segfilcod = 34) THEN ((to_char((c.segfild01)::timestamp with time zone, 'dd/mm/yyyy HH24:MI:SS'::text) || ' a '::text) || to_char((c.segfild02)::timestamp with time zone, 'dd/mm/yyyy HH24:MI:SS'::text)) WHEN (a.segfilcod = 35) THEN ((to_char((c.segfild01)::timestamp with time zone, 'dd/mm/yyyy'::text) || ' a '::text) || to_char((c.segfild02)::timestamp with time zone, 'dd/mm/yyyy'::text)) WHEN (a.segfilcod = 37) THEN ((to_char((c.segfild01)::timestamp with time zone, 'dd/mm/yyyy'::text) || ' a '::text) || to_char((c.segfild02)::timestamp with time zone, 'dd/mm/yyyy'::text)) WHEN (a.segfilcod = 38) THEN (((c.segfili01)::text || ' a '::text) || (c.segfili02)::text) WHEN (a.segfilcod = 40) THEN 'SIM'::text WHEN (a.segfilcod = 41) THEN ((SubPlan 6))::text WHEN (a.segfilcod = 42) THEN ((SubPlan 7))::text WHEN (a.segfilcod = 43) THEN upper((c.segfili01)::text) WHEN (a.segfilcod = 45) THEN ((to_char(((c.segfildt01)::date)::timestamp with time zone, 'dd/mm/yyyy'::text) || ' a '::text) || to_char(((c.segfildt02)::date)::timestamp with time zone, 'dd/mm/yyyy'::text)) WHEN (a.segfilcod = 47) THEN 'SIM'::text WHEN (a.segfilcod = 48) THEN ((SubPlan 8))::text WHEN (a.segfilcod = 307) THEN (((((c.segfilc01)::text || '/'::text) || (c.segfilc02)::text) || '/'::text) || (c.segfilc03)::text) ELSE NULL::text END", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text"],
- "Inner Unique": false,
- "Shared Hit Blocks": 33,
- "Shared Read Blocks": 4,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.300,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Hash Join",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1.47,
- "Total Cost": 4.66,
- "Plan Rows": 3,
- "Plan Width": 45,
- "Actual Startup Time": 0.077,
- "Actual Total Time": 0.093,
- "Actual Rows": 2,
- "Actual Loops": 1,
- "Output": ["a.segfilnom", "a.segfilcod", "b.segfilcod", "b.segcod"],
- "Inner Unique": true,
- "Hash Cond": "(a.segfilcod = b.segfilcod)",
- "Shared Hit Blocks": 5,
- "Shared Read Blocks": 1,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.009,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Seq Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Relation Name": "segmentacao_filtro",
- "Schema": "public",
- "Alias": "a",
- "Startup Cost": 0.00,
- "Total Cost": 2.94,
- "Plan Rows": 94,
- "Plan Width": 29,
- "Actual Startup Time": 0.006,
- "Actual Total Time": 0.013,
- "Actual Rows": 94,
- "Actual Loops": 1,
- "Output": ["a.segfilcod", "a.segfilnom", "a.segcaption01", "a.segcapvisible01", "a.segcapsize01", "a.segcaption02", "a.segcapvisible02", "a.segcapsize02", "a.segcaption03", "a.segcapvisible03", "a.segcapsize03", "a.segcaption04", "a.segcapvisible04", "a.segcapsize04", "a.segfiladdfil"],
- "Shared Hit Blocks": 2,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Hash",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Startup Cost": 1.43,
- "Total Cost": 1.43,
- "Plan Rows": 3,
- "Plan Width": 16,
- "Actual Startup Time": 0.045,
- "Actual Total Time": 0.046,
- "Actual Rows": 2,
- "Actual Loops": 1,
- "Output": ["b.segfilcod", "b.segcod"],
- "Hash Buckets": 1024,
- "Original Hash Buckets": 1024,
- "Hash Batches": 1,
- "Original Hash Batches": 1,
- "Peak Memory Usage": 9,
- "Shared Hit Blocks": 3,
- "Shared Read Blocks": 1,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.009,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "isegmentacaolevel11_0002",
- "Relation Name": "segmentacaolevel1",
- "Schema": "public",
- "Alias": "b",
- "Startup Cost": 0.28,
- "Total Cost": 1.43,
- "Plan Rows": 3,
- "Plan Width": 16,
- "Actual Startup Time": 0.038,
- "Actual Total Time": 0.040,
- "Actual Rows": 2,
- "Actual Loops": 1,
- "Output": ["b.segfilcod", "b.segcod"],
- "Index Cond": "(b.segcod = 520)",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 2,
- "Shared Hit Blocks": 3,
- "Shared Read Blocks": 1,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.009,
- "I/O Write Time": 0.000
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "isegmentacaolevel1level2_0002",
- "Relation Name": "segmentacaolevel1level2",
- "Schema": "public",
- "Alias": "c",
- "Startup Cost": 0.28,
- "Total Cost": 0.94,
- "Plan Rows": 1,
- "Plan Width": 65,
- "Actual Startup Time": 0.157,
- "Actual Total Time": 0.157,
- "Actual Rows": 1,
- "Actual Loops": 2,
- "Output": ["c.segcod", "c.segfilcod", "c.segfilcoditem", "c.segfilc01", "c.segfilc02", "c.segfilc03", "c.segfilc04", "c.segfilc05", "c.segfilv01", "c.segfilv02", "c.segfilv03", "c.segfilv04", "c.segfili01", "c.segfili02", "c.segfili03", "c.segfili04", "c.segfild01", "c.segfild02", "c.segfild03", "c.segfild04", "c.segfildt01", "c.segfildt02", "c.segfildt03", "c.segfildt04", "c.segfillegcod", "c.segfilobs"],
- "Index Cond": "((c.segcod = 520) AND (c.segfilcod = a.segfilcod))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 4,
- "Shared Read Blocks": 3,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.292,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 2",
- "Parallel Aware": false,
- "Startup Cost": 5.00,
- "Total Cost": 5.01,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.000,
- "Actual Total Time": 0.000,
- "Actual Rows": 0,
- "Actual Loops": 0,
- "Output": ["min((x.sitnom)::text)"],
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "InitPlan",
- "Subplan Name": "InitPlan 1 (returns $1)",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "isegmentacaolevel1level2_0002",
- "Relation Name": "segmentacaolevel1level2",
- "Schema": "public",
- "Alias": "sl",
- "Startup Cost": 0.28,
- "Total Cost": 2.50,
- "Plan Rows": 1,
- "Plan Width": 8,
- "Actual Startup Time": 0.000,
- "Actual Total Time": 0.000,
- "Actual Rows": 0,
- "Actual Loops": 0,
- "Output": ["sl.segfili01"],
- "Index Cond": "((sl.segcod = c.segcod) AND (sl.segfilcod = 48))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "carteira_situacao_iu0003",
- "Relation Name": "carteira_situacao",
- "Schema": "public",
- "Alias": "x",
- "Startup Cost": 0.28,
- "Total Cost": 2.50,
- "Plan Rows": 1,
- "Plan Width": 17,
- "Actual Startup Time": 0.000,
- "Actual Total Time": 0.000,
- "Actual Rows": 0,
- "Actual Loops": 0,
- "Output": ["x.carcod", "x.sitcod", "x.sitnom", "x.sitpridep", "x.sitsaiaut", "x.sitperage", "x.sitdiaage", "x.sitpricod", "x.sitagepubusu", "x.sittipimp", "x.sittipred", "x.sitati", "x.sitdatinc", "x.situsuinc", "x.sitdatatu", "x.situsuatu", "x.sittippermod", "x.sitpermoddia", "x.sitpermodopeagenaoven", "x.sitdepara", "x.sitdiaagemin", "x.sitdiasugestao", "x.sitperagehor", "x.situsupermanencia", "x.tipconcod", "x.sitocuage", "x.sitexigecomplemento", "x.sitbi", "x.sitnomcomplemento", "x.sitqtdeacao", "x.sitimpcal", "x.sitigntro", "x.sitsittro", "x.sitqtdtenttro", "x.sitpeso", "x.sitprom", "x.sitreizersit", "x.sitreizerdia", "x.sitreizer", "x.sithorpad", "x.sitreizercob", "x.sitstacod", "x.sittroenvsms", "x.sitdiaagedep", "x.sitcoddep", "x.sitdesaltoco", "x.sitdessitacifil", "x.sitocuacificcli", "x.carsitblopor", "x.carstacod", "x.carsitremmai"],
- "Index Cond": "((x.sitcod = c.segfili01) AND (x.carcod = $1))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 3",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "produto_pkey",
- "Relation Name": "produto",
- "Schema": "public",
- "Alias": "x_1",
- "Startup Cost": 0.28,
- "Total Cost": 2.49,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.000,
- "Actual Total Time": 0.000,
- "Actual Rows": 0,
- "Actual Loops": 0,
- "Output": ["sem_acentos(x_1.pronom)"],
- "Index Cond": "(x_1.procod = c.segfili01)",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 4",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "usuario_pkey",
- "Relation Name": "usuario",
- "Schema": "public",
- "Alias": "u",
- "Startup Cost": 0.28,
- "Total Cost": 2.50,
- "Plan Rows": 1,
- "Plan Width": 23,
- "Actual Startup Time": 0.000,
- "Actual Total Time": 0.000,
- "Actual Rows": 0,
- "Actual Loops": 0,
- "Output": ["u.usunom"],
- "Index Cond": "(u.usucod = c.segfili01)",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 5",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "usuario_pkey",
- "Relation Name": "usuario",
- "Schema": "public",
- "Alias": "u_1",
- "Startup Cost": 0.28,
- "Total Cost": 2.50,
- "Plan Rows": 1,
- "Plan Width": 23,
- "Actual Startup Time": 0.000,
- "Actual Total Time": 0.000,
- "Actual Rows": 0,
- "Actual Loops": 0,
- "Output": ["u_1.usunom"],
- "Index Cond": "(u_1.usucod = c.segfili01)",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Seq Scan",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 6",
- "Parallel Aware": false,
- "Relation Name": "endereco_tipo",
- "Schema": "public",
- "Alias": "x_2",
- "Startup Cost": 0.00,
- "Total Cost": 1.13,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.000,
- "Actual Total Time": 0.000,
- "Actual Rows": 0,
- "Actual Loops": 0,
- "Output": ["sem_acentos(x_2.tipendnom)"],
- "Filter": "(x_2.tipendcod = c.segfili01)",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Seq Scan",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 7",
- "Parallel Aware": false,
- "Relation Name": "pessoa_tipo",
- "Schema": "public",
- "Alias": "x_3",
- "Startup Cost": 0.00,
- "Total Cost": 1.24,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.000,
- "Actual Total Time": 0.000,
- "Actual Rows": 0,
- "Actual Loops": 0,
- "Output": ["sem_acentos(x_3.tippesnom)"],
- "Filter": "(x_3.tippescod = c.segfili01)",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 8",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "carteira_pkey",
- "Relation Name": "carteira",
- "Schema": "public",
- "Alias": "x_4",
- "Startup Cost": 0.14,
- "Total Cost": 2.37,
- "Plan Rows": 1,
- "Plan Width": 19,
- "Actual Startup Time": 0.023,
- "Actual Total Time": 0.795,
- "Actual Rows": 1,
- "Actual Loops": 1,
- "Output": ["x_4.carnom"],
- "Index Cond": "(x_4.carcod = c.segfili01)",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 24,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Result",
- "Parent Relationship": "Member",
- "Parallel Aware": false,
- "Startup Cost": 0.00,
- "Total Cost": 0.01,
- "Plan Rows": 1,
- "Plan Width": 1600,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 1,
- "Output": ["''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text"],
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Result",
- "Parent Relationship": "Member",
- "Parallel Aware": false,
- "Startup Cost": 0.00,
- "Total Cost": 0.01,
- "Plan Rows": 1,
- "Plan Width": 1600,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 1,
- "Output": ["'Cpf'::text", "'Nome Do Devedor'::text", "'Numero Contrato'::text", "'Produto'::text", "'Saldo Contrato'::text", "'E-Mail'::text", "'Contrato - Descrição situação'::text", "'Código do Pedido'::text", "'Endereco - UF'::text", "'Codigo Do Devedor'::text", "'Data Vencimento'::text", "'Endereço - Cidade'::text", "'Telefone Celular HENRIQUECIDO'::text", "'Codigo Da Pessoa'::text", "'Telefone - Residencial'::text", "'Telefone - Comercial'::text", "'Telefone - Celular'::text", "'Telefone Classificacao: *'::text", "'Telefone Classificacao: **'::text", "'Telefone Classificacao: ***'::text", "'Telefone Classificacao: ****'::text", "'Telefone Classificacao: *****'::text", "'Telefone Classificacao: Excluir'::text", "'Telefone Classificacao: Preferencial'::text", "'Filial'::text", "'Telefone Classificacao: *'::text", "'Telefone Classificacao: **'::text", "'Telefone Classificacao: ***'::text", "'Telefone Classificacao: ****'::text", "'Telefone Classificacao: *****'::text", "'Telefone Classificacao: Excluir'::text", "'Telefone Classificacao: Preferencial'::text", "'Telefone Celular HENRIQUECIDO'::text", "'Tipo De Pessoa'::text", "'Telefone Classificacao: *'::text", "'Telefone Classificacao: **'::text", "'Telefone Classificacao: ***'::text", "'Telefone Classificacao: ****'::text", "'Telefone Classificacao: *****'::text", "'Telefone Classificacao: Excluir'::text", "'Telefone Classificacao: Preferencial'::text", "'Telefone Celular HENRIQUECIDO'::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text", "''::text"],
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Subquery Scan",
- "Parent Relationship": "Member",
- "Parallel Aware": false,
- "Alias": "*SELECT* 5",
- "Startup Cost": 12552.95,
- "Total Cost": 12939.11,
- "Plan Rows": 1,
- "Plan Width": 1600,
- "Actual Startup Time": 93160.363,
- "Actual Total Time": 138433.582,
- "Actual Rows": 238047,
- "Actual Loops": 1,
- "Output": ["\"*SELECT* 5\".ponto_por_virgula", "\"*SELECT* 5\".ponto_por_virgula_1", "\"*SELECT* 5\".ponto_por_virgula_2", "\"*SELECT* 5\".ponto_por_virgula_3", "\"*SELECT* 5\".ponto_por_virgula_4", "\"*SELECT* 5\".ponto_por_virgula_5", "\"*SELECT* 5\".ponto_por_virgula_6", "\"*SELECT* 5\".ponto_por_virgula_7", "\"*SELECT* 5\".ponto_por_virgula_8", "\"*SELECT* 5\".ponto_por_virgula_9", "\"*SELECT* 5\".ponto_por_virgula_10", "\"*SELECT* 5\".ponto_por_virgula_11", "\"*SELECT* 5\".ponto_por_virgula_12", "\"*SELECT* 5\".ponto_por_virgula_13", "\"*SELECT* 5\".ponto_por_virgula_14", "\"*SELECT* 5\".ponto_por_virgula_15", "\"*SELECT* 5\".ponto_por_virgula_16", "\"*SELECT* 5\".ponto_por_virgula_17", "\"*SELECT* 5\".ponto_por_virgula_18", "\"*SELECT* 5\".ponto_por_virgula_19", "\"*SELECT* 5\".ponto_por_virgula_20", "\"*SELECT* 5\".ponto_por_virgula_21", "\"*SELECT* 5\".ponto_por_virgula_22", "\"*SELECT* 5\".ponto_por_virgula_23", "\"*SELECT* 5\".ponto_por_virgula_24", "\"*SELECT* 5\".ponto_por_virgula_25", "\"*SELECT* 5\".ponto_por_virgula_26", "\"*SELECT* 5\".ponto_por_virgula_27", "\"*SELECT* 5\".ponto_por_virgula_28", "\"*SELECT* 5\".ponto_por_virgula_29", "\"*SELECT* 5\".ponto_por_virgula_30", "\"*SELECT* 5\".ponto_por_virgula_31", "\"*SELECT* 5\".ponto_por_virgula_32", "\"*SELECT* 5\".ponto_por_virgula_33", "\"*SELECT* 5\".ponto_por_virgula_34", "\"*SELECT* 5\".ponto_por_virgula_35", "\"*SELECT* 5\".ponto_por_virgula_36", "\"*SELECT* 5\".ponto_por_virgula_37", "\"*SELECT* 5\".ponto_por_virgula_38", "\"*SELECT* 5\".ponto_por_virgula_39", "\"*SELECT* 5\".ponto_por_virgula_40", "\"*SELECT* 5\".ponto_por_virgula_41", "\"*SELECT* 5\".ponto_por_virgula_42", "\"*SELECT* 5\".ponto_por_virgula_43", "\"*SELECT* 5\".ponto_por_virgula_44", "\"*SELECT* 5\".ponto_por_virgula_45", "\"*SELECT* 5\".ponto_por_virgula_46", "\"*SELECT* 5\".ponto_por_virgula_47", "\"*SELECT* 5\".ponto_por_virgula_48", "\"*SELECT* 5\".ponto_por_virgula_49"],
- "Shared Hit Blocks": 148931013,
- "Shared Read Blocks": 429370,
- "Shared Dirtied Blocks": 2963,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 36892,
- "Temp Written Blocks": 36896,
- "I/O Read Time": 22728.294,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Subquery Scan",
- "Parent Relationship": "Subquery",
- "Parallel Aware": false,
- "Alias": "x1",
- "Startup Cost": 12552.95,
- "Total Cost": 12939.10,
- "Plan Rows": 1,
- "Plan Width": 1600,
- "Actual Startup Time": 93160.353,
- "Actual Total Time": 138324.358,
- "Actual Rows": 238047,
- "Actual Loops": 1,
- "Output": ["x1.ponto_por_virgula", "x1.ponto_por_virgula_1", "x1.ponto_por_virgula_2", "x1.ponto_por_virgula_3", "x1.ponto_por_virgula_4", "x1.ponto_por_virgula_5", "x1.ponto_por_virgula_6", "x1.ponto_por_virgula_7", "x1.ponto_por_virgula_8", "x1.ponto_por_virgula_9", "x1.ponto_por_virgula_10", "x1.ponto_por_virgula_11", "x1.ponto_por_virgula_12", "x1.ponto_por_virgula_13", "x1.ponto_por_virgula_14", "x1.ponto_por_virgula_15", "x1.ponto_por_virgula_16", "x1.ponto_por_virgula_17", "x1.ponto_por_virgula_18", "x1.ponto_por_virgula_19", "x1.ponto_por_virgula_20", "x1.ponto_por_virgula_21", "x1.ponto_por_virgula_22", "x1.ponto_por_virgula_23", "x1.ponto_por_virgula_24", "x1.ponto_por_virgula_25", "x1.ponto_por_virgula_26", "x1.ponto_por_virgula_27", "x1.ponto_por_virgula_28", "x1.ponto_por_virgula_29", "x1.ponto_por_virgula_30", "x1.ponto_por_virgula_31", "x1.ponto_por_virgula_32", "x1.ponto_por_virgula_33", "x1.ponto_por_virgula_34", "x1.ponto_por_virgula_35", "x1.ponto_por_virgula_36", "x1.ponto_por_virgula_37", "x1.ponto_por_virgula_38", "x1.ponto_por_virgula_39", "x1.ponto_por_virgula_40", "x1.ponto_por_virgula_41", "x1.ponto_por_virgula_42", "x1.ponto_por_virgula_43", "x1.ponto_por_virgula_44", "x1.ponto_por_virgula_45", "x1.ponto_por_virgula_46", "x1.ponto_por_virgula_47", "x1.ponto_por_virgula_48", "x1.ponto_por_virgula_49"],
- "Shared Hit Blocks": 148931013,
- "Shared Read Blocks": 429370,
- "Shared Dirtied Blocks": 2963,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 36892,
- "Temp Written Blocks": 36896,
- "I/O Read Time": 22728.294,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Result",
- "Parent Relationship": "Subquery",
- "Parallel Aware": false,
- "Startup Cost": 12552.95,
- "Total Cost": 12939.09,
- "Plan Rows": 1,
- "Plan Width": 2464,
- "Actual Startup Time": 93160.348,
- "Actual Total Time": 138255.654,
- "Actual Rows": 238047,
- "Actual Loops": 1,
- "Output": ["(ponto_por_virgula(sem_acentos((COALESCE(((a_1.devcpf)::text), ''::text))::character varying)))", "(ponto_por_virgula(sem_acentos((COALESCE(((a_1.devnom)::text), ''::text))::character varying)))", "ponto_por_virgula(sem_acentos((COALESCE(((b_1.connumcon)::text), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE(((b_1.procod)::text), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE(((b_1.convalsal)::text), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE(((p.pesema)::text), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE(((SubPlan 9))::text, ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE(((SubPlan 10))::text, ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE(((SubPlan 11))::text, ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE(((a_1.devcod)::text), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE(((c_1.conpardatven)::text), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE(((SubPlan 12))::text, ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 13), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE(((p.pescod)::text), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 14), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 15), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 16), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 17), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 18), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 19), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 20), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 21), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 22), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 23), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE(((b_1.filcod)::text), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 24), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 25), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 26), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 27), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 28), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 29), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 30), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 31), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE(((p.tippescod)::text), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 32), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 33), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 34), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 35), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 36), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 37), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 38), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE((SubPlan 39), ''::text))::character varying))", "ponto_por_virgula(sem_acentos(''::character varying))", "ponto_por_virgula(sem_acentos(''::character varying))", "ponto_por_virgula(sem_acentos(''::character varying))", "ponto_por_virgula(sem_acentos(''::character varying))", "ponto_por_virgula(sem_acentos(''::character varying))", "ponto_por_virgula(sem_acentos(''::character varying))", "ponto_por_virgula(sem_acentos(''::character varying))", "ponto_por_virgula(sem_acentos(''::character varying))", "((a_1.devcpf)::text)", "((a_1.devnom)::text)", "((b_1.connumcon)::text)", "((b_1.procod)::text)", "((b_1.convalsal)::text)", "((p.pesema)::text)", "(((SubPlan 40))::text)", "(((SubPlan 41))::text)", "(((SubPlan 42))::text)", "((a_1.devcod)::text)", "((c_1.conpardatven)::text)", "(((SubPlan 43))::text)", "((SubPlan 44))", "((p.pescod)::text)", "((SubPlan 45))", "((SubPlan 46))", "((SubPlan 47))", "((SubPlan 48))", "((SubPlan 49))", "((SubPlan 50))", "((SubPlan 51))", "((SubPlan 52))", "((SubPlan 53))", "((SubPlan 54))", "((b_1.filcod)::text)", "((p.tippescod)::text)", "(''::text)"],
- "Shared Hit Blocks": 148931013,
- "Shared Read Blocks": 429370,
- "Shared Dirtied Blocks": 2963,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 36892,
- "Temp Written Blocks": 36896,
- "I/O Read Time": 22728.294,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "InitPlan",
- "Subplan Name": "InitPlan 57 (returns $81)",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "isegmentacaolevel1level2_0002",
- "Relation Name": "segmentacaolevel1level2",
- "Schema": "public",
- "Alias": "c_2",
- "Startup Cost": 0.28,
- "Total Cost": 2.50,
- "Plan Rows": 1,
- "Plan Width": 8,
- "Actual Startup Time": 0.014,
- "Actual Total Time": 0.015,
- "Actual Rows": 1,
- "Actual Loops": 1,
- "Output": ["c_2.segfili01"],
- "Index Cond": "((c_2.segcod = 520) AND (c_2.segfilcod = 48))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 4,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Sort",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Startup Cost": 12550.45,
- "Total Cost": 12550.45,
- "Plan Rows": 1,
- "Plan Width": 990,
- "Actual Startup Time": 93159.263,
- "Actual Total Time": 93305.910,
- "Actual Rows": 238047,
- "Actual Loops": 1,
- "Output": ["(ponto_por_virgula(sem_acentos((COALESCE(((a_1.devcpf)::text), ''::text))::character varying)))", "(ponto_por_virgula(sem_acentos((COALESCE(((a_1.devnom)::text), ''::text))::character varying)))", "((a_1.devcpf)::text)", "((a_1.devnom)::text)", "((b_1.connumcon)::text)", "((b_1.procod)::text)", "((b_1.convalsal)::text)", "((p.pesema)::text)", "(((SubPlan 40))::text)", "(((SubPlan 41))::text)", "(((SubPlan 42))::text)", "((a_1.devcod)::text)", "((c_1.conpardatven)::text)", "(((SubPlan 43))::text)", "((SubPlan 44))", "((p.pescod)::text)", "((SubPlan 45))", "((SubPlan 46))", "((SubPlan 47))", "((SubPlan 48))", "((SubPlan 49))", "((SubPlan 50))", "((SubPlan 51))", "((SubPlan 52))", "((SubPlan 53))", "((SubPlan 54))", "((b_1.filcod)::text)", "((p.tippescod)::text)", "''::text", "b_1.connumcon", "b_1.procod", "b_1.convalsal", "p.pesema", "a_1.carcod", "r.sitcod", "b_1.concod", "p.pescod", "a_1.devcod", "c_1.conpardatven", "b_1.filcod", "p.tippescod"],
- "Sort Key": ["(ponto_por_virgula(sem_acentos((COALESCE(((a_1.devcpf)::text), ''::text))::character varying)))", "(ponto_por_virgula(sem_acentos((COALESCE(((a_1.devnom)::text), ''::text))::character varying)))"],
- "Sort Method": "external merge",
- "Sort Space Used": 77744,
- "Sort Space Type": "Disk",
- "Shared Hit Blocks": 96532486,
- "Shared Read Blocks": 426211,
- "Shared Dirtied Blocks": 2963,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 36892,
- "Temp Written Blocks": 36896,
- "I/O Read Time": 22701.984,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Group",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Startup Cost": 12436.32,
- "Total Cost": 12550.44,
- "Plan Rows": 1,
- "Plan Width": 990,
- "Actual Startup Time": 91135.274,
- "Actual Total Time": 92734.445,
- "Actual Rows": 238047,
- "Actual Loops": 1,
- "Output": ["ponto_por_virgula(sem_acentos((COALESCE(((a_1.devcpf)::text), ''::text))::character varying))", "ponto_por_virgula(sem_acentos((COALESCE(((a_1.devnom)::text), ''::text))::character varying))", "((a_1.devcpf)::text)", "((a_1.devnom)::text)", "((b_1.connumcon)::text)", "((b_1.procod)::text)", "((b_1.convalsal)::text)", "((p.pesema)::text)", "(((SubPlan 40))::text)", "(((SubPlan 41))::text)", "(((SubPlan 42))::text)", "((a_1.devcod)::text)", "((c_1.conpardatven)::text)", "(((SubPlan 43))::text)", "((SubPlan 44))", "((p.pescod)::text)", "((SubPlan 45))", "((SubPlan 46))", "((SubPlan 47))", "((SubPlan 48))", "((SubPlan 49))", "((SubPlan 50))", "((SubPlan 51))", "((SubPlan 52))", "((SubPlan 53))", "((SubPlan 54))", "((b_1.filcod)::text)", "((p.tippescod)::text)", "(''::text)", "b_1.connumcon", "b_1.procod", "b_1.convalsal", "p.pesema", "a_1.carcod", "r.sitcod", "b_1.concod", "p.pescod", "a_1.devcod", "c_1.conpardatven", "b_1.filcod", "p.tippescod"],
- "Group Key": ["((a_1.devcpf)::text)", "((a_1.devnom)::text)", "((b_1.connumcon)::text)", "((b_1.procod)::text)", "((b_1.convalsal)::text)", "((p.pesema)::text)", "(((SubPlan 40))::text)", "(((SubPlan 41))::text)", "(((SubPlan 42))::text)", "((a_1.devcod)::text)", "((c_1.conpardatven)::text)", "(((SubPlan 43))::text)", "((SubPlan 44))", "((p.pescod)::text)", "((SubPlan 45))", "((SubPlan 46))", "((SubPlan 47))", "((SubPlan 48))", "((SubPlan 49))", "((SubPlan 50))", "((SubPlan 51))", "((SubPlan 52))", "((SubPlan 53))", "((SubPlan 54))", "((b_1.filcod)::text)", "((p.tippescod)::text)", "''::text"],
- "Shared Hit Blocks": 96532486,
- "Shared Read Blocks": 426211,
- "Shared Dirtied Blocks": 2963,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 27174,
- "Temp Written Blocks": 27177,
- "I/O Read Time": 22701.984,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Sort",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Startup Cost": 12436.32,
- "Total Cost": 12436.33,
- "Plan Rows": 1,
- "Plan Width": 959,
- "Actual Startup Time": 91134.982,
- "Actual Total Time": 91606.761,
- "Actual Rows": 653139,
- "Actual Loops": 1,
- "Output": ["((a_1.devcpf)::text)", "((a_1.devnom)::text)", "((b_1.connumcon)::text)", "((b_1.procod)::text)", "((b_1.convalsal)::text)", "((p.pesema)::text)", "(((SubPlan 40))::text)", "(((SubPlan 41))::text)", "(((SubPlan 42))::text)", "((a_1.devcod)::text)", "((c_1.conpardatven)::text)", "(((SubPlan 43))::text)", "((SubPlan 44))", "((p.pescod)::text)", "((SubPlan 45))", "((SubPlan 46))", "((SubPlan 47))", "((SubPlan 48))", "((SubPlan 49))", "((SubPlan 50))", "((SubPlan 51))", "((SubPlan 52))", "((SubPlan 53))", "((SubPlan 54))", "((b_1.filcod)::text)", "((p.tippescod)::text)", "''::text", "a_1.devcpf", "a_1.devnom", "b_1.connumcon", "b_1.procod", "b_1.convalsal", "p.pesema", "a_1.carcod", "r.sitcod", "b_1.concod", "p.pescod", "a_1.devcod", "c_1.conpardatven", "b_1.filcod", "p.tippescod"],
- "Sort Key": ["((a_1.devcpf)::text)", "((a_1.devnom)::text)", "((b_1.connumcon)::text)", "((b_1.procod)::text)", "((b_1.convalsal)::text)", "((p.pesema)::text)", "(((SubPlan 40))::text)", "(((SubPlan 41))::text)", "(((SubPlan 42))::text)", "((a_1.devcod)::text)", "((c_1.conpardatven)::text)", "(((SubPlan 43))::text)", "((SubPlan 44))", "((p.pescod)::text)", "((SubPlan 45))", "((SubPlan 46))", "((SubPlan 47))", "((SubPlan 48))", "((SubPlan 49))", "((SubPlan 50))", "((SubPlan 51))", "((SubPlan 52))", "((SubPlan 53))", "((SubPlan 54))", "((b_1.filcod)::text)", "((p.tippescod)::text)"],
- "Sort Method": "external merge",
- "Sort Space Used": 217392,
- "Sort Space Type": "Disk",
- "Shared Hit Blocks": 96532486,
- "Shared Read Blocks": 426211,
- "Shared Dirtied Blocks": 2963,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 27174,
- "Temp Written Blocks": 27177,
- "I/O Read Time": 22701.984,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1004.62,
- "Total Cost": 12436.31,
- "Plan Rows": 1,
- "Plan Width": 959,
- "Actual Startup Time": 2.763,
- "Actual Total Time": 86834.426,
- "Actual Rows": 653139,
- "Actual Loops": 1,
- "Output": ["(a_1.devcpf)::text", "(a_1.devnom)::text", "(b_1.connumcon)::text", "(b_1.procod)::text", "(b_1.convalsal)::text", "(p.pesema)::text", "((SubPlan 40))::text", "((SubPlan 41))::text", "((SubPlan 42))::text", "(a_1.devcod)::text", "(c_1.conpardatven)::text", "((SubPlan 43))::text", "(SubPlan 44)", "(p.pescod)::text", "(SubPlan 45)", "(SubPlan 46)", "(SubPlan 47)", "(SubPlan 48)", "(SubPlan 49)", "(SubPlan 50)", "(SubPlan 51)", "(SubPlan 52)", "(SubPlan 53)", "(SubPlan 54)", "(b_1.filcod)::text", "(p.tippescod)::text", "''::text", "a_1.devcpf", "a_1.devnom", "b_1.connumcon", "b_1.procod", "b_1.convalsal", "p.pesema", "a_1.carcod", "r.sitcod", "b_1.concod", "p.pescod", "a_1.devcod", "c_1.conpardatven", "b_1.filcod", "p.tippescod"],
- "Inner Unique": true,
- "Shared Hit Blocks": 96532486,
- "Shared Read Blocks": 426211,
- "Shared Dirtied Blocks": 2963,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 22701.984,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1004.34,
- "Total Cost": 12321.88,
- "Plan Rows": 1,
- "Plan Width": 95,
- "Actual Startup Time": 1.854,
- "Actual Total Time": 32906.025,
- "Actual Rows": 653139,
- "Actual Loops": 1,
- "Output": ["a_1.devcpf", "a_1.devnom", "a_1.carcod", "a_1.devcod", "r.sitcod", "b_1.connumcon", "b_1.procod", "b_1.convalsal", "b_1.concod", "b_1.filcod", "c_1.conpardatven", "p.pesema", "p.pescod", "p.tippescod"],
- "Inner Unique": false,
- "Shared Hit Blocks": 21953867,
- "Shared Read Blocks": 248667,
- "Shared Dirtied Blocks": 2909,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 11099.812,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Left",
- "Startup Cost": 1004.20,
- "Total Cost": 12320.61,
- "Plan Rows": 1,
- "Plan Width": 95,
- "Actual Startup Time": 1.833,
- "Actual Total Time": 16490.755,
- "Actual Rows": 653139,
- "Actual Loops": 1,
- "Output": ["a_1.devcpf", "a_1.devnom", "a_1.carcod", "a_1.devcod", "r.sitcod", "b_1.connumcon", "b_1.procod", "b_1.convalsal", "b_1.concod", "b_1.filcod", "c_1.conpardatven", "p.pesema", "p.pescod", "p.tippescod"],
- "Inner Unique": false,
- "Shared Hit Blocks": 6012926,
- "Shared Read Blocks": 248667,
- "Shared Dirtied Blocks": 2909,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 11099.812,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Left",
- "Startup Cost": 1003.76,
- "Total Cost": 12318.78,
- "Plan Rows": 1,
- "Plan Width": 103,
- "Actual Startup Time": 1.820,
- "Actual Total Time": 15096.198,
- "Actual Rows": 305201,
- "Actual Loops": 1,
- "Output": ["a_1.devcpf", "a_1.devnom", "a_1.carcod", "a_1.devcod", "r.sitcod", "b_1.connumcon", "b_1.procod", "b_1.convalsal", "b_1.concod", "b_1.filcod", "c_1.conpardatven", "c_1.conparseq", "p.pesema", "p.pescod", "p.tippescod"],
- "Inner Unique": false,
- "Shared Hit Blocks": 5068544,
- "Shared Read Blocks": 242635,
- "Shared Dirtied Blocks": 2909,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 10777.641,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1003.20,
- "Total Cost": 12317.10,
- "Plan Rows": 1,
- "Plan Width": 103,
- "Actual Startup Time": 1.803,
- "Actual Total Time": 13524.985,
- "Actual Rows": 241658,
- "Actual Loops": 1,
- "Output": ["a_1.devcpf", "a_1.devnom", "a_1.carcod", "a_1.devcod", "r.sitcod", "b_1.connumcon", "b_1.procod", "b_1.convalsal", "b_1.concod", "b_1.filcod", "c_1.conpardatven", "c_1.conparseq", "p.pesema", "p.pescod", "p.tippescod"],
- "Inner Unique": false,
- "Shared Hit Blocks": 4027163,
- "Shared Read Blocks": 238340,
- "Shared Dirtied Blocks": 2909,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 10286.017,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1002.76,
- "Total Cost": 12296.27,
- "Plan Rows": 1,
- "Plan Width": 91,
- "Actual Startup Time": 1.480,
- "Actual Total Time": 8620.062,
- "Actual Rows": 237842,
- "Actual Loops": 1,
- "Output": ["a_1.devcpf", "a_1.devnom", "a_1.carcod", "a_1.devcod", "r.sitcod", "b_1.connumcon", "b_1.procod", "b_1.convalsal", "b_1.concod", "b_1.filcod", "p.pesema", "p.pescod", "p.tippescod"],
- "Inner Unique": true,
- "Shared Hit Blocks": 3156681,
- "Shared Read Blocks": 152381,
- "Shared Dirtied Blocks": 2909,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 6718.812,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Gather",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Startup Cost": 1001.42,
- "Total Cost": 12292.70,
- "Plan Rows": 1,
- "Plan Width": 105,
- "Actual Startup Time": 1.386,
- "Actual Total Time": 82.203,
- "Actual Rows": 237842,
- "Actual Loops": 1,
- "Output": ["a_1.devcpf", "a_1.devnom", "a_1.carcod", "a_1.devcod", "b_1.connumcon", "b_1.procod", "b_1.convalsal", "b_1.concod", "b_1.filcod", "b_1.devcod", "p.pesema", "p.pescod", "p.tippescod", "p.devcod"],
- "Workers Planned": 1,
- "Params Evaluated": ["$81"],
- "Workers Launched": 1,
- "Single Copy": false,
- "Shared Hit Blocks": 959170,
- "Shared Read Blocks": 40923,
- "Shared Dirtied Blocks": 1895,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 1207.346,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1.42,
- "Total Cost": 11292.60,
- "Plan Rows": 1,
- "Plan Width": 105,
- "Actual Startup Time": 0.264,
- "Actual Total Time": 1597.915,
- "Actual Rows": 118921,
- "Actual Loops": 2,
- "Output": ["a_1.devcpf", "a_1.devnom", "a_1.carcod", "a_1.devcod", "b_1.connumcon", "b_1.procod", "b_1.convalsal", "b_1.concod", "b_1.filcod", "b_1.devcod", "p.pesema", "p.pescod", "p.tippescod", "p.devcod"],
- "Inner Unique": false,
- "Join Filter": "(a_1.devcod = b_1.devcod)",
- "Rows Removed by Join Filter": 0,
- "Shared Hit Blocks": 959166,
- "Shared Read Blocks": 40923,
- "Shared Dirtied Blocks": 1895,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 1207.346,
- "I/O Write Time": 0.000,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.420,
- "Actual Total Time": 3194.396,
- "Actual Rows": 237809,
- "Actual Loops": 1,
- "Shared Hit Blocks": 959010,
- "Shared Read Blocks": 40898,
- "Shared Dirtied Blocks": 1895,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 1206.462,
- "I/O Write Time": 0.000
- }
- ],
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 0.99,
- "Total Cost": 11266.91,
- "Plan Rows": 12,
- "Plan Width": 69,
- "Actual Startup Time": 0.114,
- "Actual Total Time": 750.781,
- "Actual Rows": 50859,
- "Actual Loops": 2,
- "Output": ["a_1.devcpf", "a_1.devnom", "a_1.carcod", "a_1.devcod", "p.pesema", "p.pescod", "p.tippescod", "p.devcod"],
- "Inner Unique": false,
- "Shared Hit Blocks": 503310,
- "Shared Read Blocks": 13069,
- "Shared Dirtied Blocks": 1894,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 414.441,
- "I/O Write Time": 0.000,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.156,
- "Actual Total Time": 1500.780,
- "Actual Rows": 101700,
- "Actual Loops": 1,
- "Shared Hit Blocks": 503226,
- "Shared Read Blocks": 13058,
- "Shared Dirtied Blocks": 1894,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 413.954,
- "I/O Write Time": 0.000
- }
- ],
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": true,
- "Scan Direction": "Forward",
- "Index Name": "devedor_iu0011",
- "Relation Name": "devedor",
- "Schema": "public",
- "Alias": "a_1",
- "Startup Cost": 0.56,
- "Total Cost": 8623.23,
- "Plan Rows": 1009,
- "Plan Width": 45,
- "Actual Startup Time": 0.055,
- "Actual Total Time": 282.678,
- "Actual Rows": 50859,
- "Actual Loops": 2,
- "Output": ["a_1.carcod", "a_1.devcod", "a_1.devcpf", "a_1.devdatnas", "a_1.devborent", "a_1.devdatinc", "a_1.devusuinc", "a_1.devdatatu", "a_1.devusuatu", "a_1.devnom", "a_1.devid", "a_1.devultaca", "a_1.devsal", "a_1.devsalatu", "a_1.devvenmaisantigo", "a_1.devdiamaisantigo", "a_1.devati", "a_1.devsitcomcom", "a_1.devsitcomcod", "a_1.devdatstatus", "a_1.devstatus", "a_1.devultimaremessalinha", "a_1.devdatultremessa", "a_1.devultimaremessa", "a_1.devvenacomaisantigo", "a_1.devdatadev", "a_1.devacordo", "a_1.devretdataca", "a_1.devretdatage", "a_1.devretusucod", "a_1.devusucod", "a_1.devsitcod", "a_1.devcadmaisrecente", "a_1.devcadmaisantigo", "a_1.devdiamaisrecente", "a_1.devvenmaisrecente", "a_1.devretseq", "a_1.devfase", "a_1.devvalpar", "a_1.devdatcal", "a_1.devdatat", "a_1.devqtdinc", "a_1.devdatpridev", "a_1.devriscod", "a_1.devultacepor", "a_1.devultpro", "a_1.devcodcam"],
- "Index Cond": "((a_1.carcod = $81) AND (a_1.devati = 0))",
- "Rows Removed by Index Recheck": 0,
- "Filter": "(a_1.devsal > '0'::numeric)",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 97893,
- "Shared Read Blocks": 10736,
- "Shared Dirtied Blocks": 1894,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 214.093,
- "I/O Write Time": 0.000,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.070,
- "Actual Total Time": 564.945,
- "Actual Rows": 101700,
- "Actual Loops": 1,
- "Shared Hit Blocks": 97877,
- "Shared Read Blocks": 10729,
- "Shared Dirtied Blocks": 1894,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 213.778,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "pessoa_iu0004",
- "Relation Name": "pessoa",
- "Schema": "public",
- "Alias": "p",
- "Startup Cost": 0.43,
- "Total Cost": 2.61,
- "Plan Rows": 1,
- "Plan Width": 28,
- "Actual Startup Time": 0.008,
- "Actual Total Time": 0.008,
- "Actual Rows": 1,
- "Actual Loops": 101718,
- "Output": ["p.pescod", "p.carcod", "p.devcod", "p.tippescod", "p.pesnom", "p.pescpf", "p.pesrg", "p.pesdatemirg", "p.pesorgemirg", "p.pesufrg", "p.pesnat", "p.pesufnat", "p.pesdatnas", "p.pespes", "p.pessex", "p.pesestciv", "p.pespai", "p.pesmae", "p.pesema", "p.pescon", "p.pesnegspc", "p.pesdatnegspc", "p.pesnegser", "p.pesdatnegser", "p.pesobs", "p.pesborent", "p.pesdatinc", "p.pesusuinc", "p.pesdatatu", "p.pesusuatu", "p.pessit", "p.pespar", "p.pesid", "p.pesstaconcod", "p.pessalcap", "p.pessitcon", "p.pesstajus", "p.pesbens", "p.pespenexp", "p.pessitant", "p.pesdatexp"],
- "Index Cond": "((p.devcod = a_1.devcod) AND (p.tippescod = 1) AND (p.carcod = $81))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 405417,
- "Shared Read Blocks": 2333,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 200.348,
- "I/O Write Time": 0.000,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.008,
- "Actual Total Time": 0.008,
- "Actual Rows": 1,
- "Actual Loops": 101700,
- "Shared Hit Blocks": 405349,
- "Shared Read Blocks": 2329,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 200.175,
- "I/O Write Time": 0.000
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "contrato_iu0013",
- "Relation Name": "contrato",
- "Schema": "public",
- "Alias": "b_1",
- "Startup Cost": 0.43,
- "Total Cost": 2.13,
- "Plan Rows": 1,
- "Plan Width": 40,
- "Actual Startup Time": 0.011,
- "Actual Total Time": 0.015,
- "Actual Rows": 2,
- "Actual Loops": 101718,
- "Output": ["b_1.concod", "b_1.carcod", "b_1.devcod", "b_1.connumcon", "b_1.procod", "b_1.filcod", "b_1.condatcad", "b_1.condatpredev", "b_1.connumpar", "b_1.condadadi", "b_1.condatinc", "b_1.conusuinc", "b_1.condatatu", "b_1.conusuatu", "b_1.conborent", "b_1.connumcar", "b_1.conati", "b_1.convalcon", "b_1.convalconatu", "b_1.convenmaisantigo", "b_1.condiamaisantigo", "b_1.convalsal", "b_1.convlrent", "b_1.condatquenov", "b_1.conid", "b_1.connovperacr"],
- "Index Cond": "((b_1.carcod = $81) AND (b_1.devcod = p.devcod))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 455856,
- "Shared Read Blocks": 27854,
- "Shared Dirtied Blocks": 1,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 792.905,
- "I/O Write Time": 0.000,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.011,
- "Actual Total Time": 0.015,
- "Actual Rows": 2,
- "Actual Loops": 101700,
- "Shared Hit Blocks": 455784,
- "Shared Read Blocks": 27840,
- "Shared Dirtied Blocks": 1,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 792.508,
- "I/O Write Time": 0.000
- }
- ]
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "retorno_pkey",
- "Relation Name": "retorno",
- "Schema": "public",
- "Alias": "r",
- "Startup Cost": 1.34,
- "Total Cost": 3.56,
- "Plan Rows": 1,
- "Plan Width": 22,
- "Actual Startup Time": 0.011,
- "Actual Total Time": 0.011,
- "Actual Rows": 1,
- "Actual Loops": 237842,
- "Output": ["r.retseq", "r.retdatage", "r.retaca", "r.retdataca", "r.retdatinc", "r.retati", "r.devcod", "r.rethor", "r.rettel", "r.retusucod", "r.usucod", "r.rettelsomnum", "r.retdatlei", "r.sitcod", "r.retcodopedis", "r.rettemaca", "r.retusulei", "r.rettip", "r.carcod", "r.sitcomcod", "r.retindacao", "r.sitcomcom", "r.retatipas", "r.retdepcod", "r.retori", "r.motretcod", "r.rettecdatfim", "r.rettecdatini", "r.retfincod", "r.retvalpro", "r.retdatpro", "r.retquatec", "r.retdiaatr", "r.retsalven", "r.retdevsal", "r.retusunomagehor", "r.retusucodagehor", "r.retnumacapriope", "r.retborsai", "r.retcodpro", "r.retdatintws", "r.retcarstacod", "r.retcanatecod", "r.retarqaud"],
- "Index Cond": "(r.retseq = (SubPlan 56))",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((r.carcod = $81) AND (a_1.devcod = r.devcod))",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 1156706,
- "Shared Read Blocks": 33409,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 1621.997,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Result",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 56",
- "Parallel Aware": false,
- "Startup Cost": 0.76,
- "Total Cost": 0.77,
- "Plan Rows": 1,
- "Plan Width": 8,
- "Actual Startup Time": 0.024,
- "Actual Total Time": 0.024,
- "Actual Rows": 1,
- "Actual Loops": 237842,
- "Output": ["$80"],
- "Shared Hit Blocks": 1040805,
- "Shared Read Blocks": 78049,
- "Shared Dirtied Blocks": 1014,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 3889.469,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Limit",
- "Parent Relationship": "InitPlan",
- "Subplan Name": "InitPlan 55 (returns $80)",
- "Parallel Aware": false,
- "Startup Cost": 0.57,
- "Total Cost": 0.76,
- "Plan Rows": 1,
- "Plan Width": 8,
- "Actual Startup Time": 0.023,
- "Actual Total Time": 0.023,
- "Actual Rows": 1,
- "Actual Loops": 237842,
- "Output": ["x_5.retseq"],
- "Shared Hit Blocks": 1040805,
- "Shared Read Blocks": 78049,
- "Shared Dirtied Blocks": 1014,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 3889.469,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Backward",
- "Index Name": "retorno_iu0011",
- "Relation Name": "retorno",
- "Schema": "public",
- "Alias": "x_5",
- "Startup Cost": 0.57,
- "Total Cost": 3.06,
- "Plan Rows": 13,
- "Plan Width": 8,
- "Actual Startup Time": 0.023,
- "Actual Total Time": 0.023,
- "Actual Rows": 1,
- "Actual Loops": 237842,
- "Output": ["x_5.retseq"],
- "Index Cond": "((x_5.devcod = a_1.devcod) AND (x_5.carcod = a_1.carcod) AND (x_5.retseq IS NOT NULL))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 91102,
- "Shared Hit Blocks": 1040805,
- "Shared Read Blocks": 78049,
- "Shared Dirtied Blocks": 1014,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 3889.469,
- "I/O Write Time": 0.000
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "contrato_parcela_iu0021",
- "Relation Name": "contrato_parcela",
- "Schema": "public",
- "Alias": "c_1",
- "Startup Cost": 0.44,
- "Total Cost": 19.97,
- "Plan Rows": 86,
- "Plan Width": 20,
- "Actual Startup Time": 0.020,
- "Actual Total Time": 0.020,
- "Actual Rows": 1,
- "Actual Loops": 237842,
- "Output": ["c_1.conparseq", "c_1.concod", "c_1.conparnum", "c_1.conpardatcad", "c_1.conpardatven", "c_1.conparvallan", "c_1.conpardadadi", "c_1.conparbancod", "c_1.conparage", "c_1.conparcon", "c_1.conparnumche", "c_1.conpardatapre", "c_1.conparborent", "c_1.conparali", "c_1.conparati", "c_1.conparusuinc", "c_1.conpardatatu", "c_1.conparusuatu", "c_1.conpardatinc", "c_1.conparacocod", "c_1.enccod", "c_1.conparstacal", "c_1.tiplancod", "c_1.conparidt", "c_1.conparvalsal", "c_1.conparvin", "c_1.conparboratu", "c_1.conparprocod", "c_1.conparpro", "c_1.conpartax", "c_1.conparvalori"],
- "Index Cond": "(c_1.concod = b_1.concod)",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 870482,
- "Shared Read Blocks": 85959,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 3567.204,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "parcela_morto_iu0005",
- "Relation Name": "contrato_parcela_morto",
- "Schema": "public",
- "Alias": "m",
- "Startup Cost": 0.56,
- "Total Cost": 1.51,
- "Plan Rows": 17,
- "Plan Width": 8,
- "Actual Startup Time": 0.006,
- "Actual Total Time": 0.006,
- "Actual Rows": 1,
- "Actual Loops": 241658,
- "Output": ["m.conparseq", "m.conparmorseq"],
- "Index Cond": "(m.conparseq = c_1.conparseq)",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 89,
- "Shared Hit Blocks": 1041381,
- "Shared Read Blocks": 4295,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 491.624,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "contrato_parcela_retoma_iu0011",
- "Relation Name": "contrato_parcela_retomada",
- "Schema": "public",
- "Alias": "d",
- "Startup Cost": 0.43,
- "Total Cost": 1.55,
- "Plan Rows": 28,
- "Plan Width": 8,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 1,
- "Actual Loops": 305201,
- "Output": ["d.conparseq"],
- "Index Cond": "(d.conparseq = c_1.conparseq)",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 10046,
- "Shared Hit Blocks": 944382,
- "Shared Read Blocks": 6032,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 322.170,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "carteira_pkey",
- "Relation Name": "carteira",
- "Schema": "public",
- "Alias": "g",
- "Startup Cost": 0.14,
- "Total Cost": 1.26,
- "Plan Rows": 1,
- "Plan Width": 4,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.025,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["g.carcod"],
- "Index Cond": "(g.carcod = $81)",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 15287801,
- "Shared Hit Blocks": 15940941,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "carteira_situacao_iu0003",
- "Relation Name": "carteira_situacao",
- "Schema": "public",
- "Alias": "e",
- "Startup Cost": 0.28,
- "Total Cost": 0.85,
- "Plan Rows": 1,
- "Plan Width": 6,
- "Actual Startup Time": 0.001,
- "Actual Total Time": 0.001,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["e.sitcod", "e.carcod"],
- "Index Cond": "((e.sitcod = r.sitcod) AND (e.carcod = $81))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 0,
- "Shared Hit Blocks": 1306278,
- "Shared Read Blocks": 1,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.124,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 40",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "carteira_situacao_iu0003",
- "Relation Name": "carteira_situacao",
- "Schema": "public",
- "Alias": "cs_1",
- "Startup Cost": 0.28,
- "Total Cost": 2.50,
- "Plan Rows": 1,
- "Plan Width": 17,
- "Actual Startup Time": 0.001,
- "Actual Total Time": 0.001,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["cs_1.sitnom"],
- "Index Cond": "((cs_1.sitcod = r.sitcod) AND (cs_1.carcod = a_1.carcod))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 1959417,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 41",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "contrato_detalhe_pkey",
- "Relation Name": "contrato_detalhe",
- "Schema": "public",
- "Alias": "cd_1",
- "Startup Cost": 0.56,
- "Total Cost": 6.19,
- "Plan Rows": 7,
- "Plan Width": 8,
- "Actual Startup Time": 0.019,
- "Actual Total Time": 0.019,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["cd_1.condetcar"],
- "Index Cond": "((cd_1.concod = b_1.concod) AND (cd_1.condetcod = 75))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 3159594,
- "Shared Read Blocks": 111082,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 10235.514,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Limit",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 42",
- "Parallel Aware": false,
- "Startup Cost": 4.55,
- "Total Cost": 4.56,
- "Plan Rows": 1,
- "Plan Width": 2,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["k_2.endufcod"],
- "Shared Hit Blocks": 2602397,
- "Shared Read Blocks": 25365,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 375.404,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Sort",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Startup Cost": 4.55,
- "Total Cost": 4.56,
- "Plan Rows": 4,
- "Plan Width": 2,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["k_2.endufcod"],
- "Sort Key": ["k_2.endufcod DESC"],
- "Sort Method": "quicksort",
- "Sort Space Used": 25,
- "Sort Space Type": "Memory",
- "Shared Hit Blocks": 2602397,
- "Shared Read Blocks": 25365,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 375.404,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "endereco_iu0008",
- "Relation Name": "endereco",
- "Schema": "public",
- "Alias": "k_2",
- "Startup Cost": 0.43,
- "Total Cost": 4.53,
- "Plan Rows": 4,
- "Plan Width": 2,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["k_2.endufcod"],
- "Index Cond": "((k_2.pescod = p.pescod) AND (k_2.tipendcod = 1))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 2602397,
- "Shared Read Blocks": 25365,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 375.404,
- "I/O Write Time": 0.000
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Limit",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 43",
- "Parallel Aware": false,
- "Startup Cost": 4.55,
- "Total Cost": 4.56,
- "Plan Rows": 1,
- "Plan Width": 10,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["k_3.endcid"],
- "Shared Hit Blocks": 2627762,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Sort",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Startup Cost": 4.55,
- "Total Cost": 4.56,
- "Plan Rows": 4,
- "Plan Width": 10,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["k_3.endcid"],
- "Sort Key": ["k_3.endcid DESC"],
- "Sort Method": "quicksort",
- "Sort Space Used": 25,
- "Sort Space Type": "Memory",
- "Shared Hit Blocks": 2627762,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "endereco_iu0008",
- "Relation Name": "endereco",
- "Schema": "public",
- "Alias": "k_3",
- "Startup Cost": 0.43,
- "Total Cost": 4.53,
- "Plan Rows": 4,
- "Plan Width": 10,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["k_3.endcid"],
- "Index Cond": "((k_3.pescod = p.pescod) AND (k_3.tipendcod = 1))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 2627762,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Limit",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 44",
- "Parallel Aware": false,
- "Startup Cost": 1.55,
- "Total Cost": 6.03,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.007,
- "Actual Total Time": 0.007,
- "Actual Rows": 0,
- "Actual Loops": 653139,
- "Output": ["(((t_6.teldddtel)::text || (t_6.teltel)::text))"],
- "Shared Hit Blocks": 6412707,
- "Shared Read Blocks": 11930,
- "Shared Dirtied Blocks": 1,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 544.067,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1.55,
- "Total Cost": 6.03,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.007,
- "Actual Total Time": 0.007,
- "Actual Rows": 0,
- "Actual Loops": 653139,
- "Output": ["((t_6.teldddtel)::text || (t_6.teltel)::text)"],
- "Inner Unique": false,
- "Shared Hit Blocks": 6412707,
- "Shared Read Blocks": 11930,
- "Shared Dirtied Blocks": 1,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 544.067,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1.12,
- "Total Cost": 4.47,
- "Plan Rows": 1,
- "Plan Width": 23,
- "Actual Startup Time": 0.006,
- "Actual Total Time": 0.006,
- "Actual Rows": 0,
- "Actual Loops": 653139,
- "Output": ["t_6.teldddtel", "t_6.teltel", "p_7.devcod", "p_7.carcod"],
- "Inner Unique": false,
- "Shared Hit Blocks": 5681417,
- "Shared Read Blocks": 11335,
- "Shared Dirtied Blocks": 1,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 535.284,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "pessoa_iu0002",
- "Relation Name": "pessoa",
- "Schema": "public",
- "Alias": "p_7",
- "Startup Cost": 0.56,
- "Total Cost": 1.68,
- "Plan Rows": 1,
- "Plan Width": 20,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["p_7.carcod", "p_7.devcod", "p_7.tippescod", "p_7.pescod"],
- "Index Cond": "((p_7.carcod = a_1.carcod) AND (p_7.devcod = a_1.devcod))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 211473,
- "Shared Hit Blocks": 2888240,
- "Shared Read Blocks": 2346,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 23.322,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "t_6",
- "Startup Cost": 0.56,
- "Total Cost": 2.78,
- "Plan Rows": 1,
- "Plan Width": 19,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 653139,
- "Output": ["t_6.telseq", "t_6.tiptelcod", "t_6.teldddtel", "t_6.teltel", "t_6.telramtel", "t_6.teldatinc", "t_6.teldatatu", "t_6.telobs", "t_6.telborent", "t_6.telusuinc", "t_6.telusuatu", "t_6.pescod", "t_6.telsomnum", "t_6.telsit", "t_6.telclas", "t_6.telsaldev", "t_6.telrespcod", "t_6.teldatten", "t_6.telqtdten", "t_6.telsta", "t_6.teltelhig", "t_6.teldddhig", "t_6.telid", "t_6.telopecod", "t_6.teldatpro", "t_6.telpenexp", "t_6.telsitant", "t_6.telori"],
- "Index Cond": "((t_6.pescod = p_7.pescod) AND (t_6.tiptelcod = 17))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 2793177,
- "Shared Read Blocks": 8989,
- "Shared Dirtied Blocks": 1,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 511.962,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "devedor_iu0021",
- "Relation Name": "devedor",
- "Schema": "public",
- "Alias": "d_7",
- "Startup Cost": 0.43,
- "Total Cost": 1.55,
- "Plan Rows": 1,
- "Plan Width": 12,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 1,
- "Actual Loops": 186228,
- "Output": ["d_7.devcod", "d_7.carcod"],
- "Index Cond": "((d_7.devcod = a_1.devcod) AND (d_7.carcod = a_1.carcod))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 167951,
- "Shared Hit Blocks": 731290,
- "Shared Read Blocks": 595,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 8.783,
- "I/O Write Time": 0.000
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Limit",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 45",
- "Parallel Aware": false,
- "Startup Cost": 1.55,
- "Total Cost": 9.16,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.008,
- "Actual Total Time": 0.008,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["(((t_7.teldddtel)::text || (t_7.teltel)::text))"],
- "Shared Hit Blocks": 8617486,
- "Shared Read Blocks": 18983,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 302.837,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1.55,
- "Total Cost": 9.16,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.007,
- "Actual Total Time": 0.007,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["((t_7.teldddtel)::text || (t_7.teltel)::text)"],
- "Inner Unique": false,
- "Shared Hit Blocks": 8617486,
- "Shared Read Blocks": 18983,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 302.837,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1.12,
- "Total Cost": 7.60,
- "Plan Rows": 1,
- "Plan Width": 23,
- "Actual Startup Time": 0.005,
- "Actual Total Time": 0.005,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["t_7.teldddtel", "t_7.teltel", "p_8.devcod", "p_8.carcod"],
- "Inner Unique": false,
- "Shared Hit Blocks": 6114472,
- "Shared Read Blocks": 18008,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 291.480,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "pessoa_iu0002",
- "Relation Name": "pessoa",
- "Schema": "public",
- "Alias": "p_8",
- "Startup Cost": 0.56,
- "Total Cost": 1.68,
- "Plan Rows": 1,
- "Plan Width": 20,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["p_8.carcod", "p_8.devcod", "p_8.tippescod", "p_8.pescod"],
- "Index Cond": "((p_8.carcod = a_1.carcod) AND (p_8.devcod = a_1.devcod))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 211423,
- "Shared Hit Blocks": 2887455,
- "Shared Read Blocks": 1,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.006,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "t_7",
- "Startup Cost": 0.56,
- "Total Cost": 5.86,
- "Plan Rows": 6,
- "Plan Width": 19,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 1,
- "Actual Loops": 653195,
- "Output": ["t_7.telseq", "t_7.tiptelcod", "t_7.teldddtel", "t_7.teltel", "t_7.telramtel", "t_7.teldatinc", "t_7.teldatatu", "t_7.telobs", "t_7.telborent", "t_7.telusuinc", "t_7.telusuatu", "t_7.pescod", "t_7.telsomnum", "t_7.telsit", "t_7.telclas", "t_7.telsaldev", "t_7.telrespcod", "t_7.teldatten", "t_7.telqtdten", "t_7.telsta", "t_7.teltelhig", "t_7.teldddhig", "t_7.telid", "t_7.telopecod", "t_7.teldatpro", "t_7.telpenexp", "t_7.telsitant", "t_7.telori"],
- "Index Cond": "((t_7.pescod = p_8.pescod) AND (t_7.tiptelcod = 1))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 3227017,
- "Shared Read Blocks": 18007,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 291.473,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "devedor_iu0021",
- "Relation Name": "devedor",
- "Schema": "public",
- "Alias": "d_8",
- "Startup Cost": 0.43,
- "Total Cost": 1.55,
- "Plan Rows": 1,
- "Plan Width": 12,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 1,
- "Actual Loops": 629430,
- "Output": ["d_8.devcod", "d_8.carcod"],
- "Index Cond": "((d_8.devcod = a_1.devcod) AND (d_8.carcod = a_1.carcod))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 570212,
- "Shared Hit Blocks": 2503014,
- "Shared Read Blocks": 975,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 11.358,
- "I/O Write Time": 0.000
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Limit",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 46",
- "Parallel Aware": false,
- "Startup Cost": 1.55,
- "Total Cost": 6.03,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 0,
- "Actual Loops": 653139,
- "Output": ["(((t_8.teldddtel)::text || (t_8.teltel)::text))"],
- "Shared Hit Blocks": 5564601,
- "Shared Read Blocks": 62,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.773,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1.55,
- "Total Cost": 6.03,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 0,
- "Actual Loops": 653139,
- "Output": ["((t_8.teldddtel)::text || (t_8.teltel)::text)"],
- "Inner Unique": false,
- "Shared Hit Blocks": 5564601,
- "Shared Read Blocks": 62,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.773,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1.12,
- "Total Cost": 4.47,
- "Plan Rows": 1,
- "Plan Width": 23,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 0,
- "Actual Loops": 653139,
- "Output": ["t_8.teldddtel", "t_8.teltel", "p_9.devcod", "p_9.carcod"],
- "Inner Unique": false,
- "Shared Hit Blocks": 5519084,
- "Shared Read Blocks": 61,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.765,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "pessoa_iu0002",
- "Relation Name": "pessoa",
- "Schema": "public",
- "Alias": "p_9",
- "Startup Cost": 0.56,
- "Total Cost": 1.68,
- "Plan Rows": 1,
- "Plan Width": 20,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["p_9.carcod", "p_9.devcod", "p_9.tippescod", "p_9.pescod"],
- "Index Cond": "((p_9.carcod = a_1.carcod) AND (p_9.devcod = a_1.devcod))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 211473,
- "Shared Hit Blocks": 2891507,
- "Shared Read Blocks": 5,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.203,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "t_8",
- "Startup Cost": 0.56,
- "Total Cost": 2.78,
- "Plan Rows": 1,
- "Plan Width": 19,
- "Actual Startup Time": 0.001,
- "Actual Total Time": 0.001,
- "Actual Rows": 0,
- "Actual Loops": 653273,
- "Output": ["t_8.telseq", "t_8.tiptelcod", "t_8.teldddtel", "t_8.teltel", "t_8.telramtel", "t_8.teldatinc", "t_8.teldatatu", "t_8.telobs", "t_8.telborent", "t_8.telusuinc", "t_8.telusuatu", "t_8.pescod", "t_8.telsomnum", "t_8.telsit", "t_8.telclas", "t_8.telsaldev", "t_8.telrespcod", "t_8.teldatten", "t_8.telqtdten", "t_8.telsta", "t_8.teltelhig", "t_8.teldddhig", "t_8.telid", "t_8.telopecod", "t_8.teldatpro", "t_8.telpenexp", "t_8.telsitant", "t_8.telori"],
- "Index Cond": "((t_8.pescod = p_9.pescod) AND (t_8.tiptelcod = 2))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 2627577,
- "Shared Read Blocks": 56,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.562,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "devedor_iu0021",
- "Relation Name": "devedor",
- "Schema": "public",
- "Alias": "d_9",
- "Startup Cost": 0.43,
- "Total Cost": 1.55,
- "Plan Rows": 1,
- "Plan Width": 12,
- "Actual Startup Time": 0.001,
- "Actual Total Time": 0.001,
- "Actual Rows": 1,
- "Actual Loops": 11584,
- "Output": ["d_9.devcod", "d_9.carcod"],
- "Index Cond": "((d_9.devcod = a_1.devcod) AND (d_9.carcod = a_1.carcod))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 10582,
- "Shared Hit Blocks": 45517,
- "Shared Read Blocks": 1,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.007,
- "I/O Write Time": 0.000
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Limit",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 47",
- "Parallel Aware": false,
- "Startup Cost": 1.55,
- "Total Cost": 7.28,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.006,
- "Actual Total Time": 0.006,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["(((t_9.teldddtel)::text || (t_9.teltel)::text))"],
- "Shared Hit Blocks": 8217051,
- "Shared Read Blocks": 4483,
- "Shared Dirtied Blocks": 1,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 59.932,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1.55,
- "Total Cost": 7.28,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.006,
- "Actual Total Time": 0.006,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["((t_9.teldddtel)::text || (t_9.teltel)::text)"],
- "Inner Unique": false,
- "Shared Hit Blocks": 8217051,
- "Shared Read Blocks": 4483,
- "Shared Dirtied Blocks": 1,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 59.932,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1.12,
- "Total Cost": 5.72,
- "Plan Rows": 1,
- "Plan Width": 23,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["t_9.teldddtel", "t_9.teltel", "p_10.devcod", "p_10.carcod"],
- "Inner Unique": false,
- "Shared Hit Blocks": 6046991,
- "Shared Read Blocks": 4457,
- "Shared Dirtied Blocks": 1,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 59.526,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "pessoa_iu0002",
- "Relation Name": "pessoa",
- "Schema": "public",
- "Alias": "p_10",
- "Startup Cost": 0.56,
- "Total Cost": 1.68,
- "Plan Rows": 1,
- "Plan Width": 20,
- "Actual Startup Time": 0.001,
- "Actual Total Time": 0.002,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["p_10.carcod", "p_10.devcod", "p_10.tippescod", "p_10.pescod"],
- "Index Cond": "((p_10.carcod = a_1.carcod) AND (p_10.devcod = a_1.devcod))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 211424,
- "Shared Hit Blocks": 2887919,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "t_9",
- "Startup Cost": 0.56,
- "Total Cost": 4.01,
- "Plan Rows": 3,
- "Plan Width": 19,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["t_9.telseq", "t_9.tiptelcod", "t_9.teldddtel", "t_9.teltel", "t_9.telramtel", "t_9.teldatinc", "t_9.teldatatu", "t_9.telobs", "t_9.telborent", "t_9.telusuinc", "t_9.telusuatu", "t_9.pescod", "t_9.telsomnum", "t_9.telsit", "t_9.telclas", "t_9.telsaldev", "t_9.telrespcod", "t_9.teldatten", "t_9.telqtdten", "t_9.telsta", "t_9.teltelhig", "t_9.teldddhig", "t_9.telid", "t_9.telopecod", "t_9.teldatpro", "t_9.telpenexp", "t_9.telsitant", "t_9.telori"],
- "Index Cond": "((t_9.pescod = p_10.pescod) AND (t_9.tiptelcod = 3))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 3159072,
- "Shared Read Blocks": 4457,
- "Shared Dirtied Blocks": 1,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 59.526,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "devedor_iu0021",
- "Relation Name": "devedor",
- "Schema": "public",
- "Alias": "d_10",
- "Startup Cost": 0.43,
- "Total Cost": 1.55,
- "Plan Rows": 1,
- "Plan Width": 12,
- "Actual Startup Time": 0.001,
- "Actual Total Time": 0.001,
- "Actual Rows": 1,
- "Actual Loops": 547915,
- "Output": ["d_10.devcod", "d_10.carcod"],
- "Index Cond": "((d_10.devcod = a_1.devcod) AND (d_10.carcod = a_1.carcod))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 494552,
- "Shared Hit Blocks": 2170060,
- "Shared Read Blocks": 26,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.406,
- "I/O Write Time": 0.000
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 48",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["string_agg(((tel_21.teldddtel)::text || (tel_21.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 4868214,
- "Shared Read Blocks": 5638,
- "Shared Dirtied Blocks": 52,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 83.522,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_21",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 653139,
- "Output": ["tel_21.telseq", "tel_21.tiptelcod", "tel_21.teldddtel", "tel_21.teltel", "tel_21.telramtel", "tel_21.teldatinc", "tel_21.teldatatu", "tel_21.telobs", "tel_21.telborent", "tel_21.telusuinc", "tel_21.telusuatu", "tel_21.pescod", "tel_21.telsomnum", "tel_21.telsit", "tel_21.telclas", "tel_21.telsaldev", "tel_21.telrespcod", "tel_21.teldatten", "tel_21.telqtdten", "tel_21.telsta", "tel_21.teltelhig", "tel_21.teldddhig", "tel_21.telid", "tel_21.telopecod", "tel_21.teldatpro", "tel_21.telpenexp", "tel_21.telsitant", "tel_21.telori"],
- "Index Cond": "(tel_21.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel_21.telsit <> ALL ('{2,5}'::integer[])) AND (tel_21.telclas = 1))",
- "Rows Removed by Filter": 5,
- "Shared Hit Blocks": 4868214,
- "Shared Read Blocks": 5638,
- "Shared Dirtied Blocks": 52,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 83.522,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 49",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["string_agg(((tel_22.teldddtel)::text || (tel_22.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 4873852,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_22",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 653139,
- "Output": ["tel_22.telseq", "tel_22.tiptelcod", "tel_22.teldddtel", "tel_22.teltel", "tel_22.telramtel", "tel_22.teldatinc", "tel_22.teldatatu", "tel_22.telobs", "tel_22.telborent", "tel_22.telusuinc", "tel_22.telusuatu", "tel_22.pescod", "tel_22.telsomnum", "tel_22.telsit", "tel_22.telclas", "tel_22.telsaldev", "tel_22.telrespcod", "tel_22.teldatten", "tel_22.telqtdten", "tel_22.telsta", "tel_22.teltelhig", "tel_22.teldddhig", "tel_22.telid", "tel_22.telopecod", "tel_22.teldatpro", "tel_22.telpenexp", "tel_22.telsitant", "tel_22.telori"],
- "Index Cond": "(tel_22.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel_22.telsit <> ALL ('{2,5}'::integer[])) AND (tel_22.telclas = 2))",
- "Rows Removed by Filter": 5,
- "Shared Hit Blocks": 4873852,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 50",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["string_agg(((tel_23.teldddtel)::text || (tel_23.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 4873852,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_23",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 653139,
- "Output": ["tel_23.telseq", "tel_23.tiptelcod", "tel_23.teldddtel", "tel_23.teltel", "tel_23.telramtel", "tel_23.teldatinc", "tel_23.teldatatu", "tel_23.telobs", "tel_23.telborent", "tel_23.telusuinc", "tel_23.telusuatu", "tel_23.pescod", "tel_23.telsomnum", "tel_23.telsit", "tel_23.telclas", "tel_23.telsaldev", "tel_23.telrespcod", "tel_23.teldatten", "tel_23.telqtdten", "tel_23.telsta", "tel_23.teltelhig", "tel_23.teldddhig", "tel_23.telid", "tel_23.telopecod", "tel_23.teldatpro", "tel_23.telpenexp", "tel_23.telsitant", "tel_23.telori"],
- "Index Cond": "(tel_23.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel_23.telsit <> ALL ('{2,5}'::integer[])) AND (tel_23.telclas = 3))",
- "Rows Removed by Filter": 5,
- "Shared Hit Blocks": 4873852,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 51",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["string_agg(((tel_24.teldddtel)::text || (tel_24.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 4873852,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_24",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 653139,
- "Output": ["tel_24.telseq", "tel_24.tiptelcod", "tel_24.teldddtel", "tel_24.teltel", "tel_24.telramtel", "tel_24.teldatinc", "tel_24.teldatatu", "tel_24.telobs", "tel_24.telborent", "tel_24.telusuinc", "tel_24.telusuatu", "tel_24.pescod", "tel_24.telsomnum", "tel_24.telsit", "tel_24.telclas", "tel_24.telsaldev", "tel_24.telrespcod", "tel_24.teldatten", "tel_24.telqtdten", "tel_24.telsta", "tel_24.teltelhig", "tel_24.teldddhig", "tel_24.telid", "tel_24.telopecod", "tel_24.teldatpro", "tel_24.telpenexp", "tel_24.telsitant", "tel_24.telori"],
- "Index Cond": "(tel_24.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel_24.telsit <> ALL ('{2,5}'::integer[])) AND (tel_24.telclas = 4))",
- "Rows Removed by Filter": 5,
- "Shared Hit Blocks": 4873852,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 52",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["string_agg(((tel_25.teldddtel)::text || (tel_25.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 4873852,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_25",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 653139,
- "Output": ["tel_25.telseq", "tel_25.tiptelcod", "tel_25.teldddtel", "tel_25.teltel", "tel_25.telramtel", "tel_25.teldatinc", "tel_25.teldatatu", "tel_25.telobs", "tel_25.telborent", "tel_25.telusuinc", "tel_25.telusuatu", "tel_25.pescod", "tel_25.telsomnum", "tel_25.telsit", "tel_25.telclas", "tel_25.telsaldev", "tel_25.telrespcod", "tel_25.teldatten", "tel_25.telqtdten", "tel_25.telsta", "tel_25.teltelhig", "tel_25.teldddhig", "tel_25.telid", "tel_25.telopecod", "tel_25.teldatpro", "tel_25.telpenexp", "tel_25.telsitant", "tel_25.telori"],
- "Index Cond": "(tel_25.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel_25.telsit <> ALL ('{2,5}'::integer[])) AND (tel_25.telclas = 5))",
- "Rows Removed by Filter": 4,
- "Shared Hit Blocks": 4873852,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 53",
- "Parallel Aware": false,
- "Startup Cost": 9.56,
- "Total Cost": 9.57,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["string_agg(((tel_26.teldddtel)::text || (tel_26.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 4873852,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_26",
- "Startup Cost": 0.56,
- "Total Cost": 9.56,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 653139,
- "Output": ["tel_26.telseq", "tel_26.tiptelcod", "tel_26.teldddtel", "tel_26.teltel", "tel_26.telramtel", "tel_26.teldatinc", "tel_26.teldatatu", "tel_26.telobs", "tel_26.telborent", "tel_26.telusuinc", "tel_26.telusuatu", "tel_26.pescod", "tel_26.telsomnum", "tel_26.telsit", "tel_26.telclas", "tel_26.telsaldev", "tel_26.telrespcod", "tel_26.teldatten", "tel_26.telqtdten", "tel_26.telsta", "tel_26.teltelhig", "tel_26.teldddhig", "tel_26.telid", "tel_26.telopecod", "tel_26.teldatpro", "tel_26.telpenexp", "tel_26.telsitant", "tel_26.telori"],
- "Index Cond": "(tel_26.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "(tel_26.telclas = 6)",
- "Rows Removed by Filter": 5,
- "Shared Hit Blocks": 4873852,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 54",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["string_agg(((tel_27.teldddtel)::text || (tel_27.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 4873852,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_27",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 653139,
- "Output": ["tel_27.telseq", "tel_27.tiptelcod", "tel_27.teldddtel", "tel_27.teltel", "tel_27.telramtel", "tel_27.teldatinc", "tel_27.teldatatu", "tel_27.telobs", "tel_27.telborent", "tel_27.telusuinc", "tel_27.telusuatu", "tel_27.pescod", "tel_27.telsomnum", "tel_27.telsit", "tel_27.telclas", "tel_27.telsaldev", "tel_27.telrespcod", "tel_27.teldatten", "tel_27.telqtdten", "tel_27.telsta", "tel_27.teltelhig", "tel_27.teldddhig", "tel_27.telid", "tel_27.telopecod", "tel_27.teldatpro", "tel_27.telpenexp", "tel_27.telsitant", "tel_27.telori"],
- "Index Cond": "(tel_27.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel_27.telsit <> ALL ('{2,5}'::integer[])) AND (tel_27.telclas = 7))",
- "Rows Removed by Filter": 4,
- "Shared Hit Blocks": 4873852,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 9",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "carteira_situacao_iu0003",
- "Relation Name": "carteira_situacao",
- "Schema": "public",
- "Alias": "cs",
- "Startup Cost": 0.28,
- "Total Cost": 2.50,
- "Plan Rows": 1,
- "Plan Width": 17,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["cs.sitnom"],
- "Index Cond": "((cs.sitcod = r.sitcod) AND (cs.carcod = a_1.carcod))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 714141,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 10",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "contrato_detalhe_pkey",
- "Relation Name": "contrato_detalhe",
- "Schema": "public",
- "Alias": "cd",
- "Startup Cost": 0.56,
- "Total Cost": 6.19,
- "Plan Rows": 7,
- "Plan Width": 8,
- "Actual Startup Time": 0.005,
- "Actual Total Time": 0.005,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["cd.condetcar"],
- "Index Cond": "((cd.concod = b_1.concod) AND (cd.condetcod = 75))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 1189746,
- "Shared Read Blocks": 2358,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 19.599,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Limit",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 11",
- "Parallel Aware": false,
- "Startup Cost": 4.55,
- "Total Cost": 4.56,
- "Plan Rows": 1,
- "Plan Width": 2,
- "Actual Startup Time": 0.005,
- "Actual Total Time": 0.005,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["k.endufcod"],
- "Shared Hit Blocks": 955879,
- "Shared Read Blocks": 11,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.114,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Sort",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Startup Cost": 4.55,
- "Total Cost": 4.56,
- "Plan Rows": 4,
- "Plan Width": 2,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["k.endufcod"],
- "Sort Key": ["k.endufcod DESC"],
- "Sort Method": "quicksort",
- "Sort Space Used": 25,
- "Sort Space Type": "Memory",
- "Shared Hit Blocks": 955879,
- "Shared Read Blocks": 11,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.114,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "endereco_iu0008",
- "Relation Name": "endereco",
- "Schema": "public",
- "Alias": "k",
- "Startup Cost": 0.43,
- "Total Cost": 4.53,
- "Plan Rows": 4,
- "Plan Width": 2,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["k.endufcod"],
- "Index Cond": "((k.pescod = p.pescod) AND (k.tipendcod = 1))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 955879,
- "Shared Read Blocks": 11,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.114,
- "I/O Write Time": 0.000
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Limit",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 12",
- "Parallel Aware": false,
- "Startup Cost": 4.55,
- "Total Cost": 4.56,
- "Plan Rows": 1,
- "Plan Width": 10,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["k_1.endcid"],
- "Shared Hit Blocks": 955890,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Sort",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Startup Cost": 4.55,
- "Total Cost": 4.56,
- "Plan Rows": 4,
- "Plan Width": 10,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["k_1.endcid"],
- "Sort Key": ["k_1.endcid DESC"],
- "Sort Method": "quicksort",
- "Sort Space Used": 25,
- "Sort Space Type": "Memory",
- "Shared Hit Blocks": 955890,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "endereco_iu0008",
- "Relation Name": "endereco",
- "Schema": "public",
- "Alias": "k_1",
- "Startup Cost": 0.43,
- "Total Cost": 4.53,
- "Plan Rows": 4,
- "Plan Width": 10,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["k_1.endcid"],
- "Index Cond": "((k_1.pescod = p.pescod) AND (k_1.tipendcod = 1))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 955890,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Limit",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 13",
- "Parallel Aware": false,
- "Startup Cost": 1.55,
- "Total Cost": 6.03,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.007,
- "Actual Total Time": 0.007,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["(((t.teldddtel)::text || (t.teltel)::text))"],
- "Shared Hit Blocks": 2256641,
- "Shared Read Blocks": 32,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.279,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1.55,
- "Total Cost": 6.03,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.007,
- "Actual Total Time": 0.007,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["((t.teldddtel)::text || (t.teltel)::text)"],
- "Inner Unique": false,
- "Shared Hit Blocks": 2256641,
- "Shared Read Blocks": 32,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.279,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1.12,
- "Total Cost": 4.47,
- "Plan Rows": 1,
- "Plan Width": 23,
- "Actual Startup Time": 0.006,
- "Actual Total Time": 0.006,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["t.teldddtel", "t.teltel", "p_1.devcod", "p_1.carcod"],
- "Inner Unique": false,
- "Shared Hit Blocks": 2085957,
- "Shared Read Blocks": 19,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.165,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "pessoa_iu0002",
- "Relation Name": "pessoa",
- "Schema": "public",
- "Alias": "p_1",
- "Startup Cost": 0.56,
- "Total Cost": 1.68,
- "Plan Rows": 1,
- "Plan Width": 20,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["p_1.carcod", "p_1.devcod", "p_1.tippescod", "p_1.pescod"],
- "Index Cond": "((p_1.carcod = a_1.carcod) AND (p_1.devcod = a_1.devcod))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 74040,
- "Shared Hit Blocks": 1090040,
- "Shared Read Blocks": 7,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.057,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "t",
- "Startup Cost": 0.56,
- "Total Cost": 2.78,
- "Plan Rows": 1,
- "Plan Width": 19,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["t.telseq", "t.tiptelcod", "t.teldddtel", "t.teltel", "t.telramtel", "t.teldatinc", "t.teldatatu", "t.telobs", "t.telborent", "t.telusuinc", "t.telusuatu", "t.pescod", "t.telsomnum", "t.telsit", "t.telclas", "t.telsaldev", "t.telrespcod", "t.teldatten", "t.telqtdten", "t.telsta", "t.teltelhig", "t.teldddhig", "t.telid", "t.telopecod", "t.teldatpro", "t.telpenexp", "t.telsitant", "t.telori"],
- "Index Cond": "((t.pescod = p_1.pescod) AND (t.tiptelcod = 17))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 995917,
- "Shared Read Blocks": 12,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.109,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "devedor_iu0021",
- "Relation Name": "devedor",
- "Schema": "public",
- "Alias": "d_1",
- "Startup Cost": 0.43,
- "Total Cost": 1.55,
- "Plan Rows": 1,
- "Plan Width": 12,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 42422,
- "Output": ["d_1.devcod", "d_1.carcod"],
- "Index Cond": "((d_1.devcod = a_1.devcod) AND (d_1.carcod = a_1.carcod))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 37905,
- "Shared Hit Blocks": 170684,
- "Shared Read Blocks": 13,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.114,
- "I/O Write Time": 0.000
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Limit",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 14",
- "Parallel Aware": false,
- "Startup Cost": 1.55,
- "Total Cost": 9.16,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.009,
- "Actual Total Time": 0.009,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["(((t_1.teldddtel)::text || (t_1.teltel)::text))"],
- "Shared Hit Blocks": 3236123,
- "Shared Read Blocks": 715,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 5.960,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1.55,
- "Total Cost": 9.16,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.008,
- "Actual Total Time": 0.008,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["((t_1.teldddtel)::text || (t_1.teltel)::text)"],
- "Inner Unique": false,
- "Shared Hit Blocks": 3236123,
- "Shared Read Blocks": 715,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 5.960,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1.12,
- "Total Cost": 7.60,
- "Plan Rows": 1,
- "Plan Width": 23,
- "Actual Startup Time": 0.005,
- "Actual Total Time": 0.005,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["t_1.teldddtel", "t_1.teltel", "p_2.devcod", "p_2.carcod"],
- "Inner Unique": false,
- "Shared Hit Blocks": 2274745,
- "Shared Read Blocks": 689,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 5.703,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "pessoa_iu0002",
- "Relation Name": "pessoa",
- "Schema": "public",
- "Alias": "p_2",
- "Startup Cost": 0.56,
- "Total Cost": 1.68,
- "Plan Rows": 1,
- "Plan Width": 20,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["p_2.carcod", "p_2.devcod", "p_2.tippescod", "p_2.pescod"],
- "Index Cond": "((p_2.carcod = a_1.carcod) AND (p_2.devcod = a_1.devcod))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 74010,
- "Shared Hit Blocks": 1088724,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "t_1",
- "Startup Cost": 0.56,
- "Total Cost": 5.86,
- "Plan Rows": 6,
- "Plan Width": 19,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 1,
- "Actual Loops": 238052,
- "Output": ["t_1.telseq", "t_1.tiptelcod", "t_1.teldddtel", "t_1.teltel", "t_1.telramtel", "t_1.teldatinc", "t_1.teldatatu", "t_1.telobs", "t_1.telborent", "t_1.telusuinc", "t_1.telusuatu", "t_1.pescod", "t_1.telsomnum", "t_1.telsit", "t_1.telclas", "t_1.telsaldev", "t_1.telrespcod", "t_1.teldatten", "t_1.telqtdten", "t_1.telsta", "t_1.teltelhig", "t_1.teldddhig", "t_1.telid", "t_1.telopecod", "t_1.teldatpro", "t_1.telpenexp", "t_1.telsitant", "t_1.telori"],
- "Index Cond": "((t_1.pescod = p_2.pescod) AND (t_1.tiptelcod = 1))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 1186021,
- "Shared Read Blocks": 689,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 5.703,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "devedor_iu0021",
- "Relation Name": "devedor",
- "Schema": "public",
- "Alias": "d_2",
- "Startup Cost": 0.43,
- "Total Cost": 1.55,
- "Plan Rows": 1,
- "Plan Width": 12,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 233303,
- "Output": ["d_2.devcod", "d_2.carcod"],
- "Index Cond": "((d_2.devcod = a_1.devcod) AND (d_2.carcod = a_1.carcod))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 213503,
- "Shared Hit Blocks": 961378,
- "Shared Read Blocks": 26,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.257,
- "I/O Write Time": 0.000
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Limit",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 15",
- "Parallel Aware": false,
- "Startup Cost": 1.55,
- "Total Cost": 6.03,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["(((t_2.teldddtel)::text || (t_2.teltel)::text))"],
- "Shared Hit Blocks": 2055302,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1.55,
- "Total Cost": 6.03,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["((t_2.teldddtel)::text || (t_2.teltel)::text)"],
- "Inner Unique": false,
- "Shared Hit Blocks": 2055302,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1.12,
- "Total Cost": 4.47,
- "Plan Rows": 1,
- "Plan Width": 23,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["t_2.teldddtel", "t_2.teltel", "p_3.devcod", "p_3.carcod"],
- "Inner Unique": false,
- "Shared Hit Blocks": 2046121,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "pessoa_iu0002",
- "Relation Name": "pessoa",
- "Schema": "public",
- "Alias": "p_3",
- "Startup Cost": 0.56,
- "Total Cost": 1.68,
- "Plan Rows": 1,
- "Plan Width": 20,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["p_3.carcod", "p_3.devcod", "p_3.tippescod", "p_3.pescod"],
- "Index Cond": "((p_3.carcod = a_1.carcod) AND (p_3.devcod = a_1.devcod))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 74040,
- "Shared Hit Blocks": 1090238,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "t_2",
- "Startup Cost": 0.56,
- "Total Cost": 2.78,
- "Plan Rows": 1,
- "Plan Width": 19,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 238055,
- "Output": ["t_2.telseq", "t_2.tiptelcod", "t_2.teldddtel", "t_2.teltel", "t_2.telramtel", "t_2.teldatinc", "t_2.teldatatu", "t_2.telobs", "t_2.telborent", "t_2.telusuinc", "t_2.telusuatu", "t_2.pescod", "t_2.telsomnum", "t_2.telsit", "t_2.telclas", "t_2.telsaldev", "t_2.telrespcod", "t_2.teldatten", "t_2.telqtdten", "t_2.telsta", "t_2.teltelhig", "t_2.teldddhig", "t_2.telid", "t_2.telopecod", "t_2.teldatpro", "t_2.telpenexp", "t_2.telsitant", "t_2.telori"],
- "Index Cond": "((t_2.pescod = p_3.pescod) AND (t_2.tiptelcod = 2))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 955883,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "devedor_iu0021",
- "Relation Name": "devedor",
- "Schema": "public",
- "Alias": "d_3",
- "Startup Cost": 0.43,
- "Total Cost": 1.55,
- "Plan Rows": 1,
- "Plan Width": 12,
- "Actual Startup Time": 0.001,
- "Actual Total Time": 0.001,
- "Actual Rows": 1,
- "Actual Loops": 2314,
- "Output": ["d_3.devcod", "d_3.carcod"],
- "Index Cond": "((d_3.devcod = a_1.devcod) AND (d_3.carcod = a_1.carcod))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 2065,
- "Shared Hit Blocks": 9181,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Limit",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 16",
- "Parallel Aware": false,
- "Startup Cost": 1.55,
- "Total Cost": 7.28,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.006,
- "Actual Total Time": 0.006,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["(((t_3.teldddtel)::text || (t_3.teltel)::text))"],
- "Shared Hit Blocks": 2929544,
- "Shared Read Blocks": 43,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.358,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1.55,
- "Total Cost": 7.28,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.006,
- "Actual Total Time": 0.006,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["((t_3.teldddtel)::text || (t_3.teltel)::text)"],
- "Inner Unique": false,
- "Shared Hit Blocks": 2929544,
- "Shared Read Blocks": 43,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.358,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1.12,
- "Total Cost": 5.72,
- "Plan Rows": 1,
- "Plan Width": 23,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["t_3.teldddtel", "t_3.teltel", "p_4.devcod", "p_4.carcod"],
- "Inner Unique": false,
- "Shared Hit Blocks": 2216536,
- "Shared Read Blocks": 43,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.358,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "pessoa_iu0002",
- "Relation Name": "pessoa",
- "Schema": "public",
- "Alias": "p_4",
- "Startup Cost": 0.56,
- "Total Cost": 1.68,
- "Plan Rows": 1,
- "Plan Width": 20,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["p_4.carcod", "p_4.devcod", "p_4.tippescod", "p_4.pescod"],
- "Index Cond": "((p_4.carcod = a_1.carcod) AND (p_4.devcod = a_1.devcod))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 74011,
- "Shared Hit Blocks": 1089120,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "t_3",
- "Startup Cost": 0.56,
- "Total Cost": 4.01,
- "Plan Rows": 3,
- "Plan Width": 19,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["t_3.telseq", "t_3.tiptelcod", "t_3.teldddtel", "t_3.teltel", "t_3.telramtel", "t_3.teldatinc", "t_3.teldatatu", "t_3.telobs", "t_3.telborent", "t_3.telusuinc", "t_3.telusuatu", "t_3.pescod", "t_3.telsomnum", "t_3.telsit", "t_3.telclas", "t_3.telsaldev", "t_3.telrespcod", "t_3.teldatten", "t_3.telqtdten", "t_3.telsta", "t_3.teltelhig", "t_3.teldddhig", "t_3.telid", "t_3.telopecod", "t_3.teldatpro", "t_3.telpenexp", "t_3.telsitant", "t_3.telori"],
- "Index Cond": "((t_3.pescod = p_4.pescod) AND (t_3.tiptelcod = 3))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 1127416,
- "Shared Read Blocks": 43,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.358,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "devedor_iu0021",
- "Relation Name": "devedor",
- "Schema": "public",
- "Alias": "d_4",
- "Startup Cost": 0.43,
- "Total Cost": 1.55,
- "Plan Rows": 1,
- "Plan Width": 12,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 1,
- "Actual Loops": 173853,
- "Output": ["d_4.devcod", "d_4.carcod"],
- "Index Cond": "((d_4.devcod = a_1.devcod) AND (d_4.carcod = a_1.carcod))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 158233,
- "Shared Hit Blocks": 713008,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 17",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["string_agg(((tel.teldddtel)::text || (tel.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["tel.telseq", "tel.tiptelcod", "tel.teldddtel", "tel.teltel", "tel.telramtel", "tel.teldatinc", "tel.teldatatu", "tel.telobs", "tel.telborent", "tel.telusuinc", "tel.telusuatu", "tel.pescod", "tel.telsomnum", "tel.telsit", "tel.telclas", "tel.telsaldev", "tel.telrespcod", "tel.teldatten", "tel.telqtdten", "tel.telsta", "tel.teltelhig", "tel.teldddhig", "tel.telid", "tel.telopecod", "tel.teldatpro", "tel.telpenexp", "tel.telsitant", "tel.telori"],
- "Index Cond": "(tel.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel.telsit <> ALL ('{2,5}'::integer[])) AND (tel.telclas = 1))",
- "Rows Removed by Filter": 4,
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 18",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["string_agg(((tel_1.teldddtel)::text || (tel_1.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_1",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["tel_1.telseq", "tel_1.tiptelcod", "tel_1.teldddtel", "tel_1.teltel", "tel_1.telramtel", "tel_1.teldatinc", "tel_1.teldatatu", "tel_1.telobs", "tel_1.telborent", "tel_1.telusuinc", "tel_1.telusuatu", "tel_1.pescod", "tel_1.telsomnum", "tel_1.telsit", "tel_1.telclas", "tel_1.telsaldev", "tel_1.telrespcod", "tel_1.teldatten", "tel_1.telqtdten", "tel_1.telsta", "tel_1.teltelhig", "tel_1.teldddhig", "tel_1.telid", "tel_1.telopecod", "tel_1.teldatpro", "tel_1.telpenexp", "tel_1.telsitant", "tel_1.telori"],
- "Index Cond": "(tel_1.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel_1.telsit <> ALL ('{2,5}'::integer[])) AND (tel_1.telclas = 2))",
- "Rows Removed by Filter": 4,
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 19",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["string_agg(((tel_2.teldddtel)::text || (tel_2.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_2",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["tel_2.telseq", "tel_2.tiptelcod", "tel_2.teldddtel", "tel_2.teltel", "tel_2.telramtel", "tel_2.teldatinc", "tel_2.teldatatu", "tel_2.telobs", "tel_2.telborent", "tel_2.telusuinc", "tel_2.telusuatu", "tel_2.pescod", "tel_2.telsomnum", "tel_2.telsit", "tel_2.telclas", "tel_2.telsaldev", "tel_2.telrespcod", "tel_2.teldatten", "tel_2.telqtdten", "tel_2.telsta", "tel_2.teltelhig", "tel_2.teldddhig", "tel_2.telid", "tel_2.telopecod", "tel_2.teldatpro", "tel_2.telpenexp", "tel_2.telsitant", "tel_2.telori"],
- "Index Cond": "(tel_2.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel_2.telsit <> ALL ('{2,5}'::integer[])) AND (tel_2.telclas = 3))",
- "Rows Removed by Filter": 4,
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 20",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["string_agg(((tel_3.teldddtel)::text || (tel_3.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_3",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["tel_3.telseq", "tel_3.tiptelcod", "tel_3.teldddtel", "tel_3.teltel", "tel_3.telramtel", "tel_3.teldatinc", "tel_3.teldatatu", "tel_3.telobs", "tel_3.telborent", "tel_3.telusuinc", "tel_3.telusuatu", "tel_3.pescod", "tel_3.telsomnum", "tel_3.telsit", "tel_3.telclas", "tel_3.telsaldev", "tel_3.telrespcod", "tel_3.teldatten", "tel_3.telqtdten", "tel_3.telsta", "tel_3.teltelhig", "tel_3.teldddhig", "tel_3.telid", "tel_3.telopecod", "tel_3.teldatpro", "tel_3.telpenexp", "tel_3.telsitant", "tel_3.telori"],
- "Index Cond": "(tel_3.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel_3.telsit <> ALL ('{2,5}'::integer[])) AND (tel_3.telclas = 4))",
- "Rows Removed by Filter": 4,
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 21",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["string_agg(((tel_4.teldddtel)::text || (tel_4.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_4",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["tel_4.telseq", "tel_4.tiptelcod", "tel_4.teldddtel", "tel_4.teltel", "tel_4.telramtel", "tel_4.teldatinc", "tel_4.teldatatu", "tel_4.telobs", "tel_4.telborent", "tel_4.telusuinc", "tel_4.telusuatu", "tel_4.pescod", "tel_4.telsomnum", "tel_4.telsit", "tel_4.telclas", "tel_4.telsaldev", "tel_4.telrespcod", "tel_4.teldatten", "tel_4.telqtdten", "tel_4.telsta", "tel_4.teltelhig", "tel_4.teldddhig", "tel_4.telid", "tel_4.telopecod", "tel_4.teldatpro", "tel_4.telpenexp", "tel_4.telsitant", "tel_4.telori"],
- "Index Cond": "(tel_4.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel_4.telsit <> ALL ('{2,5}'::integer[])) AND (tel_4.telclas = 5))",
- "Rows Removed by Filter": 4,
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 22",
- "Parallel Aware": false,
- "Startup Cost": 9.56,
- "Total Cost": 9.57,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["string_agg(((tel_5.teldddtel)::text || (tel_5.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_5",
- "Startup Cost": 0.56,
- "Total Cost": 9.56,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["tel_5.telseq", "tel_5.tiptelcod", "tel_5.teldddtel", "tel_5.teltel", "tel_5.telramtel", "tel_5.teldatinc", "tel_5.teldatatu", "tel_5.telobs", "tel_5.telborent", "tel_5.telusuinc", "tel_5.telusuatu", "tel_5.pescod", "tel_5.telsomnum", "tel_5.telsit", "tel_5.telclas", "tel_5.telsaldev", "tel_5.telrespcod", "tel_5.teldatten", "tel_5.telqtdten", "tel_5.telsta", "tel_5.teltelhig", "tel_5.teldddhig", "tel_5.telid", "tel_5.telopecod", "tel_5.teldatpro", "tel_5.telpenexp", "tel_5.telsitant", "tel_5.telori"],
- "Index Cond": "(tel_5.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "(tel_5.telclas = 6)",
- "Rows Removed by Filter": 4,
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 23",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["string_agg(((tel_6.teldddtel)::text || (tel_6.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_6",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["tel_6.telseq", "tel_6.tiptelcod", "tel_6.teldddtel", "tel_6.teltel", "tel_6.telramtel", "tel_6.teldatinc", "tel_6.teldatatu", "tel_6.telobs", "tel_6.telborent", "tel_6.telusuinc", "tel_6.telusuatu", "tel_6.pescod", "tel_6.telsomnum", "tel_6.telsit", "tel_6.telclas", "tel_6.telsaldev", "tel_6.telrespcod", "tel_6.teldatten", "tel_6.telqtdten", "tel_6.telsta", "tel_6.teltelhig", "tel_6.teldddhig", "tel_6.telid", "tel_6.telopecod", "tel_6.teldatpro", "tel_6.telpenexp", "tel_6.telsitant", "tel_6.telori"],
- "Index Cond": "(tel_6.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel_6.telsit <> ALL ('{2,5}'::integer[])) AND (tel_6.telclas = 7))",
- "Rows Removed by Filter": 3,
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 24",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["string_agg(((tel_7.teldddtel)::text || (tel_7.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_7",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["tel_7.telseq", "tel_7.tiptelcod", "tel_7.teldddtel", "tel_7.teltel", "tel_7.telramtel", "tel_7.teldatinc", "tel_7.teldatatu", "tel_7.telobs", "tel_7.telborent", "tel_7.telusuinc", "tel_7.telusuatu", "tel_7.pescod", "tel_7.telsomnum", "tel_7.telsit", "tel_7.telclas", "tel_7.telsaldev", "tel_7.telrespcod", "tel_7.teldatten", "tel_7.telqtdten", "tel_7.telsta", "tel_7.teltelhig", "tel_7.teldddhig", "tel_7.telid", "tel_7.telopecod", "tel_7.teldatpro", "tel_7.telpenexp", "tel_7.telsitant", "tel_7.telori"],
- "Index Cond": "(tel_7.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel_7.telsit <> ALL ('{2,5}'::integer[])) AND (tel_7.telclas = 1))",
- "Rows Removed by Filter": 4,
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 25",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["string_agg(((tel_8.teldddtel)::text || (tel_8.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_8",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["tel_8.telseq", "tel_8.tiptelcod", "tel_8.teldddtel", "tel_8.teltel", "tel_8.telramtel", "tel_8.teldatinc", "tel_8.teldatatu", "tel_8.telobs", "tel_8.telborent", "tel_8.telusuinc", "tel_8.telusuatu", "tel_8.pescod", "tel_8.telsomnum", "tel_8.telsit", "tel_8.telclas", "tel_8.telsaldev", "tel_8.telrespcod", "tel_8.teldatten", "tel_8.telqtdten", "tel_8.telsta", "tel_8.teltelhig", "tel_8.teldddhig", "tel_8.telid", "tel_8.telopecod", "tel_8.teldatpro", "tel_8.telpenexp", "tel_8.telsitant", "tel_8.telori"],
- "Index Cond": "(tel_8.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel_8.telsit <> ALL ('{2,5}'::integer[])) AND (tel_8.telclas = 2))",
- "Rows Removed by Filter": 4,
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 26",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["string_agg(((tel_9.teldddtel)::text || (tel_9.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_9",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["tel_9.telseq", "tel_9.tiptelcod", "tel_9.teldddtel", "tel_9.teltel", "tel_9.telramtel", "tel_9.teldatinc", "tel_9.teldatatu", "tel_9.telobs", "tel_9.telborent", "tel_9.telusuinc", "tel_9.telusuatu", "tel_9.pescod", "tel_9.telsomnum", "tel_9.telsit", "tel_9.telclas", "tel_9.telsaldev", "tel_9.telrespcod", "tel_9.teldatten", "tel_9.telqtdten", "tel_9.telsta", "tel_9.teltelhig", "tel_9.teldddhig", "tel_9.telid", "tel_9.telopecod", "tel_9.teldatpro", "tel_9.telpenexp", "tel_9.telsitant", "tel_9.telori"],
- "Index Cond": "(tel_9.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel_9.telsit <> ALL ('{2,5}'::integer[])) AND (tel_9.telclas = 3))",
- "Rows Removed by Filter": 4,
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 27",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["string_agg(((tel_10.teldddtel)::text || (tel_10.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_10",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["tel_10.telseq", "tel_10.tiptelcod", "tel_10.teldddtel", "tel_10.teltel", "tel_10.telramtel", "tel_10.teldatinc", "tel_10.teldatatu", "tel_10.telobs", "tel_10.telborent", "tel_10.telusuinc", "tel_10.telusuatu", "tel_10.pescod", "tel_10.telsomnum", "tel_10.telsit", "tel_10.telclas", "tel_10.telsaldev", "tel_10.telrespcod", "tel_10.teldatten", "tel_10.telqtdten", "tel_10.telsta", "tel_10.teltelhig", "tel_10.teldddhig", "tel_10.telid", "tel_10.telopecod", "tel_10.teldatpro", "tel_10.telpenexp", "tel_10.telsitant", "tel_10.telori"],
- "Index Cond": "(tel_10.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel_10.telsit <> ALL ('{2,5}'::integer[])) AND (tel_10.telclas = 4))",
- "Rows Removed by Filter": 4,
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 28",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["string_agg(((tel_11.teldddtel)::text || (tel_11.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_11",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["tel_11.telseq", "tel_11.tiptelcod", "tel_11.teldddtel", "tel_11.teltel", "tel_11.telramtel", "tel_11.teldatinc", "tel_11.teldatatu", "tel_11.telobs", "tel_11.telborent", "tel_11.telusuinc", "tel_11.telusuatu", "tel_11.pescod", "tel_11.telsomnum", "tel_11.telsit", "tel_11.telclas", "tel_11.telsaldev", "tel_11.telrespcod", "tel_11.teldatten", "tel_11.telqtdten", "tel_11.telsta", "tel_11.teltelhig", "tel_11.teldddhig", "tel_11.telid", "tel_11.telopecod", "tel_11.teldatpro", "tel_11.telpenexp", "tel_11.telsitant", "tel_11.telori"],
- "Index Cond": "(tel_11.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel_11.telsit <> ALL ('{2,5}'::integer[])) AND (tel_11.telclas = 5))",
- "Rows Removed by Filter": 4,
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 29",
- "Parallel Aware": false,
- "Startup Cost": 9.56,
- "Total Cost": 9.57,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["string_agg(((tel_12.teldddtel)::text || (tel_12.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_12",
- "Startup Cost": 0.56,
- "Total Cost": 9.56,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["tel_12.telseq", "tel_12.tiptelcod", "tel_12.teldddtel", "tel_12.teltel", "tel_12.telramtel", "tel_12.teldatinc", "tel_12.teldatatu", "tel_12.telobs", "tel_12.telborent", "tel_12.telusuinc", "tel_12.telusuatu", "tel_12.pescod", "tel_12.telsomnum", "tel_12.telsit", "tel_12.telclas", "tel_12.telsaldev", "tel_12.telrespcod", "tel_12.teldatten", "tel_12.telqtdten", "tel_12.telsta", "tel_12.teltelhig", "tel_12.teldddhig", "tel_12.telid", "tel_12.telopecod", "tel_12.teldatpro", "tel_12.telpenexp", "tel_12.telsitant", "tel_12.telori"],
- "Index Cond": "(tel_12.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "(tel_12.telclas = 6)",
- "Rows Removed by Filter": 4,
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 30",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["string_agg(((tel_13.teldddtel)::text || (tel_13.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_13",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["tel_13.telseq", "tel_13.tiptelcod", "tel_13.teldddtel", "tel_13.teltel", "tel_13.telramtel", "tel_13.teldatinc", "tel_13.teldatatu", "tel_13.telobs", "tel_13.telborent", "tel_13.telusuinc", "tel_13.telusuatu", "tel_13.pescod", "tel_13.telsomnum", "tel_13.telsit", "tel_13.telclas", "tel_13.telsaldev", "tel_13.telrespcod", "tel_13.teldatten", "tel_13.telqtdten", "tel_13.telsta", "tel_13.teltelhig", "tel_13.teldddhig", "tel_13.telid", "tel_13.telopecod", "tel_13.teldatpro", "tel_13.telpenexp", "tel_13.telsitant", "tel_13.telori"],
- "Index Cond": "(tel_13.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel_13.telsit <> ALL ('{2,5}'::integer[])) AND (tel_13.telclas = 7))",
- "Rows Removed by Filter": 3,
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Limit",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 31",
- "Parallel Aware": false,
- "Startup Cost": 1.55,
- "Total Cost": 6.03,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.005,
- "Actual Total Time": 0.005,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["(((t_4.teldddtel)::text || (t_4.teltel)::text))"],
- "Shared Hit Blocks": 2256673,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1.55,
- "Total Cost": 6.03,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["((t_4.teldddtel)::text || (t_4.teltel)::text)"],
- "Inner Unique": false,
- "Shared Hit Blocks": 2256673,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1.12,
- "Total Cost": 4.47,
- "Plan Rows": 1,
- "Plan Width": 23,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["t_4.teldddtel", "t_4.teltel", "p_5.devcod", "p_5.carcod"],
- "Inner Unique": false,
- "Shared Hit Blocks": 2085976,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "pessoa_iu0002",
- "Relation Name": "pessoa",
- "Schema": "public",
- "Alias": "p_5",
- "Startup Cost": 0.56,
- "Total Cost": 1.68,
- "Plan Rows": 1,
- "Plan Width": 20,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["p_5.carcod", "p_5.devcod", "p_5.tippescod", "p_5.pescod"],
- "Index Cond": "((p_5.carcod = a_1.carcod) AND (p_5.devcod = a_1.devcod))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 74040,
- "Shared Hit Blocks": 1090047,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "t_4",
- "Startup Cost": 0.56,
- "Total Cost": 2.78,
- "Plan Rows": 1,
- "Plan Width": 19,
- "Actual Startup Time": 0.001,
- "Actual Total Time": 0.001,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["t_4.telseq", "t_4.tiptelcod", "t_4.teldddtel", "t_4.teltel", "t_4.telramtel", "t_4.teldatinc", "t_4.teldatatu", "t_4.telobs", "t_4.telborent", "t_4.telusuinc", "t_4.telusuatu", "t_4.pescod", "t_4.telsomnum", "t_4.telsit", "t_4.telclas", "t_4.telsaldev", "t_4.telrespcod", "t_4.teldatten", "t_4.telqtdten", "t_4.telsta", "t_4.teltelhig", "t_4.teldddhig", "t_4.telid", "t_4.telopecod", "t_4.teldatpro", "t_4.telpenexp", "t_4.telsitant", "t_4.telori"],
- "Index Cond": "((t_4.pescod = p_5.pescod) AND (t_4.tiptelcod = 17))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 995929,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "devedor_iu0021",
- "Relation Name": "devedor",
- "Schema": "public",
- "Alias": "d_5",
- "Startup Cost": 0.43,
- "Total Cost": 1.55,
- "Plan Rows": 1,
- "Plan Width": 12,
- "Actual Startup Time": 0.001,
- "Actual Total Time": 0.001,
- "Actual Rows": 1,
- "Actual Loops": 42422,
- "Output": ["d_5.devcod", "d_5.carcod"],
- "Index Cond": "((d_5.devcod = a_1.devcod) AND (d_5.carcod = a_1.carcod))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 37905,
- "Shared Hit Blocks": 170697,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 32",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["string_agg(((tel_14.teldddtel)::text || (tel_14.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_14",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["tel_14.telseq", "tel_14.tiptelcod", "tel_14.teldddtel", "tel_14.teltel", "tel_14.telramtel", "tel_14.teldatinc", "tel_14.teldatatu", "tel_14.telobs", "tel_14.telborent", "tel_14.telusuinc", "tel_14.telusuatu", "tel_14.pescod", "tel_14.telsomnum", "tel_14.telsit", "tel_14.telclas", "tel_14.telsaldev", "tel_14.telrespcod", "tel_14.teldatten", "tel_14.telqtdten", "tel_14.telsta", "tel_14.teltelhig", "tel_14.teldddhig", "tel_14.telid", "tel_14.telopecod", "tel_14.teldatpro", "tel_14.telpenexp", "tel_14.telsitant", "tel_14.telori"],
- "Index Cond": "(tel_14.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel_14.telsit <> ALL ('{2,5}'::integer[])) AND (tel_14.telclas = 1))",
- "Rows Removed by Filter": 4,
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 33",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["string_agg(((tel_15.teldddtel)::text || (tel_15.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_15",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["tel_15.telseq", "tel_15.tiptelcod", "tel_15.teldddtel", "tel_15.teltel", "tel_15.telramtel", "tel_15.teldatinc", "tel_15.teldatatu", "tel_15.telobs", "tel_15.telborent", "tel_15.telusuinc", "tel_15.telusuatu", "tel_15.pescod", "tel_15.telsomnum", "tel_15.telsit", "tel_15.telclas", "tel_15.telsaldev", "tel_15.telrespcod", "tel_15.teldatten", "tel_15.telqtdten", "tel_15.telsta", "tel_15.teltelhig", "tel_15.teldddhig", "tel_15.telid", "tel_15.telopecod", "tel_15.teldatpro", "tel_15.telpenexp", "tel_15.telsitant", "tel_15.telori"],
- "Index Cond": "(tel_15.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel_15.telsit <> ALL ('{2,5}'::integer[])) AND (tel_15.telclas = 2))",
- "Rows Removed by Filter": 4,
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 34",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["string_agg(((tel_16.teldddtel)::text || (tel_16.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_16",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["tel_16.telseq", "tel_16.tiptelcod", "tel_16.teldddtel", "tel_16.teltel", "tel_16.telramtel", "tel_16.teldatinc", "tel_16.teldatatu", "tel_16.telobs", "tel_16.telborent", "tel_16.telusuinc", "tel_16.telusuatu", "tel_16.pescod", "tel_16.telsomnum", "tel_16.telsit", "tel_16.telclas", "tel_16.telsaldev", "tel_16.telrespcod", "tel_16.teldatten", "tel_16.telqtdten", "tel_16.telsta", "tel_16.teltelhig", "tel_16.teldddhig", "tel_16.telid", "tel_16.telopecod", "tel_16.teldatpro", "tel_16.telpenexp", "tel_16.telsitant", "tel_16.telori"],
- "Index Cond": "(tel_16.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel_16.telsit <> ALL ('{2,5}'::integer[])) AND (tel_16.telclas = 3))",
- "Rows Removed by Filter": 4,
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 35",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["string_agg(((tel_17.teldddtel)::text || (tel_17.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_17",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["tel_17.telseq", "tel_17.tiptelcod", "tel_17.teldddtel", "tel_17.teltel", "tel_17.telramtel", "tel_17.teldatinc", "tel_17.teldatatu", "tel_17.telobs", "tel_17.telborent", "tel_17.telusuinc", "tel_17.telusuatu", "tel_17.pescod", "tel_17.telsomnum", "tel_17.telsit", "tel_17.telclas", "tel_17.telsaldev", "tel_17.telrespcod", "tel_17.teldatten", "tel_17.telqtdten", "tel_17.telsta", "tel_17.teltelhig", "tel_17.teldddhig", "tel_17.telid", "tel_17.telopecod", "tel_17.teldatpro", "tel_17.telpenexp", "tel_17.telsitant", "tel_17.telori"],
- "Index Cond": "(tel_17.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel_17.telsit <> ALL ('{2,5}'::integer[])) AND (tel_17.telclas = 4))",
- "Rows Removed by Filter": 4,
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 36",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["string_agg(((tel_18.teldddtel)::text || (tel_18.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_18",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["tel_18.telseq", "tel_18.tiptelcod", "tel_18.teldddtel", "tel_18.teltel", "tel_18.telramtel", "tel_18.teldatinc", "tel_18.teldatatu", "tel_18.telobs", "tel_18.telborent", "tel_18.telusuinc", "tel_18.telusuatu", "tel_18.pescod", "tel_18.telsomnum", "tel_18.telsit", "tel_18.telclas", "tel_18.telsaldev", "tel_18.telrespcod", "tel_18.teldatten", "tel_18.telqtdten", "tel_18.telsta", "tel_18.teltelhig", "tel_18.teldddhig", "tel_18.telid", "tel_18.telopecod", "tel_18.teldatpro", "tel_18.telpenexp", "tel_18.telsitant", "tel_18.telori"],
- "Index Cond": "(tel_18.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel_18.telsit <> ALL ('{2,5}'::integer[])) AND (tel_18.telclas = 5))",
- "Rows Removed by Filter": 4,
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 37",
- "Parallel Aware": false,
- "Startup Cost": 9.56,
- "Total Cost": 9.57,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["string_agg(((tel_19.teldddtel)::text || (tel_19.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_19",
- "Startup Cost": 0.56,
- "Total Cost": 9.56,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["tel_19.telseq", "tel_19.tiptelcod", "tel_19.teldddtel", "tel_19.teltel", "tel_19.telramtel", "tel_19.teldatinc", "tel_19.teldatatu", "tel_19.telobs", "tel_19.telborent", "tel_19.telusuinc", "tel_19.telusuatu", "tel_19.pescod", "tel_19.telsomnum", "tel_19.telsit", "tel_19.telclas", "tel_19.telsaldev", "tel_19.telrespcod", "tel_19.teldatten", "tel_19.telqtdten", "tel_19.telsta", "tel_19.teltelhig", "tel_19.teldddhig", "tel_19.telid", "tel_19.telopecod", "tel_19.teldatpro", "tel_19.telpenexp", "tel_19.telsitant", "tel_19.telori"],
- "Index Cond": "(tel_19.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "(tel_19.telclas = 6)",
- "Rows Removed by Filter": 4,
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Simple",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 38",
- "Parallel Aware": false,
- "Startup Cost": 9.59,
- "Total Cost": 9.60,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["string_agg(((tel_20.teldddtel)::text || (tel_20.teltel)::text), ', '::text)"],
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "tel_20",
- "Startup Cost": 0.56,
- "Total Cost": 9.59,
- "Plan Rows": 1,
- "Plan Width": 11,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["tel_20.telseq", "tel_20.tiptelcod", "tel_20.teldddtel", "tel_20.teltel", "tel_20.telramtel", "tel_20.teldatinc", "tel_20.teldatatu", "tel_20.telobs", "tel_20.telborent", "tel_20.telusuinc", "tel_20.telusuatu", "tel_20.pescod", "tel_20.telsomnum", "tel_20.telsit", "tel_20.telclas", "tel_20.telsaldev", "tel_20.telrespcod", "tel_20.teldatten", "tel_20.telqtdten", "tel_20.telsta", "tel_20.teltelhig", "tel_20.teldddhig", "tel_20.telid", "tel_20.telopecod", "tel_20.teldatpro", "tel_20.telpenexp", "tel_20.telsitant", "tel_20.telori"],
- "Index Cond": "(tel_20.pescod = p.pescod)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((tel_20.telsit <> ALL ('{2,5}'::integer[])) AND (tel_20.telclas = 7))",
- "Rows Removed by Filter": 3,
- "Shared Hit Blocks": 1599615,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Limit",
- "Parent Relationship": "SubPlan",
- "Subplan Name": "SubPlan 39",
- "Parallel Aware": false,
- "Startup Cost": 1.55,
- "Total Cost": 6.03,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.005,
- "Actual Total Time": 0.005,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["(((t_5.teldddtel)::text || (t_5.teltel)::text))"],
- "Shared Hit Blocks": 2256673,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1.55,
- "Total Cost": 6.03,
- "Plan Rows": 1,
- "Plan Width": 32,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["((t_5.teldddtel)::text || (t_5.teltel)::text)"],
- "Inner Unique": false,
- "Shared Hit Blocks": 2256673,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 1.12,
- "Total Cost": 4.47,
- "Plan Rows": 1,
- "Plan Width": 23,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["t_5.teldddtel", "t_5.teltel", "p_6.devcod", "p_6.carcod"],
- "Inner Unique": false,
- "Shared Hit Blocks": 2085976,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000,
- "Plans": [
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "pessoa_iu0002",
- "Relation Name": "pessoa",
- "Schema": "public",
- "Alias": "p_6",
- "Startup Cost": 0.56,
- "Total Cost": 1.68,
- "Plan Rows": 1,
- "Plan Width": 20,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 1,
- "Actual Loops": 238047,
- "Output": ["p_6.carcod", "p_6.devcod", "p_6.tippescod", "p_6.pescod"],
- "Index Cond": "((p_6.carcod = a_1.carcod) AND (p_6.devcod = a_1.devcod))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 74040,
- "Shared Hit Blocks": 1090047,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "telefone_iu0005",
- "Relation Name": "telefone",
- "Schema": "public",
- "Alias": "t_5",
- "Startup Cost": 0.56,
- "Total Cost": 2.78,
- "Plan Rows": 1,
- "Plan Width": 19,
- "Actual Startup Time": 0.001,
- "Actual Total Time": 0.001,
- "Actual Rows": 0,
- "Actual Loops": 238047,
- "Output": ["t_5.telseq", "t_5.tiptelcod", "t_5.teldddtel", "t_5.teltel", "t_5.telramtel", "t_5.teldatinc", "t_5.teldatatu", "t_5.telobs", "t_5.telborent", "t_5.telusuinc", "t_5.telusuatu", "t_5.pescod", "t_5.telsomnum", "t_5.telsit", "t_5.telclas", "t_5.telsaldev", "t_5.telrespcod", "t_5.teldatten", "t_5.telqtdten", "t_5.telsta", "t_5.teltelhig", "t_5.teldddhig", "t_5.telid", "t_5.telopecod", "t_5.teldatpro", "t_5.telpenexp", "t_5.telsitant", "t_5.telori"],
- "Index Cond": "((t_5.pescod = p_6.pescod) AND (t_5.tiptelcod = 17))",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 995929,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- },
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "devedor_iu0021",
- "Relation Name": "devedor",
- "Schema": "public",
- "Alias": "d_6",
- "Startup Cost": 0.43,
- "Total Cost": 1.55,
- "Plan Rows": 1,
- "Plan Width": 12,
- "Actual Startup Time": 0.001,
- "Actual Total Time": 0.001,
- "Actual Rows": 1,
- "Actual Loops": 42422,
- "Output": ["d_6.devcod", "d_6.carcod"],
- "Index Cond": "((d_6.devcod = a_1.devcod) AND (d_6.carcod = a_1.carcod))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 37905,
- "Shared Hit Blocks": 170697,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "I/O Read Time": 0.000,
- "I/O Write Time": 0.000
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- },
- "Planning Time": 30.062,
- "Triggers": [
- ],
- "Execution Time": 138545.866
- }
- ]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement