explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bS4l

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

Index Scan using fund_group_ind1 on fund_group fg_1 (cost=0.15..5.70 rows=3 width=122) (actual rows= loops=)

  • Index Cond: (fund_group_id = fnd_1.fund_group_id)
2. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 3 (cost=7,823.47..91,154.23 rows=14,044 width=371) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Gather (cost=7,823.47..90,978.68 rows=14,044 width=343) (actual rows= loops=)

  • Workers Planned: 2
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=6,823.47..88,574.28 rows=5,852 width=343) (actual rows= loops=)

  • Hash Cond: (s_2.anum = tb_2.anum)
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=6,804.60..88,481.39 rows=5,852 width=262) (actual rows= loops=)

  • Hash Cond: (a_2.trader_id = tr.trader_id)
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=6,803.53..88,399.86 rows=5,852 width=258) (actual rows= loops=)

  • Hash Cond: (s_2.fund_id = fnd_2.fund_id)
7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6,784.95..88,300.82 rows=5,852 width=137) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash Join (cost=6,784.53..68,049.87 rows=13,030 width=52) (actual rows= loops=)

  • Hash Cond: (s_2.akey = a_2.ftb_id)
9. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on entries s_2 (cost=6,765.98..67,970.77 rows=22,948 width=41) (actual rows= loops=)

  • Recheck Cond: ((fund_id = ANY ('{45,48,49,15,26,43,27,42,50,52,1,6,44,41,47,30,16,33,23,10,14,24,21,32,18,51,31,3,4,35,5,20,22,34,2,19,11,40,37,17,39,38,12,7,29,36,8,9,13,25,28}'::integer[])) AND (value_dt >= to_date('20190102'::text, 'yyyymmdd'::text)) AND (value_dt <= to_date('20200102'::text, 'yyyymmdd'::text)))
  • Filter: (anum = ANY ('{13505,22004,22005,22505,22506,23006,23018,23019,23020,23021,23022,23030,23031,31003,33002,40001,40011,40012,40013,40021,40022,40023,40024,40025,40031,40033,40034,40040,40041,40042,40043,40044,40046,40047,40049,40050,40051,40055,40061,40062,40063,40071,40072,40073,40074,40075,40076,40081,40082,40083,40084,40091,40092,40140,40141,40142,40143,40501,40511,40512,40513,40521,40522,40523,40531,40532,40533,40534,40541,40542,40543,40544,40545,40546,40550,40551,40553,40555,40561,40562,40563,40571,40572,40573,40581,40582,40583,40584,40591,40592,40841,40842,40843,40844,41001,41002,41003,41004,41006,41007,41008,41009,41011,41012,41013,41014,41016,41017,41018,41019,41020,41021,41022,41023,41024,41030,41031,41043,41044,41502,41504,41505,41506,41507,41510,41511,41514,41515,41516,41517,41543,42001,42002,42003,42004,42005,42501,50001,50002,50003,50004,50006,50007,50008,50009,50010,50011,50012,50013,50014,50015,50016,50017,50501,50502,50606,50607,50608,50609,50610,50611,50612,50613,50614,50615,50616,50617,50618,51001,51002,51003,51011,51012,51013,51014,51021,51022,51023,51024,51061,51062,51063,51071,51072,51073,51081,51083,51084,51091,51092,51101,51102,51103,51111,51113,51114,51120,51121,51122,51123,51124,51125,51126,51127,51133,51134,51140,51141,51161,51162,51163,51171,51172,51173,51181,51183,51184,51191,51192,51201,51206,51207,51220,51221,51222,51301,51321,51322,51506,51507,51508,51509,52004,52005,52006,52123,52124,52508,52509,52511,52513,52514,52515,53003,53004,53502,53503,53510,53520,53521,53522,53523,53603,53604,53605,55122}'::integer[]))
10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on entries_ind4 (cost=0.00..6,752.21 rows=238,269 width=0) (actual rows= loops=)

  • Index Cond: ((fund_id = ANY ('{45,48,49,15,26,43,27,42,50,52,1,6,44,41,47,30,16,33,23,10,14,24,21,32,18,51,31,3,4,35,5,20,22,34,2,19,11,40,37,17,39,38,12,7,29,36,8,9,13,25,28}'::integer[])) AND (value_dt >= to_date('20190102'::text, 'yyyymmdd'::text)) AND (value_dt <= to_date('20200102'::text, 'yyyymmdd'::text)))
11. 0.000 0.000 ↓ 0.0

Hash (cost=12.69..12.69 rows=469 width=15) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on accounts a_2 (cost=0.00..12.69 rows=469 width=15) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Index Scan using trans_pk on trans t_2 (cost=0.42..1.55 rows=1 width=89) (actual rows= loops=)

  • Index Cond: ((fund_id = s_2.fund_id) AND (trans_id = s_2.trans_id))
14. 0.000 0.000 ↓ 0.0

Hash (cost=18.48..18.48 rows=8 width=129) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=1.18..18.48 rows=8 width=129) (actual rows= loops=)

  • Hash Cond: (fg_2.fund_group_id = fnd_2.fund_group_id)
16. 0.000 0.000 ↓ 0.0

Seq Scan on fund_group fg_2 (cost=0.00..15.30 rows=530 width=122) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Hash (cost=1.08..1.08 rows=8 width=15) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on fund fnd_2 (cost=0.00..1.08 rows=8 width=15) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Hash (cost=1.03..1.03 rows=3 width=12) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Seq Scan on trader tr (cost=0.00..1.03 rows=3 width=12) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Hash (cost=12.83..12.83 rows=483 width=24) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Seq Scan on trialbal tb_2 (cost=0.00..12.83 rows=483 width=24) (actual rows= loops=)