explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I2rZ

Settings
# exclusive inclusive rows x rows loops node
1. 3.100 4.668 ↑ 1.0 779 1

Sort (cost=449.73..451.70 rows=789 width=233) (actual time=4.040..4.668 rows=779 loops=1)

  • Sort Key: tree_id, lft
  • Sort Method: quicksort Memory: 389kB
2. 1.514 1.568 ↑ 1.0 779 1

Bitmap Heap Scan on article (cost=22.90..411.76 rows=789 width=233) (actual time=0.079..1.568 rows=779 loops=1)

  • Recheck Cond: ((region_id = 122) OR (region_id IS NULL))
  • Filter: (published AND show_on_sidebar AND ((language_id)::text = 'ru'::text))
  • Rows Removed by Filter: 12
  • Heap Blocks: exact=202
3. 0.002 0.054 ↓ 0.0 0 1

BitmapOr (cost=22.90..22.90 rows=791 width=0) (actual time=0.054..0.054 rows=0 loops=1)

4. 0.048 0.048 ↑ 1.0 781 1

Bitmap Index Scan on article_region_id_dcea291c (cost=0.00..18.14 rows=781 width=0) (actual time=0.047..0.048 rows=781 loops=1)

  • Index Cond: (region_id = 122)
5. 0.004 0.004 ↑ 1.0 10 1

Bitmap Index Scan on article_region_id_dcea291c (cost=0.00..4.36 rows=10 width=0) (actual time=0.003..0.004 rows=10 loops=1)

  • Index Cond: (region_id IS NULL)