explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IUNm

Settings
# exclusive inclusive rows x rows loops node
1. 13.876 4,351.309 ↑ 3.5 2 1

GroupAggregate (cost=10,001,195,786.28..10,001,196,940.15 rows=7 width=27) (actual time=4,341.302..4,351.309 rows=2 loops=1)

  • Group Key: lineitem.l_shipmode
2. 23.158 4,337.433 ↓ 1.1 62,538 1

Sort (cost=10,001,195,786.28..10,001,195,930.51 rows=57,690 width=27) (actual time=4,331.034..4,337.433 rows=62,538 loops=1)

  • Sort Key: lineitem.l_shipmode
  • Sort Method: external merge Disk: 2,272kB
3. 255.288 4,314.275 ↓ 1.1 62,538 1

Hash Join (cost=10,000,137,265.56..10,001,191,224.15 rows=57,690 width=27) (actual time=929.025..4,314.275 rows=62,538 loops=1)

4. 3,130.769 3,130.769 ↓ 1.1 62,538 1

Index Scan using lineitem_key_shipm_cdate_rdate_sdate on lineitem lineitem (cost=0.56..1,034,878.68 rows=57,690 width=15) (actual time=0.196..3,130.769 rows=62,538 loops=1)

  • Filter: ((l_shipmode = ANY ('{MAIL,RAIL}'::bpchar[])) AND (l_commitdate < l_receiptdate) AND (l_shipdate < l_commitdate) AND (l_receiptdate >= '1993-01-01'::date) AND (l_receiptdate < '1994-01-01 00:00:00'::timestamp without time zone))
5. 494.164 928.218 ↑ 1.0 3,000,000 1

Hash (cost=10,000,082,186..10,000,082,186 rows=3,000,000 width=20) (actual time=928.218..928.218 rows=3,000,000 loops=1)

6. 434.054 434.054 ↑ 1.0 3,000,000 1

Seq Scan on orders orders (cost=10,000,000,000..10,000,082,186 rows=3,000,000 width=20) (actual time=0.005..434.054 rows=3,000,000 loops=1)

Planning time : 0.176 ms
Execution time : 4,351.823 ms