explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bcrp

Settings
# exclusive inclusive rows x rows loops node
1. 17.098 107.882 ↓ 1.0 27,523 1

Hash Join (cost=2,823.95..3,637.65 rows=27,521 width=74) (actual time=58.958..107.882 rows=27,523 loops=1)

  • Hash Cond: ((pac.cid = ac.cid) AND (pac.ar_code_id = ac.id))
2. 32.176 32.176 ↓ 1.0 27,523 1

Seq Scan on property_ar_codes pac (cost=0.00..669.21 rows=27,521 width=74) (actual time=0.032..32.176 rows=27,523 loops=1)

3. 11.730 58.608 ↑ 1.2 48,478 1

Hash (cost=1,963.58..1,963.58 rows=57,358 width=8) (actual time=58.608..58.608 rows=48,478 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2406kB
4. 46.878 46.878 ↑ 1.2 48,478 1

Seq Scan on ar_codes ac (cost=0.00..1,963.58 rows=57,358 width=8) (actual time=0.019..46.878 rows=48,478 loops=1)