explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3Gbv

Settings
# exclusive inclusive rows x rows loops node
1. 0.900 144.026 ↓ 179.0 358 1

Sort (cost=13,906.75..13,906.76 rows=2 width=51) (actual time=144.01..144.026 rows=358 loops=1)

  • Sort Key: supplier.s_name
  • Sort Method: quicksort Memory: 66kB
2. 0.594 143.126 ↓ 179.0 358 1

Hash Join (cost=13,210.37..13,906.74 rows=2 width=51) (actual time=137.336..143.126 rows=358 loops=1)

3. 3.231 142.517 ↓ 152.6 8,696 1

Hash Join (cost=13,209.05..13,905.18 rows=57 width=55) (actual time=137.298..142.517 rows=8,696 loops=1)

4. 2.007 2.007 ↑ 1.0 20,000 1

Seq Scan on supplier supplier (cost=0..643 rows=20,000 width=59) (actual time=0.003..2.007 rows=20,000 loops=1)

5. 1.794 137.279 ↓ 199.5 11,370 1

Hash (cost=13,208.34..13,208.34 rows=57 width=4) (actual time=137.278..137.279 rows=11,370 loops=1)

6. 3.065 135.485 ↓ 199.5 11,370 1

Nested Loop (cost=11,280.86..13,208.34 rows=57 width=4) (actual time=26.854..135.485 rows=11,370 loops=1)

7. 2.712 27.795 ↓ 104.6 4,185 1

HashAggregate (cost=11,280.43..11,280.83 rows=40 width=4) (actual time=26.74..27.795 rows=4,185 loops=1)

  • Group Key: part.p_partkey
8. 1.715 25.083 ↓ 104.6 4,185 1

Gather (cost=1,000..11,280.33 rows=40 width=4) (actual time=0.207..25.083 rows=4,185 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
9. 23.368 23.368 ↓ 82.1 1,395 3 / 3

Seq Scan on part part (cost=0..10,276.33 rows=17 width=4) (actual time=0.037..23.368 rows=1,395 loops=3)

  • Filter: ((p_name)::text ~~ 'ivory%'::text)
10. 37.665 104.625 ↓ 3.0 3 4,185

Index Scan using partsupp_pkey_pavail on partsupp partsupp (cost=0.43..48.18 rows=1 width=8) (actual time=0.015..0.025 rows=3 loops=4,185)

  • Index Cond: (ps_partkey = part.p_partkey)
  • Filter: ((ps_availqty)::numeric > (SubPlan 1))
11.          

SubPlan (for Index Scan)

12. 0.000 66.960 ↑ 1.0 1 16,740

Aggregate (cost=8.59..8.6 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=16,740)

13. 66.960 66.960 ↑ 1.0 1 16,740

Index Scan using lineitem_pkey_shipd_skey on lineitem lineitem (cost=0.56..8.58 rows=1 width=5) (actual time=0.003..0.004 rows=1 loops=16,740)

  • Index Cond: ((l_partkey = partsupp.ps_partkey) AND (l_suppkey = partsupp.ps_suppkey) AND (l_shipdate >= '1997-01-01'::date) AND (l_shipdate < '1998-01-01'::date))
14. 0.006 0.015 ↑ 1.0 1 1

Hash (cost=1.31..1.31 rows=1 width=4) (actual time=0.015..0.015 rows=1 loops=1)

15. 0.009 0.009 ↑ 1.0 1 1

Seq Scan on nation nation (cost=0..1.31 rows=1 width=4) (actual time=0.007..0.009 rows=1 loops=1)

  • Filter: (n_name = 'INDIA'::bpchar)
Planning time : 0.545 ms
Execution time : 144.224 ms