explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bfT5

Settings
# exclusive inclusive rows x rows loops node
1. 0.155 247.674 ↑ 1.0 1 1

Aggregate (cost=1,747,641.12..1,747,641.13 rows=1 width=32) (actual time=247.674..247.674 rows=1 loops=1)

2. 0.099 247.519 ↑ 3.3 1,193 1

Nested Loop (cost=0.43..1,747,631.24 rows=3,949 width=8) (actual time=0.179..247.519 rows=1,193 loops=1)

3. 48.956 48.956 ↓ 1.1 448 1

Seq Scan on part part (cost=0..14,193 rows=395 width=4) (actual time=0.085..48.956 rows=448 loops=1)

  • Filter: ((p_brand = 'Brand#35'::bpchar) AND (p_container = 'MED DRUM'::bpchar))
4. 13.188 198.464 ↑ 3.7 3 448

Index Scan using lineitem_pkey_sdate on lineitem lineitem (cost=0.43..4,388.34 rows=11 width=17) (actual time=0.151..0.443 rows=3 loops=448)

  • Index Cond: (l_partkey = part.p_partkey)
  • Filter: (l_quantity < (SubPlan 1))
5.          

SubPlan (for Index Scan)

6. 52.936 185.276 ↑ 1.0 1 13,234

Aggregate (cost=133.07..133.09 rows=1 width=32) (actual time=0.014..0.014 rows=1 loops=13,234)

7. 132.340 132.340 ↑ 1.0 31 13,234

Index Scan using lineitem_pkey_sdate on lineitem lineitem_1 (cost=0.43..132.99 rows=32 width=5) (actual time=0.001..0.01 rows=31 loops=13,234)

  • Index Cond: (l_partkey = part.p_partkey)
Planning time : 0.311 ms
Execution time : 247.719 ms