explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WAm7

Settings
# exclusive inclusive rows x rows loops node
1. 0.115 16,466.668 ↑ 4,192.7 7 1

Sort (cost=1,449,644.88..1,449,718.25 rows=29,349 width=1,104) (actual time=16,466.665..16,466.668 rows=7 loops=1)

  • Sort Key: "userParcel"."createdAt" DESC
  • Sort Method: quicksort Memory: 39kB
  • Functions: 20
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 9.878 ms, Inlining 21.608 ms, Optimization 250.857 ms, Emission 146.165 ms, Total 428.507 ms
2. 3,193.393 16,466.553 ↑ 4,192.7 7 1

Hash Right Join (cost=14.57..1,437,362.04 rows=29,349 width=1,104) (actual time=3,529.340..16,466.553 rows=7 loops=1)

  • Hash Cond: (concat(perceel.kadastralegemeentecode, perceel.sectie, (perceel.perceelnummer)::character varying) = ("userParcel"."parcelId")::text)
3. 1,940.677 12,853.344 ↓ 1.0 8,048,998 1

Hash Join (cost=1.29..1,236,897.26 rows=8,046,605 width=431) (actual time=0.082..12,853.344 rows=8,048,998 loops=1)

  • Hash Cond: ((perceel.soortgrootte_code)::text = (soort_grootte.code)::text)
4. 10,912.649 10,912.649 ↓ 1.0 8,048,998 1

Seq Scan on perceel (cost=0.00..1,208,887.59 rows=8,046,605 width=401) (actual time=0.051..10,912.649 rows=8,048,998 loops=1)

5. 0.006 0.018 ↑ 1.0 13 1

Hash (cost=1.13..1.13 rows=13 width=44) (actual time=0.017..0.018 rows=13 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
6. 0.012 0.012 ↑ 1.0 13 1

Seq Scan on soort_grootte (cost=0.00..1.13 rows=13 width=44) (actual time=0.009..0.012 rows=13 loops=1)

7. 0.025 419.816 ↓ 1.2 7 1

Hash (cost=13.21..13.21 rows=6 width=601) (actual time=419.816..419.816 rows=7 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
8. 419.580 419.791 ↓ 1.2 7 1

Bitmap Heap Scan on "userParcel" (cost=2.32..13.21 rows=6 width=601) (actual time=419.706..419.791 rows=7 loops=1)

  • Recheck Cond: (("userAuth0Id")::text = 'auth0|5c1380d32c33c025f3aa70ac'::text)
  • Heap Blocks: exact=4
9. 0.211 0.211 ↓ 1.2 7 1

Bitmap Index Scan on "userParcel_pkey" (cost=0.00..2.32 rows=6 width=0) (actual time=0.211..0.211 rows=7 loops=1)

  • Index Cond: (("userAuth0Id")::text = 'auth0|5c1380d32c33c025f3aa70ac'::text)
Execution time : 16,477.118 ms