explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zfu7

Settings
# exclusive inclusive rows x rows loops node
1. 229.014 4,424.067 ↑ 15.7 1,179 1

Hash Join (cost=65,525.20..86,491.38 rows=18,472 width=615) (actual time=3,275.478..4,424.067 rows=1,179 loops=1)

  • Hash Cond: (items.published_version_id = item_versions.id)
2. 930.246 930.246 ↑ 1.0 1,200,440 1

Seq Scan on items (cost=0.00..20,326.77 rows=1,217,923 width=105) (actual time=0.013..930.246 rows=1,200,440 loops=1)

3. 58.460 3,264.807 ↑ 1.0 41,870 1

Hash (cost=65,372.01..65,372.01 rows=43,768 width=510) (actual time=3,264.807..3,264.807 rows=41,870 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 47777kB
4. 3,199.680 3,206.347 ↑ 1.0 41,870 1

Bitmap Heap Scan on item_versions (cost=466.19..65,372.01 rows=43,768 width=510) (actual time=10.069..3,206.347 rows=41,870 loops=1)

  • Recheck Cond: (item_type_id = 111455)
  • Heap Blocks: exact=21022
5. 6.667 6.667 ↑ 1.0 41,959 1

Bitmap Index Scan on foo (cost=0.00..464.00 rows=43,768 width=0) (actual time=6.667..6.667 rows=41,959 loops=1)

Planning time : 1.128 ms
Execution time : 4,427.536 ms