explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b2BKX

Settings
# exclusive inclusive rows x rows loops node
1. 4.126 187.767 ↑ 1.0 501 1

Unique (cost=3,380.40..3,464.61 rows=501 width=60) (actual time=170.865..187.767 rows=501 loops=1)

2. 152.196 183.641 ↓ 1.5 25,050 1

Sort (cost=3,380.40..3,422.51 rows=16,842 width=60) (actual time=170.864..183.641 rows=25,050 loops=1)

  • Sort Key: "caseDetails".case_name
  • Sort Method: external merge Disk: 1816kB
3. 7.232 31.445 ↓ 1.5 25,050 1

Merge Join (cost=2,029.53..2,198.11 rows=16,842 width=60) (actual time=20.307..31.445 rows=25,050 loops=1)

  • Merge Cond: ("caseDetails".transaction_id = transaction.id)
4. 5.336 5.336 ↑ 1.0 25,050 1

Index Scan using id_idx on case_details "caseDetails" (cost=0.29..1,072.04 rows=25,050 width=60) (actual time=0.014..5.336 rows=25,050 loops=1)

5. 6.282 18.877 ↓ 1.5 10,550 1

Sort (cost=1,993.83..2,011.59 rows=7,106 width=8) (actual time=18.113..18.877 rows=10,550 loops=1)

  • Sort Key: transaction.id
  • Sort Method: quicksort Memory: 879kB
6. 12.595 12.595 ↓ 1.5 10,550 1

