explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Apnr

Settings
# exclusive inclusive rows x rows loops node
1. 0.877 58,077.815 ↑ 1.0 1,000 1

Limit (cost=18.71..371,230.24 rows=1,000 width=476) (actual time=22.541..58,077.815 rows=1,000 loops=1)

2. 7.331 58,076.938 ↑ 3.9 1,000 1

Nested Loop Anti Join (cost=18.71..1,456,652.76 rows=3,924 width=476) (actual time=22.541..58,076.938 rows=1,000 loops=1)

3. 87.770 58,027.667 ↑ 3.3 1,398 1

Nested Loop (cost=18.29..1,432,378.76 rows=4,639 width=476) (actual time=22.507..58,027.667 rows=1,398 loops=1)

4. 8.339 17.961 ↑ 1,244.4 1,398 1

Hash Join (cost=18.15..710,438.46 rows=1,739,602 width=472) (actual time=0.231..17.961 rows=1,398 loops=1)

  • Hash Cond: ((parcel_declaration.lut_version = b.version) AND (parcel_declaration.snar_code = b.ori_crop))
5. 9.407 9.407 ↑ 1,167.4 2,179 1

Seq Scan on parcel_declaration (cost=0.00..667,738.76 rows=2,543,811 width=468) (actual time=0.008..9.407 rows=2,179 loops=1)

  • Filter: (reference_timestamp = '2019-06-20 00:00:00'::timestamp without time zone)
6. 0.052 0.215 ↑ 1.0 305 1

Hash (cost=13.57..13.57 rows=305 width=12) (actual time=0.215..0.215 rows=305 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 22kB
7. 0.163 0.163 ↑ 1.0 305 1

Seq Scan on lut b (cost=0.00..13.57 rows=305 width=12) (actual time=0.006..0.163 rows=305 loops=1)

  • Filter: (flag = 0)
  • Rows Removed by Filter: 141
8. 57,921.936 57,921.936 ↑ 1.0 1 1,398

Index Scan using hpg_gidx on hpg c (cost=0.14..0.41 rows=1 width=36) (actual time=29.883..41.432 rows=1 loops=1,398)

  • Index Cond: (geometry ~ st_centroid(parcel_declaration.geometry))
  • Filter: _st_contains(geometry, st_centroid(parcel_declaration.geometry))
  • Rows Removed by Filter: 2
9. 41.940 41.940 ↓ 0.0 0 1,398

Index Only Scan using small_parcels_idx on small_parcels s (cost=0.43..5.23 rows=1 width=12) (actual time=0.030..0.030 rows=0 loops=1,398)

  • Index Cond: ((parcel_id = parcel_declaration.parcel_id) AND (reference_timestamp = parcel_declaration.reference_timestamp) AND (reference_timestamp = '2019-06-20 00:00:00'::timestamp without time zone))
  • Heap Fetches: 398