explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jts8

Settings
# exclusive inclusive rows x rows loops node
1. 106.614 84,848.369 ↓ 4.1 278 1

Gather (cost=16,646.90..180,436.39 rows=68 width=135) (actual time=4,424.468..84,848.369 rows=278 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 8.446 84,741.755 ↓ 3.3 93 3 / 3

Hash Join (cost=15,646.90..179,429.59 rows=28 width=135) (actual time=5,594.387..84,741.755 rows=93 loops=3)

  • Hash Cond: ((simple1_.ws_config_id)::text = (config2_.ws_config_id)::text)
3. 15.290 80,419.448 ↑ 1.2 14,945 3 / 3

Nested Loop (cost=0.98..163,734.76 rows=18,629 width=167) (actual time=7.580..80,419.448 rows=14,945 loops=3)

4. 495.025 495.025 ↑ 1.2 14,945 3 / 3

Parallel Index Scan using pricing_clarification_simple_id_uindex on pricing_clarification pricingcla0_ (cost=0.41..18,681.38 rows=18,629 width=135) (actual time=0.006..495.025 rows=14,945 loops=3)

5. 79,909.133 79,909.133 ↑ 1.0 1 44,834 / 3

Index Scan using wholesale_simple_pkey on wholesale_simple simple1_ (cost=0.56..7.79 rows=1 width=65) (actual time=5.347..5.347 rows=1 loops=44,834)

  • Index Cond: ((ws_simple_id)::text = (pricingcla0_.simple_id)::text)
6. 3.674 4,313.861 ↓ 3.8 11,215 3 / 3

Hash (cost=15,609.34..15,609.34 rows=2,927 width=32) (actual time=4,313.861..4,313.861 rows=11,215 loops=3)

  • Buckets: 16384 (originally 4096) Batches: 1 (originally 1) Memory Usage: 711kB
7. 17.859 4,310.187 ↓ 3.8 11,215 3 / 3

Bitmap Heap Scan on wholesale_config config2_ (cost=4,479.32..15,609.34 rows=2,927 width=32) (actual time=4,296.864..4,310.187 rows=11,215 loops=3)

  • Recheck Cond: (((supplier_code)::text = ANY ('{K72042,K72528,K86777,K70139,K83656,K70114,K87950,K70115,K10782,K70101,K70583,K85441,K70116,K10943,K85893,K85672,K86818,K11495,K86839,K70311,K86077,K83789,K85576,K70147,K10627,K88057,K70819,K87330,K87105,K72512,K83487,K72566,K87867,K83130,K70119,K70143,K84036,K87228,K70113,K72561,K85941,K70195,K84865,K87479,K11282,K86981,K72794,K85515,K87696,K10867,K72802,K70248,K70236,K86005,K72845,K71104,K70240,K83416,K85121,K86785,K70214,K11600,K86962,K85347,K11511,K71359,K70225,K72864,K10156,K11790,K11482,K72754,K11024,K70451,K70260,K72816,K10102,K70298,K85663,K11066,K10711,K83163,K73008,K70352,K10093,K84514,K72336,K84406,K86238,K10590,K83101,K84507,K84258,K73047,K70797,K70388,K70301,K70372,K11094}'::text[])) AND ((season_code)::text = 'FS20'::text) AND (NOT deleted) AND ((brand_code)::text = ANY ('{110,230,PO9,APC,A0F,ABD,AB3,AE8,AD2,A43,AD1,AD5,AF7,AG2,AI2,A01,AH2,5AP,1AL,AC7,A24,AN3,ANQ,ANT,A0P,0AN,ANN,ANS,A18,ARA,ARJ,A15,ARS,AJ2,AR3,A22,ARH,AR1,AS2,AS1,A0H,A0I,AS3,BY8,B0U,BA7,B1E,BA2,BAK,B89,BAT,BT9,B30,B11,BER,BET,B92,B28,BE8,BE9,BE6,4BE,B21,BEP,RG6,BEO,1BS,6BI,BI3,BI7,BH5,BIA,BIQ,BI1,BI4,B58,BJ2,BL7,BLM,B36,BL1,BE0,LF0,BL8,BS9,B69,BOJ,BOD,BO7,BO6,BP8,BON,BO3,BO9,B50,BR0}'::text[])))
  • Heap Blocks: exact=7751
8. 2.489 4,292.328 ↓ 0.0 0 3 / 3

BitmapAnd (cost=4,479.32..4,479.32 rows=2,927 width=0) (actual time=4,292.328..4,292.328 rows=0 loops=3)

9. 2,398.445 2,398.445 ↑ 1.1 41,603 3 / 3

Bitmap Index Scan on config_supplier_code_season_not_deleted (cost=0.00..1,689.52 rows=47,528 width=0) (actual time=2,398.445..2,398.445 rows=41,603 loops=3)

  • Index Cond: (((supplier_code)::text = ANY ('{K72042,K72528,K86777,K70139,K83656,K70114,K87950,K70115,K10782,K70101,K70583,K85441,K70116,K10943,K85893,K85672,K86818,K11495,K86839,K70311,K86077,K83789,K85576,K70147,K10627,K88057,K70819,K87330,K87105,K72512,K83487,K72566,K87867,K83130,K70119,K70143,K84036,K87228,K70113,K72561,K85941,K70195,K84865,K87479,K11282,K86981,K72794,K85515,K87696,K10867,K72802,K70248,K70236,K86005,K72845,K71104,K70240,K83416,K85121,K86785,K70214,K11600,K86962,K85347,K11511,K71359,K70225,K72864,K10156,K11790,K11482,K72754,K11024,K70451,K70260,K72816,K10102,K70298,K85663,K11066,K10711,K83163,K73008,K70352,K10093,K84514,K72336,K84406,K86238,K10590,K83101,K84507,K84258,K73047,K70797,K70388,K70301,K70372,K11094}'::text[])) AND ((season_code)::text = 'FS20'::text))
10. 1,891.394 1,891.394 ↑ 1.1 105,063 3 / 3

Bitmap Index Scan on config_brand_code (cost=0.00..2,788.08 rows=118,266 width=0) (actual time=1,891.394..1,891.394 rows=105,063 loops=3)

  • Index Cond: ((brand_code)::text = ANY ('{110,230,PO9,APC,A0F,ABD,AB3,AE8,AD2,A43,AD1,AD5,AF7,AG2,AI2,A01,AH2,5AP,1AL,AC7,A24,AN3,ANQ,ANT,A0P,0AN,ANN,ANS,A18,ARA,ARJ,A15,ARS,AJ2,AR3,A22,ARH,AR1,AS2,AS1,A0H,A0I,AS3,BY8,B0U,BA7,B1E,BA2,BAK,B89,BAT,BT9,B30,B11,BER,BET,B92,B28,BE8,BE9,BE6,4BE,B21,BEP,RG6,BEO,1BS,6BI,BI3,BI7,BH5,BIA,BIQ,BI1,BI4,B58,BJ2,BL7,BLM,B36,BL1,BE0,LF0,BL8,BS9,B69,BOJ,BOD,BO7,BO6,BP8,BON,BO3,BO9,B50,BR0}'::text[]))
Planning time : 1.442 ms
Execution time : 84,854.698 ms