explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VxVc

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 188.336 ↑ 1.0 18 1

Limit (cost=74,373.90..74,373.95 rows=18 width=821) (actual time=188.334..188.336 rows=18 loops=1)

  • Buffers: shared hit=45,971
2. 45.124 188.333 ↑ 2,354.1 18 1

Sort (cost=74,373.90..74,479.83 rows=42,373 width=821) (actual time=188.332..188.333 rows=18 loops=1)

  • Sort Key: reputation_day DESC, created DESC
  • Sort Method: top-N heapsort Memory: 67kB
  • Buffers: shared hit=45,971
3. 58.027 143.209 ↓ 1.1 48,579 1

WindowAgg (cost=303.98..73,278.58 rows=42,373 width=821) (actual time=108.610..143.209 rows=48,579 loops=1)

  • Buffers: shared hit=45,971
4. 56.148 85.182 ↓ 1.1 48,579 1

Bitmap Heap Scan on chart_main cm (cost=303.98..72,748.91 rows=42,373 width=813) (actual time=34.875..85.182 rows=48,579 loops=1)

  • Recheck Cond: ((language = 'en'::text) AND (tag && '{supplyanddemand,demandzone,supplyzone}'::text[]) AND is_public AND is_recommended AND (NOT is_published_script) AND (NOT is_education) AND is_hot)
  • Heap Blocks: exact=45,245
  • Buffers: shared hit=45,971
5. 29.034 29.034 ↓ 1.1 48,579 1

Bitmap Index Scan on chart_main_lang_tag_gin_idx1 (cost=0.00..293.38 rows=42,373 width=0) (actual time=29.034..29.034 rows=48,579 loops=1)

  • Index Cond: ((language = 'en'::text) AND (tag && '{supplyanddemand,demandzone,supplyzone}'::text[]))
  • Buffers: shared hit=726
Planning time : 1.661 ms