explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jpcg

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 20,558.318 ↑ 5.5 4 1

Finalize GroupAggregate (cost=31,530.07..31,533.07 rows=22 width=248) (actual time=20,557.440..20,558.318 rows=4 loops=1)

  • Group Key: n1.n_name, n2.n_name, (date_part('year'::text, (lineitem.l_shipdate)::timestamp without time zone))
  • Buffers: shared hit=79290 read=8671
2. 0.000 20,601.576 ↑ 1.5 12 1

Gather Merge (cost=31,530.07..31,532.46 rows=18 width=248) (actual time=20,557.172..20,601.576 rows=12 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=207771 read=22418
3. 40.149 61,330.122 ↑ 2.2 4 3

Partial GroupAggregate (cost=30,530.04..30,530.36 rows=9 width=248) (actual time=20,442.703..20,443.374 rows=4 loops=3)

  • Group Key: n1.n_name, n2.n_name, (date_part('year'::text, (lineitem.l_shipdate)::timestamp without time zone))
  • Buffers: shared hit=207771 read=22418
4. 48.996 61,289.973 ↓ 38.1 343 3

Sort (cost=30,530.04..30,530.07 rows=9 width=228) (actual time=20,429.925..20,429.991 rows=343 loops=3)

  • Sort Key: n1.n_name, n2.n_name, (date_part('year'::text, (lineitem.l_shipdate)::timestamp without time zone))
  • Sort Method: quicksort Memory: 77kB
  • Buffers: shared hit=207771 read=22418
5. 55.224 61,240.977 ↓ 38.1 343 3

Hash Join (cost=384.38..30,529.90 rows=9 width=228) (actual time=634.844..20,413.659 rows=343 loops=3)

  • Hash Cond: (customer.c_nationkey = n2.n_nationkey)
  • Join Filter: (((n1.n_name = 'INDIA'::bpchar) AND (n2.n_name = 'FRANCE'::bpchar)) OR ((n1.n_name = 'FRANCE'::bpchar) AND (n2.n_name = 'INDIA'::bpchar)))
  • Rows Removed by Join Filter: 335
  • Buffers: shared hit=207737 read=22418
6. 58.223 61,184.427 ↓ 5.5 8,665 3

Nested Loop (cost=371.80..30,513.15 rows=1,574 width=128) (actual time=175.856..20,394.809 rows=8,665 loops=3)

  • Buffers: shared hit=207694 read=22418
7. 72.345 12,747.648 ↓ 5.5 8,665 3

Nested Loop (cost=371.38..29,799.86 rows=1,574 width=128) (actual time=143.888..4,249.216 rows=8,665 loops=3)

  • Buffers: shared hit=105055 read=20921
8. 160.494 10,101.699 ↓ 5.5 8,665 3

Hash Join (cost=370.96..28,669.13 rows=1,574 width=128) (actual time=143.559..3,367.233 rows=8,665 loops=3)

  • Hash Cond: (lineitem.l_suppkey = supplier.s_suppkey)
  • Buffers: shared hit=1136 read=20784
9. 9,569.130 9,569.130 ↑ 1.3 106,367 3

Parallel Seq Scan on lineitem (cost=0.00..27,780.60 rows=133,808 width=32) (actual time=15.380..3,189.710 rows=106,367 loops=3)

  • Filter: ((l_shipdate >= '1995-01-01'::date) AND (l_shipdate <= '1996-12-31'::date))
  • Rows Removed by Filter: 243158
  • Buffers: shared hit=671 read=20556
10. 3.705 372.075 ↓ 6.9 817 3

Hash (cost=369.48..369.48 rows=118 width=108) (actual time=124.025..124.025 rows=817 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 58kB
  • Buffers: shared hit=465 read=228
11. 19.395 368.370 ↓ 6.9 817 3

Hash Join (cost=12.58..369.48 rows=118 width=108) (actual time=0.411..122.790 rows=817 loops=3)

  • Hash Cond: (supplier.s_nationkey = n1.n_nationkey)
  • Buffers: shared hit=465 read=228
12. 348.765 348.765 ↑ 1.0 10,000 3

Seq Scan on supplier (cost=0.00..330.00 rows=10,000 width=12) (actual time=0.285..116.255 rows=10,000 loops=3)

  • Buffers: shared hit=462 read=228
13. 0.069 0.210 ↑ 1.0 2 3

Hash (cost=12.55..12.55 rows=2 width=108) (actual time=0.070..0.070 rows=2 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=3
14. 0.141 0.141 ↑ 1.0 2 3

Seq Scan on nation n1 (cost=0.00..12.55 rows=2 width=108) (actual time=0.031..0.047 rows=2 loops=3)

  • Filter: ((n_name = 'INDIA'::bpchar) OR (n_name = 'FRANCE'::bpchar))
  • Rows Removed by Filter: 23
  • Buffers: shared hit=3
15. 2,573.604 2,573.604 ↑ 1.0 1 25,996

Index Scan using orders_pkey on orders (cost=0.42..0.72 rows=1 width=12) (actual time=0.099..0.099 rows=1 loops=25,996)

  • Index Cond: (o_orderkey = lineitem.l_orderkey)
  • Buffers: shared hit=103919 read=137
16. 48,378.556 48,378.556 ↑ 1.0 1 25,996

Index Scan using customer_pkey on customer (cost=0.42..0.45 rows=1 width=12) (actual time=1.861..1.861 rows=1 loops=25,996)

  • Index Cond: (c_custkey = orders.o_custkey)
  • Buffers: shared hit=102639 read=1497
17. 0.093 1.326 ↑ 1.0 2 3

Hash (cost=12.55..12.55 rows=2 width=108) (actual time=0.442..0.442 rows=2 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=3
18. 1.233 1.233 ↑ 1.0 2 3

Seq Scan on nation n2 (cost=0.00..12.55 rows=2 width=108) (actual time=0.394..0.411 rows=2 loops=3)

  • Filter: ((n_name = 'FRANCE'::bpchar) OR (n_name = 'INDIA'::bpchar))
  • Rows Removed by Filter: 23
  • Buffers: shared hit=3