explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GG28

Settings
# exclusive inclusive rows x rows loops node
1. 5,047.819 5,049.784 ↓ 0.0 0 1

Update on facts (cost=69.37..73.39 rows=1 width=22) (actual time=5,049.784..5,049.784 rows=0 loops=1)

  • Buffers: shared hit=131636 read=436 dirtied=7661
2. 0.008 1.965 ↑ 1.0 1 1

Bitmap Heap Scan on facts (cost=69.37..73.39 rows=1 width=22) (actual time=1.963..1.965 rows=1 loops=1)

  • Recheck Cond: ((factset_id = 2466::bigint) AND (fact_path_id = 377::bigint))
  • Heap Blocks: exact=1
  • Buffers: shared hit=706
3. 0.023 1.957 ↓ 0.0 0 1

BitmapAnd (cost=69.37..69.37 rows=1 width=0) (actual time=1.957..1.957 rows=0 loops=1)

  • Buffers: shared hit=705
4. 0.073 0.073 ↑ 1.1 553 1

Bitmap Index Scan on facts_factset_id_idx (cost=0.00..17.02 rows=612 width=0) (actual time=0.073..0.073 rows=553 loops=1)

  • Index Cond: (factset_id = 2466::bigint)
  • Buffers: shared hit=5
5. 1.861 1.861 ↓ 10.3 10,552 1

Bitmap Index Scan on facts_fact_path_id_idx (cost=0.00..52.10 rows=1,022 width=0) (actual time=1.861..1.861 rows=10,552 loops=1)

  • Index Cond: (fact_path_id = 377::bigint)
  • Buffers: shared hit=700