explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Zsc : Without facts index

Settings
# exclusive inclusive rows x rows loops node
1. 0.079 9.289 ↑ 1.9 119 1

Hash Join (cost=13.00..892.32 rows=226 width=133) (actual time=9.207..9.289 rows=119 loops=1)

  • Hash Cond: (f.fact_path_id = fp.id)
  • Buffers: shared hit=6 read=4
2. 0.031 9.078 ↑ 1.9 119 1

Bitmap Heap Scan on facts f (cost=6.18..881.83 rows=226 width=116) (actual time=9.061..9.078 rows=119 loops=1)

  • Recheck Cond: (factset_id = 1)
  • Heap Blocks: exact=4
  • Buffers: shared hit=4 read=4
3. 9.047 9.047 ↑ 1.9 119 1

Bitmap Index Scan on facts_factset_id_idx (cost=0.00..6.13 rows=226 width=0) (actual time=9.047..9.047 rows=119 loops=1)

  • Index Cond: (factset_id = 1)
  • Buffers: shared read=4
4. 0.080 0.132 ↑ 1.1 195 1

Hash (cost=4.14..4.14 rows=214 width=23) (actual time=0.132..0.132 rows=195 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
  • Buffers: shared hit=2
5. 0.052 0.052 ↑ 1.1 195 1

Seq Scan on fact_paths fp (cost=0.00..4.14 rows=214 width=23) (actual time=0.009..0.052 rows=195 loops=1)

  • Buffers: shared hit=2
Planning time : 0.373 ms
Execution time : 9.340 ms