explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fC44

Settings
# exclusive inclusive rows x rows loops node
1. 36.014 37.897 ↑ 1.0 100 1

Sort (cost=440.87..441.12 rows=100 width=2,413) (actual time=37.893..37.897 rows=100 loops=1)

  • Sort Key: (((uid)::text = 'chrg_5l5uzzk06av4qqzmbs4'::text)) DESC, (((uid)::text = 'chrg_5l5uzzbrzl5l76d8vdk'::text)) DESC, (((uid)::text = 'chrg_5l5uz4cyul7amucr1op'::text)) DESC, (((uid)::text = 'chrg_5l5uykjzq66k2a8jmup'::text)) DESC, (((uid)::text = 'chrg_5l5uyetpf8un9bepe1w'::text)) DESC, (((uid)::text = 'chrg_5l5uye5wz1n2v33c0n4'::text)) DESC, (((uid)::text = 'chrg_5l5uy7c85lox5juhcv9'::text)) DESC, (((uid)::text = 'chrg_5l5uxz1huj8nvzw2w39'::text)) DESC, (((uid)::text = 'chrg_5l5uxwllut3durhffsq'::text)) DESC, (((uid)::text = 'chrg_5l5uxvdslg52a1gw4d1'::text)) DESC, (((uid)::text = 'chrg_5l5uxr47rv9xqa1qqfh'::text)) DESC, (((uid)::text = 'chrg_5l5uxkzve1nju9fdpmz'::text)) DESC, (((uid)::text = 'chrg_5l5uxhtd0hiawiosepd'::text)) DESC, (((uid)::text = 'chrg_5l5ux3kj1eeycycjit6'::text)) DESC, (((uid)::text = 'chrg_5l5uwtn8p9n1uc4j50z'::text)) DESC, (((uid)::text = 'chrg_5l5uwiuw05fujlwpt3h'::text)) DESC, (((uid)::text = 'chrg_5l5uw7z06slgblqsqy0'::text)) DESC, (((uid)::text = 'chrg_5l5uvy86ccz7tv1hzto'::text)) DESC, (((uid)::text = 'chrg_5l5uvs559wdvo5wxa1r'::text)) DESC, (((uid)::text = 'chrg_5l5uv7u7aw3lmqaymbj'::text)) DESC, (((uid)::text = 'chrg_5l5uv27e3gryfataxsa'::text)) DESC, (((uid)::text = 'chrg_5l5uuzj3b7m8v4zwn80'::text)) DESC, (((uid)::text = 'chrg_5l5uuywhid13pxa0v1u'::text)) DESC, (((uid)::text = 'chrg_5l5uusnhkfs7r7yfpnk'::text)) DESC, (((uid)::text = 'chrg_5l5uuqe8jjoyqcuw06m'::text)) DESC, (((uid)::text = 'chrg_5l5uuq3nhfxv7do1tsb'::text)) DESC, (((uid)::text = 'chrg_5l5uuj5uxs1kz24ykt6'::text)) DESC, (((uid)::text = 'chrg_5l5uuht2owb0r644gqe'::text)) DESC, (((uid)::text = 'chrg_5l5uu82wam7im4wr0b8'::text)) DESC, (((uid)::text = 'chrg_5l5uu111tc36jt1tefh'::text)) DESC, (((uid)::text = 'chrg_5l5uu0k6zm6ry5vlc71'::text)) DESC, (((uid)::text = 'chrg_5l5utxv18ugropzvnne'::text)) DESC, (((uid)::text = 'chrg_5l5utnessm6y3wwbz9y'::text)) DESC, (((uid)::text = 'chrg_5l5utgb6b15tai3m3vj'::text)) DESC, (((uid)::text = 'chrg_5l5utcvpz8hcflt2qxf'::text)) DESC, (((uid)::text = 'chrg_5l5utchxi1nogwnt328'::text)) DESC, (((uid)::text = 'chrg_5l5uta95mc2iz5qhnxc'::text)) DESC, (((uid)::text = 'chrg_5l5ut7rxo8dfr6xmegl'::text)) DESC, (((uid)::text = 'chrg_5l5ut6elz4d8uxv20f0'::text)) DESC, (((uid)::text = 'chrg_5l5ut523uzooie4vp38'::text)) DESC, (((uid)::text = 'chrg_5l5ut26z0nztkptt9fz'::text)) DESC, (((uid)::text = 'chrg_5l5usx7vtgfim34nr2o'::text)) DESC, (((uid)::text = 'chrg_5l5usvkeffoyv727j2s'::text)) DESC, (((uid)::text = 'chrg_5l5usi1z5gjlgjga5w0'::text)) DESC, (((uid)::text = 'chrg_5l5urakxjwxy040czzk'::text)) DESC, (((uid)::text = 'chrg_5l5ur46xrhs67z4pf7g'::text)) DESC, (((uid)::text = 'chrg_5l5uqo0lxxerprrmwt8'::text)) DESC, (((uid)::text = 'chrg_5l5uqlmj98a4piedj11'::text)) DESC, (((uid)::text = 'chrg_5l5uqkw1lh4iwc0v6sj'::text)) DESC, (((uid)::text = 'chrg_5l5uq4177iqm1zsg3jv'::text)) DESC, (((uid)::text = 'chrg_5l5uq3p1u6pd77xr3c9'::text)) DESC, (((uid)::text = 'chrg_5l5uprwrf2apb4l5m0q'::text)) DESC, (((uid)::text = 'chrg_5l5uphsays1k70id57o'::text)) DESC, (((uid)::text = 'chrg_5l5uphb2zjzv33m683r'::text)) DESC, (((uid)::text = 'chrg_5l5upd20tliuoz93fv1'::text)) DESC, (((uid)::text = 'chrg_5l5up93khzaqmc6zh2i'::text)) DESC, (((uid)::text = 'chrg_5l5uox9tjedcemrdh2j'::text)) DESC, (((uid)::text = 'chrg_5l5uoli9fhxrhlpzsps'::text)) DESC, (((uid)::text = 'chrg_5l5uol4isr6i58bhljq'::text)) DESC, (((uid)::text = 'chrg_5l5uofpze51agba6kzu'::text)) DESC, (((uid)::text = 'chrg_5l5uni7buedlcu3fgyk'::text)) DESC, (((uid)::text = 'chrg_5l5un70d7qygrbnf7i1'::text)) DESC, (((uid)::text = 'chrg_5l5umfmsbn173dr8m02'::text)) DESC, (((uid)::text = 'chrg_5l5umdletqn16l0o9st'::text)) DESC, (((uid)::text = 'chrg_5l5umcz2y8qp6ikhtc4'::text)) DESC, (((uid)::text = 'chrg_5l5umbgfxbbjwyh34h6'::text)) DESC, (((uid)::text = 'chrg_5l5ulpmaz6ymztl0aet'::text)) DESC, (((uid)::text = 'chrg_5l5ule57sdddqn67or7'::text)) DESC, (((uid)::text = 'chrg_5l5ul8n5mp7ci51bpjn'::text)) DESC, (((uid)::text = 'chrg_5l5ul4wsbj5m8sabyic'::text)) DESC, (((uid)::text = 'chrg_5l5ukdzhzyc8l4qrz6c'::text)) DESC, (((uid)::text = 'chrg_5l5uk1qefdltky2kzp7'::text)) DESC, (((uid)::text = 'chrg_5l5ujyldf5wtl9qjx5u'::text)) DESC, (((uid)::text = 'chrg_5l5ujszgs50q2pg98ux'::text)) DESC, (((uid)::text = 'chrg_5l5ujokig4pzha1bk4c'::text)) DESC, (((uid)::text = 'chrg_5l5ujlbjz2c0b65puoh'::text)) DESC, (((uid)::text = 'chrg_5l5ujed3jpc5ur6lay5'::text)) DESC, (((uid)::text = 'chrg_5l5uiz4bndf0qb3do2n'::text)) DESC, (((uid)::text = 'chrg_5l5uiold7ts62dsmavw'::text)) DESC, (((uid)::text = 'chrg_5l5uikf42ycuh7863ze'::text)) DESC, (((uid)::text = 'chrg_5l5uif7qsin6d820c16'::text)) DESC, (((uid)::text = 'chrg_5l5uic2qnk32bh0b7s0'::text)) DESC, (((uid)::text = 'chrg_5l5uhsv74eofqra25cs'::text)) DESC, (((uid)::text = 'chrg_5l5uhbql233g3hmt50a'::text)) DESC, (((uid)::text = 'chrg_5l5uh5c5namx1l9nhei'::text)) DESC, (((uid)::text = 'chrg_5l5ugy1qzjxa81iiyku'::text)) DESC, (((uid)::text = 'chrg_5l5ugbfegwtw80lb14p'::text)) DESC, (((uid)::text = 'chrg_5l5ug280ioxrv8rax1j'::text)) DESC, (((uid)::text = 'chrg_5l5ufthlj99ptgkz54e'::text)) DESC, (((uid)::text = 'chrg_5l5ufjx3ltxf92t2v3a'::text)) DESC, (((uid)::text = 'chrg_5l5uf9l93uer8qfjt4e'::text)) DESC, (((uid)::text = 'chrg_5l5uf8cnyj3uayfpz6y'::text)) DESC, (((uid)::text = 'chrg_5l5uf3v1u26mw4hjg7p'::text)) DESC, (((uid)::text = 'chrg_5l5uevc5jou0cvj1a8m'::text)) DESC, (((uid)::text = 'chrg_5l5ueu6o23lz8uddjvi'::text)) DESC, (((uid)::text = 'chrg_5l5uej69gmr64l4ajxz'::text)) DESC, (((uid)::text = 'chrg_5l5ue8c73jhn9tpoh52'::text)) DESC, (((uid)::text = 'chrg_5l5ue7gs0zsg7joj7vp'::text)) DESC, (((uid)::text = 'chrg_5l5ue27zvysox30ubkp'::text)) DESC, (((uid)::text = 'chrg_5l5udvdekp2zcm2yfpq'::text)) DESC
  • Sort Method: quicksort Memory: 246kB
