explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zTy

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 0.095 ↓ 2.0 2 1

Sort (cost=29.82..29.82 rows=1 width=244) (actual time=0.093..0.095 rows=2 loops=1)

  • Sort Key: pc.createddatetimeutc
  • Sort Method: quicksort Memory: 25kB
2. 0.018 0.078 ↓ 2.0 2 1

Hash Join (cost=14.47..29.81 rows=1 width=244) (actual time=0.072..0.078 rows=2 loops=1)

  • Hash Cond: (((pc.groupid)::text = (pricechecks.groupid)::text) AND (pc.createddatetimeutc = (max(pricechecks.createddatetimeutc))))
3. 0.014 0.014 ↑ 70.0 5 1

Seq Scan on pricechecks pc (cost=0.00..13.50 rows=350 width=204) (actual time=0.010..0.014 rows=5 loops=1)

4. 0.006 0.046 ↑ 1.0 2 1

Hash (cost=14.44..14.44 rows=2 width=40) (actual time=0.046..0.046 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.011 0.040 ↓ 1.5 3 1

GroupAggregate (cost=14.38..14.42 rows=2 width=40) (actual time=0.035..0.040 rows=3 loops=1)

  • Group Key: pricechecks.groupid
6. 0.022 0.029 ↓ 2.5 5 1

Sort (cost=14.38..14.39 rows=2 width=40) (actual time=0.027..0.029 rows=5 loops=1)

  • Sort Key: pricechecks.groupid
  • Sort Method: quicksort Memory: 25kB
7. 0.007 0.007 ↓ 2.5 5 1

Seq Scan on pricechecks (cost=0.00..14.38 rows=2 width=40) (actual time=0.003..0.007 rows=5 loops=1)

  • Filter: (tripnumber = 1)