explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lNFs

Settings
# exclusive inclusive rows x rows loops node
1. 3.311 6.979 ↑ 1.2 165 1

GroupAggregate (cost=0.85..4,197.82 rows=203 width=1,503) (actual time=0.114..6.979 rows=165 loops=1)

  • Group Key: designs.uuid
2. 0.450 3.668 ↓ 1.7 344 1

Nested Loop Left Join (cost=0.85..4,193.26 rows=203 width=1,747) (actual time=0.031..3.668 rows=344 loops=1)

3. 1.733 1.733 ↑ 1.2 165 1

Index Scan using designs_pkey on designs (cost=0.42..1,704.48 rows=203 width=1,471) (actual time=0.017..1.733 rows=165 loops=1)

  • Index Cond: ((uuid)::text = ANY ('{s10KZIac5,QwBYv0djk,ah8zRTbYX,Cw0qy3h4c,pwb8JAf89,FHT-NVDfc,z-zy7Yjr,F-eRmrbHK,pHhOCFWQ9,QwNJekFpU,QHdzD0NKV,FH_wS81lx,hS16eVDNb,piLOq0O5d,jdbaVk6Ss,zwdurYjo,piIcddDlc,z-7ZZ_hFX,YoW2tpcvr,8NaUuuSio,LHshpzS1c,VVHtnyVR0,ECFiLJTKT,FiZNNWVAj,8A4nuXFzP,z-t85T29O,TEG5bs1Ux,Q-5cyG6rK,SgkZD_DY0,pH7nCAkeO,zHp5DXeIE,mvsfAYe3p,xiWTMmGWH,wL1cI--_j,jzkJ4Nhgo,z-A1XcyHO,zwRTp2vEe,QwDPv2jEe,zilt_OvKv,Fi6QcrP6j,FiAmTKT7v,FwSXNpBR9,FH2IYXiOe,Qwax7O0Ej,QHoJHcKKU,Qwi89bWxj,piC7zyPxe,F-fBZPPKv,zwZgy5lde,FwsU4MqOx,pir-HuBdv,F--WieiOc,zH2WvQfKe,FwaNNUw5v,Q-uLRMm5K,pwztdjHkc,zwVYZkldv,zwnI7AAEj,FwE1ZFs1,p-ZxxTL5d,FHDfMQJs,F-6hrpzxd,ziVh622oj,zw2RhYS4c,pH5kC22aj,Q-IuFLCaj,zipW1MmVx,z-bdGhrxe,pwmrtTLae,pix5smrKj,F-XR0mDUU,zwzTTJco,z-N20MhOx,FHXn4sgOE,zHNILOldj,Tw6Po0aDv,QHvyM2L3c,z-tfCQ0xe,zi0LXWh5d,F-mMbqiej,Q-KgvlUEv,Q-9X9ql9c,LiOatSZCj,zHlIZECOj,FHQKKjR2X,Qi631UCVj,pHJ5NET5c,pipHQVCoe,Qw8N3epte,FHivuVL3v,QHtYP9LVj,p-ePyJnVj,pwIiIVLac,QibiMIuyc,zwEAB80R9,z-0NAy-fe,F-Fv4VCkv,Q-W6-N8kc,QHP_ycFHU,F-hjtsIEe,pH1aReLkc,Q-7_Ts5wc,FiecjETkj,FiE6mRUjd,pHOHWpQT,p-Wm8K2Oj,QHLADOToc,FHVWKOikj,zicrZb68j,z-KI3Z2Oe,ziIO9k-kj,z-SldkIz,zic7p9Dzc,pwm3EDfHU,z-lyCXDpc,pw9C1axkj,F-QCM8EVj,THv7LsZ6,QwhFlPMej,p-VfO9nB,piLVWOHXc,zi19jzz95,pHfInZT3e,pwnztt2oj,F-Ckg5QDE,Qigpww1Vj,pi2td8FOe,QHPttkzWd,L-59Udxac,Q-VLtSZ6e,zimT0tL3j,F-fAQ1FOv,zw5XPZfOj,pixm8BLoe,Qi-Xxel5v,QHO2wQQZk,zHgNyt23e,zHRuS4NIE,CH1otm_Wv,zwwy1RBId,pw4azFyUv,THCLBZPpe,zi73yIhHe,FiIxYxlOe,pwsuwLpDK,pwh8tkFWK,p-52FsCoc,Q-TOGX15c,pwJn_LF9k,QwjbXnpOe,z-F7_nU9c,F-dMqu27e,pwy68kFIx,QiFoIJOBe,Qw-77mI3,piZpnvfkc,QHcZMfzVe,z-PGGMLoe,piIP6MT7c,Qi9ttYC7j,Fi04BMTae,F-jDYbToc,FH1KeFz9k,zwsjtkzDK,2-V5Sqsjc,QwhWkMN7d,FiEv7oHve,zHkuihwjc,zi83_2w9v,"zH
  • Filter: (NOT is_deleted)
  • Rows Removed by Filter: 1
4. 1.485 1.485 ↑ 1.0 2 165

Index Scan using images_design_index on images (cost=0.42..12.24 rows=2 width=285) (actual time=0.008..0.009 rows=2 loops=165)

  • Index Cond: ((designs.uuid)::text = (design)::text)