explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JiE3

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 52.601 ↑ 1.0 1 1

Aggregate (cost=21,829.92..21,829.93 rows=1 width=32) (actual time=52.601..52.601 rows=1 loops=1)

2. 3.777 53.872 ↓ 1.5 3 1

Gather (cost=21,829.69..21,829.9 rows=2 width=32) (actual time=52.503..53.872 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.077 50.095 ↑ 1.0 1 3 / 3

Aggregate (cost=20,829.69..20,829.7 rows=1 width=32) (actual time=50.095..50.095 rows=1 loops=3)

4. 0.513 50.018 ↑ 1.2 80 3 / 3

Nested Loop (cost=0.56..20,828.98 rows=95 width=12) (actual time=0.725..50.018 rows=80 loops=3)

5. 42.238 42.238 ↑ 1.2 330 3 / 3

Seq Scan on part part (cost=0..15,276.33 rows=399 width=30) (actual time=0.136..42.238 rows=330 loops=3)

  • Filter: ((p_size >= 1) AND (((p_brand = 'Brand#33'::bpchar) AND (p_container = ANY ('{"SM CASE","SM BOX","SM PACK","SM PKG"}'::bpchar[])) AND (p_size <= 5)) OR ((p_brand = 'Brand#52'::bpchar) AND (p_container = ANY ('{"MED BAG","MED BOX","MED PKG","MED PACK"}'::bpchar[])) AND (p_size <= 10)) OR ((p_brand = 'Brand#15'::bpchar) AND (p_container = ANY ('{"LG CASE","LG BOX","LG PACK","LG PKG"}'::bpchar[])) AND (p_size <= 15))))
6. 7.267 7.267 ↓ 0.0 0 991 / 3

Index Scan using lineitem_key_qant_shipm_shipi on lineitem lineitem (cost=0.56..13.91 rows=1 width=21) (actual time=0.021..0.022 rows=0 loops=991)

  • Index Cond: ((l_partkey = part.p_partkey) AND (l_shipmode = ANY ('{AIR,"AIR REG"}'::bpchar[])) AND (l_shipinstruct = 'DELIVER IN PERSON'::bpchar))
  • Filter: ((((l_quantity >= '9'::numeric) AND (l_quantity <= '19'::numeric)) OR ((l_quantity >= '20'::numeric) AND (l_quantity <= '30'::numeric)) OR ((l_quantity >= '30'::numeric) AND (l_quantity <= '40'::numeric))) AND (((part.p_brand = 'Brand#33'::bpchar) AND (part.p_container = ANY ('{"SM CASE","SM BOX","SM PACK","SM PKG"}'::bpchar[])) AND (l_quantity >= '9'::numeric) AND (l_quantity <= '19'::numeric) AND (part.p_size <= 5)) OR ((part.p_brand = 'Brand#52'::bpchar) AND (part.p_container = ANY ('{"MED BAG","MED BOX","MED PKG","MED PACK"}'::bpchar[])) AND (l_quantity >= '20'::numeric) AND (l_quantity <= '30'::numeric) AND (part.p_size <= 10)) OR ((part.p_brand = 'Brand#15'::bpchar) AND (part.p_container = ANY ('{"LG CASE","LG BOX","LG PACK","LG PKG"}'::bpchar[])) AND (l_quantity >= '30'::numeric) AND (l_quantity <= '40'::numeric) AND (part.p_size <= 15))))
Planning time : 0.508 ms
Execution time : 53.938 ms