explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gEyiO

Settings
# exclusive inclusive rows x rows loops node
1. 0.280 0.690 ↑ 5.4 37 1

GroupAggregate (cost=1,328.68..1,337.80 rows=200 width=64) (actual time=0.470..0.690 rows=37 loops=1)

  • Group Key: gswaflat."CollarId", gswaflat."FromDepth", gswaflat."CompanySampleId", gswaflat."ToDepth", gswaflat."CompanyHoleID", gswaflat."Anumber
2. 0.156 0.410 ↑ 8.9 37 1

Sort (cost=1,328.68..1,329.50 rows=331 width=43) (actual time=0.405..0.410 rows=37 loops=1)

  • Sort Key: gswaflat."FromDepth", gswaflat."CompanySampleId", gswaflat."ToDepth", gswaflat."CompanyHoleID", gswaflat."Anumber
  • Sort Method: quicksort Memory: 27kB
3. 0.011 0.254 ↑ 8.9 37 1

Subquery Scan on gswaflat (cost=1,308.20..1,314.82 rows=331 width=43) (actual time=0.218..0.254 rows=37 loops=1)

4. 0.108 0.243 ↑ 8.9 37 1

HashAggregate (cost=1,308.20..1,311.51 rows=331 width=47) (actual time=0.215..0.243 rows=37 loops=1)

  • Group Key: gswa_dh_assay."CompanySampleId", gswa_dh_assay."hValue", gswa_dh_assay."hAnalyte", gswa_dh_assay."FromDepth", gswa_dh_assay."ToDepth", gswa_dh_assay."CompanyHoleID", gswa_dh_assay."Anumber", gswa_dh_assay."CollarId
5. 0.135 0.135 ↑ 8.9 37 1

Index Scan using gswa_dh_assay_indx_collarid on gswa_dh_assay (cost=0.43..1,300.75 rows=331 width=43) (actual time=0.103..0.135 rows=37 loops=1)

  • Index Cond: ("CollarId" = 4,510,547)
Planning time : 1.308 ms