explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wpjF

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=5,641,282.77..5,641,282.83 rows=24 width=206) (actual rows= loops=)

  • Sort Key: ev.value, ev.name, f.account_id, (CASE ad_column_identifier(''::character varying, (''::character varying), 'en_US'::character varying) WHEN '**'::text THEN ''::character varying ELSE ad_colu
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5,640,880.25..5,641,282.22 rows=24 width=206) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=5,640,879.84..5,640,880.66 rows=47 width=52) (actual rows= loops=)

  • Filter: ((sum(CASE WHEN ((f.dateacct < '2018-10-01 00:00:00'::timestamp without time zone) OR ((f.dateacct = '2018-10-01 00:00:00'::timestamp without time zone) AND ((f.factaccttype)::text
4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fact_acct f (cost=1,466,435.80..5,116,489.37 rows=7,232,972 width=52) (actual rows= loops=)

  • Recheck Cond: ((dateacct < '2018-11-01 00:00:00'::timestamp without time zone) AND ((ad_org_id)::text = ANY ('{F582CF8DBD3742368C199A65A237B8F4,F4C9677DCC114845A3FF587D466D9E7D,F4937BB6315B47C1ACD6E8E8DC0A6515,F3B23FC042CC4F29868786E3B7537C7B,E1B3C6BCD75341C7BD474AFFEB442302,E1B070E26BDE4FC7A2073B67B8B92FFE,D9494166296D46C991205D10509093B8,CCA773813C5E4265BC247324ED76C844,C1405234A8BA4EDE911811CEE72C787F,BAB56EA4A5A942EEAF0BA9CAFF34F74D,B36E9058EE514C709B537A354C91C3BD,AD8A3C99638D4EE49170F0EB5BCEB05F,8C2067090AC6494289E7683EA3C68A06,816AEB46E1594978AC707D5372F5B25A,7DAB23B2A5064CBFAB016596E843E038,763A2587F23B4709A3F41FA0662F6BD4,6EAACA1F8ED8495DB8D4C2F872728B92,680FA1C76ABD478DA0F084218F586180,6683194C80DD411D9BADCA606FA55F88,6444775637C448538259BCB0BE09CC96,5BECB36DD8C7496B9CEB62F8C3564CA7,560EC6383D64405A92D388FD68A59878,4914FFF3E4E242C39E6E3B685BE5A1FD,3FD0BEE64018490B823B15FE495DE82D,39C13F6DDCCB4092A05357C3A8CC1436,3433EC959DC149FC87926853661EA9EA,31BA876EA1214AD9AE685FE01375881D,2B2174C3D9864C189412FB8D41372B3B,15E38FD0F10C4102BCC80D1132B4EC06,14ACCD687FA8480F9999ED50B2BD9E65,142C67F408344EFCB29E4E797F97E3FC,142A633EDBFB4FDC9E515228D37AEAC5,0BB733D8961B4D329EBFC585B8A1E19A,0B70A6C91ABE454485D1BA97FB9BA93A,004EC793539645E9BFB015514F96E650}'::text[])) AND ((ad_org_id)::text = ANY ('{31BA876EA1214AD9AE685FE01375881D,9E397CF2F4994083B3F737B1A54C25C9,1FB16D3E817A4CF490E5AC7C23CA283B,B36E9058EE514C709B537A354C91C3BD,8A65213769B941B2ADF9DE2BBFC12C8F,3433EC959DC149FC87926853661EA9EA,3FD0BEE64018490B823B15FE495DE82D,93D0F1FBB7E646D68F3ACB168C88EC37,BCD3C61AD3CC4600A42723D35F536518,7FBBA9AAED9B4A7799322D8D871432F8,6EAACA1F8ED8495DB8D4C2F872728B92,8C2067090AC6494289E7683EA3C68A06,816AEB46E1594978AC707D5372F5B25A,2B2174C3D9864C189412FB8D41372B3B,0BB733D8961B4D329EBFC585B8A1E19A,4914FFF3E4E242C39E6E3B685BE5A1FD,142A633EDBFB4FDC9E515228D37AEAC5,142C67F408344EFCB29E4E797F97E3FC,E1B070E26BDE4FC7A2073B67B8B92FFE,680FA1C76ABD478DA0F084218F586180,40150EBEF0844C789E106100B7D3FA52,F582CF8DBD3742368C199A65A237B8F4,0FEA6B0CE29E41C0A266E62B1BB318BD,6444775637C448538259BCB0BE09CC96,D942ABDA02E742B3ADAA8CE26F025C3C,AE540A9683B34231AE3531785A456ACE,D9494166296D46C991205D10509093B8,4E4BE778176042268AE79C80EA90022C,6802ECD342934670A6D88F7C55185D8D,0C5FA1C3C5294EA2AD11187C0CBA05CE,30716C8BDA154DE78EFC2C5DCB7D5CEB,0,A9C29D7A356246E4AB6219B71D052CE1,6683194C80DD411D9BADCA606FA55F88,7DAB23B2A5064CBFAB016596E843E038,BAB56EA4A5A942EEAF0BA9CAFF34F74D,A565E147F9BE462C876B41AA00EAE7CA,1C495D8300344C89B9DC927CEE617275,59286CE7B87A40EA95F18A2FC52C72BC,C6F8340C82EC4DC5B747B5CAC9319C3D,A0850CFB14B84192AC69D6A2659E732D,004EC793539645E9BFB015514F96E650,BB9E8665FDDC47BB80868249C21AFEE0,015463B9728E4C2A8D551EC42D3A81FB,5BECB36DD8C7496B9CEB62F8C3564CA7,DF60E5326C9348768D6735A1A886E1A0,C6F497D981C943D09A367AA9426496C6,560EC6383D64405A92D388FD68A59878,F3B23FC042CC4F29868786E3B7537C7B,C1405234A8BA4EDE911811CEE72C787F,042F191270F54DA38002DDC9633E06D0,91A3772EEDC24834985FF56CB0E19655,0B70A6C91ABE454485D1BA97FB9BA93A,DA4D50C5862C42738AC3F9A1631FF4FD,9F74C888DAAA4DD6BFA853318C6471CC,763A2587F23B4709A3F41FA0662F6BD4,439CCDC7A9154F819B08992D783C3D27,CDDCA9B5E08C455F9EBC5BD2F203FA3B,1FA41EC0D73A460EAA8949793B4167CE,3CFBC50EB81747CAB8C1F0BFD30C92E3,BA960085040B4F4A98A692FC0A3B48C2,F4937BB6315B47C1ACD6E8E8DC0A6515,9478FB272E1B48D2844EF338DCCBA925,17EDF8ED55BF47D69F1334FD8BDAAE0D,440AEC4E4D2E486ABA18AC115388AAC8,CCA773813C5E4265BC247324ED76C844,15E38FD0F10C4102BCC80D1132B4EC06,1025E6E1F2334EB19BDF25F6694A06B5,C468873E50FA48FE9297DBB4B3A2DD42,AD8A3C99638D4EE49170F0EB5BCEB05F,F4C9677DCC114845A3FF587D466D9E7D,14ACCD687FA8480F9999ED50B2BD9E65,559AF86571ED49C4A4B322D2BF72819C,39C13F6DDCCB4092A05357C3A8CC1436,E1B3C6BCD75341C7BD474AFFEB442302,D2A08659AF20457A81F4E6CBA4BF9D2F}'::text[])) AND ((c_acctschema_id)::text = '0DCC39FCD8DC47159ED82C3F74ECA5CD'::text))
  • Filter: (((ad_client_id)::text = ANY ('{0,E8CB1F6B0B244CA1A8B461979EA1D539}'::text[])) AND (isactive = 'Y'::bpchar))
5. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=1,466,435.80..1,466,435.80 rows=7,239,487 width=0) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on fact_acct_dateacct (cost=0.00..452,238.43 rows=15,621,583 width=0) (actual rows= loops=)

  • Index Cond: (dateacct < '2018-11-01 00:00:00'::timestamp without time zone)
7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on fact_acct_account (cost=0.00..1,010,580.63 rows=10,265,742 width=0) (actual rows= loops=)

  • Index Cond: (((ad_org_id)::text = ANY ('{F582CF8DBD3742368C199A65A237B8F4,F4C9677DCC114845A3FF587D466D9E7D,F4937BB6315B47C1ACD6E8E8DC0A6515,F3B23FC042CC4F29868786E3B7537C7B,E1B3C6BCD75341C7BD474AFFEB442302,E1B070E26BDE4FC7A2073B67B8B92FFE,D9494166296D46C991205D10509093B8,CCA773813C5E4265BC247324ED76C844,C1405234A8BA4EDE911811CEE72C787F,BAB56EA4A5A942EEAF0BA9CAFF34F74D,B36E9058EE514C709B537A354C91C3BD,AD8A3C99638D4EE49170F0EB5BCEB05F,8C2067090AC6494289E7683EA3C68A06,816AEB46E1594978AC707D5372F5B25A,7DAB23B2A5064CBFAB016596E843E038,763A2587F23B4709A3F41FA0662F6BD4,6EAACA1F8ED8495DB8D4C2F872728B92,680FA1C76ABD478DA0F084218F586180,6683194C80DD411D9BADCA606FA55F88,6444775637C448538259BCB0BE09CC96,5BECB36DD8C7496B9CEB62F8C3564CA7,560EC6383D64405A92D388FD68A59878,4914FFF3E4E242C39E6E3B685BE5A1FD,3FD0BEE64018490B823B15FE495DE82D,39C13F6DDCCB4092A05357C3A8CC1436,3433EC959DC149FC87926853661EA9EA,31BA876EA1214AD9AE685FE01375881D,2B2174C3D9864C189412FB8D41372B3B,15E38FD0F10C4102BCC80D1132B4EC06,14ACCD687FA8480F9999ED50B2BD9E65,142C67F408344EFCB29E4E797F97E3FC,142A633EDBFB4FDC9E515228D37AEAC5,0BB733D8961B4D329EBFC585B8A1E19A,0B70A6C91ABE454485D1BA97FB9BA93A,004EC793539645E9BFB015514F96E650}'::text[])) AND ((ad_org_id)::text = ANY ('{31BA876EA1214AD9AE685FE01375881D,9E397CF2F4994083B3F737B1A54C25C9,1FB16D3E817A4CF490E5AC7C23CA283B,B36E9058EE514C709B537A354C91C3BD,8A65213769B941B2ADF9DE2BBFC12C8F,3433EC959DC149FC87926853661EA9EA,3FD0BEE64018490B823B15FE495DE82D,93D0F1FBB7E646D68F3ACB168C88EC37,BCD3C61AD3CC4600A42723D35F536518,7FBBA9AAED9B4A7799322D8D871432F8,6EAACA1F8ED8495DB8D4C2F872728B92,8C2067090AC6494289E7683EA3C68A06,816AEB46E1594978AC707D5372F5B25A,2B2174C3D9864C189412FB8D41372B3B,0BB733D8961B4D329EBFC585B8A1E19A,4914FFF3E4E242C39E6E3B685BE5A1FD,142A633EDBFB4FDC9E515228D37AEAC5,142C67F408344EFCB29E4E797F97E3FC,E1B070E26BDE4FC7A2073B67B8B92FFE,680FA1C76ABD478DA0F084218F586180,40150EBEF0844C789E106100B7D3FA52,F582CF8DBD3742368C199A65A237B8F4,0FEA6B0CE29E41C0A266E62B1BB318BD,6444775637C448538259BCB0BE09CC96,D942ABDA02E742B3ADAA8CE26F025C3C,AE540A9683B34231AE3531785A456ACE,D9494166296D46C991205D10509093B8,4E4BE778176042268AE79C80EA90022C,6802ECD342934670A6D88F7C55185D8D,0C5FA1C3C5294EA2AD11187C0CBA05CE,30716C8BDA154DE78EFC2C5DCB7D5CEB,0,A9C29D7A356246E4AB6219B71D052CE1,6683194C80DD411D9BADCA606FA55F88,7DAB23B2A5064CBFAB016596E843E038,BAB56EA4A5A942EEAF0BA9CAFF34F74D,A565E147F9BE462C876B41AA00EAE7CA,1C495D8300344C89B9DC927CEE617275,59286CE7B87A40EA95F18A2FC52C72BC,C6F8340C82EC4DC5B747B5CAC9319C3D,A0850CFB14B84192AC69D6A2659E732D,004EC793539645E9BFB015514F96E650,BB9E8665FDDC47BB80868249C21AFEE0,015463B9728E4C2A8D551EC42D3A81FB,5BECB36DD8C7496B9CEB62F8C3564CA7,DF60E5326C9348768D6735A1A886E1A0,C6F497D981C943D09A367AA9426496C6,560EC6383D64405A92D388FD68A59878,F3B23FC042CC4F29868786E3B7537C7B,C1405234A8BA4EDE911811CEE72C787F,042F191270F54DA38002DDC9633E06D0,91A3772EEDC24834985FF56CB0E19655,0B70A6C91ABE454485D1BA97FB9BA93A,DA4D50C5862C42738AC3F9A1631FF4FD,9F74C888DAAA4DD6BFA853318C6471CC,763A2587F23B4709A3F41FA0662F6BD4,439CCDC7A9154F819B08992D783C3D27,CDDCA9B5E08C455F9EBC5BD2F203FA3B,1FA41EC0D73A460EAA8949793B4167CE,3CFBC50EB81747CAB8C1F0BFD30C92E3,BA960085040B4F4A98A692FC0A3B48C2,F4937BB6315B47C1ACD6E8E8DC0A6515,9478FB272E1B48D2844EF338DCCBA925,17EDF8ED55BF47D69F1334FD8BDAAE0D,440AEC4E4D2E486ABA18AC115388AAC8,CCA773813C5E4265BC247324ED76C844,15E38FD0F10C4102BCC80D1132B4EC06,1025E6E1F2334EB19BDF25F6694A06B5,C468873E50FA48FE9297DBB4B3A2DD42,AD8A3C99638D4EE49170F0EB5BCEB05F,F4C9677DCC114845A3FF587D466D9E7D,14ACCD687FA8480F9999ED50B2BD9E65,559AF86571ED49C4A4B322D2BF72819C,39C13F6DDCCB4092A05357C3A8CC1436,E1B3C6BCD75341C7BD474AFFEB442302,D2A08659AF20457A81F4E6CBA4BF9D2F}'::text[])) AND ((c_acctschema_id)::text = '0DCC39FCD8DC47159ED82C3F74ECA5CD'::text))
8. 0.000 0.000 ↓ 0.0

Index Scan using c_elementvalue_key on c_elementvalue ev (cost=0.41..8.26 rows=1 width=78) (actual rows= loops=)

  • Index Cond: ((c_elementvalue_id)::text = (f.account_id)::text)
  • Filter: (((value)::text <= 'T10002'::text) AND ((elementlevel)::text = 'S'::text))