Index Scan using idx_serial on transactions transaction (cost=0.29..1,539.23 rows=7,106 width=8) (actual time=1.925..12.595 rows=10,550 loops=1)

  • Index Cond: ((serial)::text = ANY ('{0987654321,0A297840DC53065768A62E16,1020357820,1134514185,1199377603,1234567888,1429017577,1479276500,1533854281,1580024204,1608315995,1614841227,1628081414,1669078479,1762205783,2130406057,213040657,2143700426,222RMHHHCCWVI5BSUXRMI,272817798,2F7WK3BI4STKUUHKMQW22,2LLLB7X2GIBBHPYR5C4X2,2U4IHKY5AESWV6RZ72DFU,2UIEXPYA4RU6FY3KG3QSE,2UISJHZEBW5PK5AV7SDT4,3488D15277A2AAE75E1673F5,34Y5HCHHW4YLSZKMCVR42,34YKV34PLLACTCK5T3RYQ,355MZ3EAFODK2XUZUXPAC,3KLKJ6K3QPAOO47CDZRKA,3QHAZWVF5HWHGVEOORN4A,3SBET3FXMRVHBXXK4PPYO,403921497,5717152,5724144,57697205946687094,5917142,5917154,5921070,5926356,5926446,5934087,5938741,5938924,5941143,5959590,5959850,5980777,5980787,5989991,5995950,611735153,625UNAH4EHZ2Y7IDDXKFW,627X5UPNGDB2Y7KEBXLDS,62NXJQP5EHB2Y2IDDW7FS,693908330,6CWN23BNYDET77C4N62HO,6S5WJUO5EBJSY6IDDXZFW,6SYY5FZJOH6IZUB7AYUXU,7003543,71514266002615086,7200009,7200015,5902894,5905862,626857879,7200007,7200061,7200105,7200408,7200429,7201537,7201547,7204694,7204695,7207932,7207933,7207934,7208463,7208492,7208741,7220002,7222222,7254543,725WNBG5EFB2Y6IBDXYFW,727XJVO4GHQ2Y7KFBW3HS,7285580,7287765,7298072,7298074,72N7ZRP5EBR2Y7IBDWNFW,75XO3DBVJKSK5N7N2CXIQ,798759553,7HQL5O5F56PUYKZXG5X6U,7O22Q4TGUQR5RG73DF6MC,7PYYMTK4SNWAGAIKY2XA2,7ZY74FPM4QDPAWOPD6NCU,864471341,99790920,AJDXWIGLTXGMIEYLYJPBG,AKZYRVLZGCBII7O2XTASM,AQQBRDNAIV7RIOSHX7TYS,AYCVZFMCPJUZBQDQJHGYC,AZDDVXDFOO2VJAOLYAE5E,BYA7NUFSNNMRBVBWLHE2C,CTQZKPJZMGTIVVLROHB4O,D65B0A881426FD4BF12DD6AA,DRLPEOP7LQAI3QM4737J6,ED2YDL7N5WFEGGYOXY44A,EFL7OCGZEIYFH3NINP25M,FKLP7GLGNF2GAJXZL3APE,G2PW5BG4EBB2Y3KEBXMBW,GFG3D76C7ECQ6K3ALWVCE,H2PX5QPMGHBSY7KHDWNHS,IKJTRBCYGEAII6M7XTFUI,IRBABTDUMIK5JEOMYBR3A,IZRLFSKFOI3VJFMMYAVZE,JQQ7JAECNNVRBRBXLGT6C,JZBIFCDVMOLVJFOJ2BQZE,KO5B5NA5NG7FF4LGYGKQE,LFNW27AI4QKKUVFKORT22,DQR6QEQH2JYW7645ZCVDK,FADFYRIUWBZTLLXNF7QPI,7201541,7200089,7200029,7200032,LIML2FHIDY3GKMCF75FH6,LLJBBOX3EMZBHLYW5C4R2,M2EDSO65W577B5QAYJVKE,M6PVLA3JVKRF3LB2SUUDW,MCZO3TLHND2GAJVZL2WJE,MNKYMHXTQVZHCDV6NYLFM,MZCY4MMDC6F7EAQ5AUFB6,N3S4D6KVOHPJ4D2M6ESRO,NU3FV4TBAIHO2SU3EFNX4,O5SBTHHGJRQVMGPNEBVPQ,OQP26PHNXNSF7UNLGMKPY,PEWK2SDOJIY6YRNMGHWSA,PYSTVEM5P7VFQUPHSB6NI,QAR44HTTP56XIUI34EIM2,QBQ5CM7GDG57U5IGR2WHY,QI2QSUNO7H6J3DAYYI4JM,QYHT74ASULSDFGYRNC6JA,RJEXZ5XF6VWCVLBNDI5TG,SMMRNCWFDDC5RDSIAZAWS,SNOMOHRBSIZJ46DCCO7KQ,SOB7Y6RE3LBPGDF6AMU5U,SYLW42EH7NUNETOI6WOLK,U5GEUXJOQZPYUZ2NYZQBY,UMMABOH6P43AN75BIAKO2,WDJS2WVMBXS7B4SRPCIQK,WSIZ5ARJMHOAZRDYCZDTQ,WSN55UPMEFRSY3ICDWOBS,WYCRBRFMN5UNQQPBSB6PM,WYQZBREMPZMNQVPBQA7PI,X256JFHMGFISY7ICDXZBS,X27VNUHMEDB2Y3IADW2BS,X27WZBOMGBI2Y3KGBWJHW,YEMRTC6GLEN7F3ODJVOXW,YIT5IDSDN3X7IVK36EYI2,YKJYFVLJGEIII7M7VTUSI,YL7UC6ANX7HAJRWDCB36W,YU43X3KKCN46XHGUZNBVA,ZQC45REDNLMZBVBQLHVYC,2QDCOMM3NRHVOW4CJSCYY,7201632,JK4JQ2TKLLC2F3LKKDGE6,1102128710,1337904723,LDT633DSFXQUDAJCAGDDK,7202680,423782703,7200065,QE4YDDXXJAFXF7MGLVLTW,204843477,LYI2RFVC7RVAAGSN6GF6W,776012396389009345,1527921289,5701455,134918BEEB42782E9516D86C,65D5D83A8A33FD573724FD97,6DB921A41EBBA949BB75DE69,806F7AE5203550D4D053C03B,8EDE1622F9C39AEF53B35BE6,91378371033F3E23AFC417A1,A2B5D86215114D0B43416269,E5B9BA60E06A785C500FE3EB,1093645310,1671803823,7202104,7202137,7204395,7204447,7204457,7204693,7208279,7213119,7213120,730448107,ASSAVAFPIQOZJ23PALUIC,CFP4K7JI6QTCUVFLMRVY6,IXVA7KDB3EBBATBRNPKJC,LDXKIK3DRCUR2NY5E7VB2,OJ4V7SDFCUDGHBUZIUKIW,RHXW6KGTZ3G476RZQYADU,42WKWL7MUZ77BYQDYIXME,6VSLTGHXJXQVMDPJGBQJQ,PQCIJTVLON4TLEVLCYUGK,269477634,5SIZ2IDMNDLIHL3DI4JYW,TVCSJ4QSNZE7MFOWMQQLQ,1879845226,7202673,7210558,7220069,819308753,W32RSC3LOQBCX23CRIHTC,YBE3IRY6F5DTLD2KC2NTG,YU6QTLCLCJFWXCGX3MQRE,1820458905,85471965,2106581153,238259168,7200002,7200004,7200110,7201534,CC74Y3CO62YNYC6QK56JO,USR3FQT24Q5HI6AWR56CE,1539590653,1821706618,2097169595,3AD5E2S3WVBVORA6MAZXK,GCVYJYQCSEAKDBIJEHUUK,KFMNXRVFUGGNCOSOBNPCM,ESUCCK6MW7HXB4QC2JTIE,PA7EKHFI7ZFEC6W3WIQZ6,XYL2ALDM5KEOZ5V3EOFPG,7200412,AOLPMQ3UPJCNYX7ICZWCA}'::text[]))