2. 1.883 1.883 ↑ 1.0 100 1

Index Scan using index_charges_on_uid on charges (cost=0.57..437.55 rows=100 width=2,413) (actual time=0.440..1.883 rows=100 loops=1)

  • Index Cond: ((uid)::text = ANY ('{chrg_5l5uzzk06av4qqzmbs4,chrg_5l5uzzbrzl5l76d8vdk,chrg_5l5uz4cyul7amucr1op,chrg_5l5uykjzq66k2a8jmup,chrg_5l5uyetpf8un9bepe1w,chrg_5l5uye5wz1n2v33c0n4,chrg_5l5uy7c85lox5juhcv9,chrg_5l5uxz1huj8nvzw2w39,chrg_5l5uxwllut3durhffsq,chrg_5l5uxvdslg52a1gw4d1,chrg_5l5uxr47rv9xqa1qqfh,chrg_5l5uxkzve1nju9fdpmz,chrg_5l5uxhtd0hiawiosepd,chrg_5l5ux3kj1eeycycjit6,chrg_5l5uwtn8p9n1uc4j50z,chrg_5l5uwiuw05fujlwpt3h,chrg_5l5uw7z06slgblqsqy0,chrg_5l5uvy86ccz7tv1hzto,chrg_5l5uvs559wdvo5wxa1r,chrg_5l5uv7u7aw3lmqaymbj,chrg_5l5uv27e3gryfataxsa,chrg_5l5uuzj3b7m8v4zwn80,chrg_5l5uuywhid13pxa0v1u,chrg_5l5uusnhkfs7r7yfpnk,chrg_5l5uuqe8jjoyqcuw06m,chrg_5l5uuq3nhfxv7do1tsb,chrg_5l5uuj5uxs1kz24ykt6,chrg_5l5uuht2owb0r644gqe,chrg_5l5uu82wam7im4wr0b8,chrg_5l5uu111tc36jt1tefh,chrg_5l5uu0k6zm6ry5vlc71,chrg_5l5utxv18ugropzvnne,chrg_5l5utnessm6y3wwbz9y,chrg_5l5utgb6b15tai3m3vj,chrg_5l5utcvpz8hcflt2qxf,chrg_5l5utchxi1nogwnt328,chrg_5l5uta95mc2iz5qhnxc,chrg_5l5ut7rxo8dfr6xmegl,chrg_5l5ut6elz4d8uxv20f0,chrg_5l5ut523uzooie4vp38,chrg_5l5ut26z0nztkptt9fz,chrg_5l5usx7vtgfim34nr2o,chrg_5l5usvkeffoyv727j2s,chrg_5l5usi1z5gjlgjga5w0,chrg_5l5urakxjwxy040czzk,chrg_5l5ur46xrhs67z4pf7g,chrg_5l5uqo0lxxerprrmwt8,chrg_5l5uqlmj98a4piedj11,chrg_5l5uqkw1lh4iwc0v6sj,chrg_5l5uq4177iqm1zsg3jv,chrg_5l5uq3p1u6pd77xr3c9,chrg_5l5uprwrf2apb4l5m0q,chrg_5l5uphsays1k70id57o,chrg_5l5uphb2zjzv33m683r,chrg_5l5upd20tliuoz93fv1,chrg_5l5up93khzaqmc6zh2i,chrg_5l5uox9tjedcemrdh2j,chrg_5l5uoli9fhxrhlpzsps,chrg_5l5uol4isr6i58bhljq,chrg_5l5uofpze51agba6kzu,chrg_5l5uni7buedlcu3fgyk,chrg_5l5un70d7qygrbnf7i1,chrg_5l5umfmsbn173dr8m02,chrg_5l5umdletqn16l0o9st,chrg_5l5umcz2y8qp6ikhtc4,chrg_5l5umbgfxbbjwyh34h6,chrg_5l5ulpmaz6ymztl0aet,chrg_5l5ule57sdddqn67or7,chrg_5l5ul8n5mp7ci51bpjn,chrg_5l5ul4wsbj5m8sabyic,chrg_5l5ukdzhzyc8l4qrz6c,chrg_5l5uk1qefdltky2kzp7,chrg_5l5ujyldf5wtl9qjx5u,chrg_5l5ujszgs50q2pg98ux,chrg_5l5ujokig4pzha1bk4c,chrg_5l5ujlbjz2c0b65puoh,chrg_5l5ujed3jpc5ur6lay5,chrg_5l5uiz4bndf0qb3do2n,chrg_5l5uiold7ts62dsmavw,chrg_5l5uikf42ycuh7863ze,chrg_5l5uif7qsin6d820c16,chrg_5l5uic2qnk32bh0b7s0,chrg_5l5uhsv74eofqra25cs,chrg_5l5uhbql233g3hmt50a,chrg_5l5uh5c5namx1l9nhei,chrg_5l5ugy1qzjxa81iiyku,chrg_5l5ugbfegwtw80lb14p,chrg_5l5ug280ioxrv8rax1j,chrg_5l5ufthlj99ptgkz54e,chrg_5l5ufjx3ltxf92t2v3a,chrg_5l5uf9l93uer8qfjt4e,chrg_5l5uf8cnyj3uayfpz6y,chrg_5l5uf3v1u26mw4hjg7p,chrg_5l5uevc5jou0cvj1a8m,chrg_5l5ueu6o23lz8uddjvi,chrg_5l5uej69gmr64l4ajxz,chrg_5l5ue8c73jhn9tpoh52,chrg_5l5ue7gs0zsg7joj7vp,chrg_5l5ue27zvysox30ubkp,chrg_5l5udvdekp2zcm2yfpq}'::text[]))
Planning time : 2.389 ms
Execution time : 38.176 ms