explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RRZ : jsonb estimation issue

options
# exclusive inclusive rows x rows loops node
1. 0.020 764.649 ↑ 1.0 25 1

Limit (cost=0.43..908.61 rows=25 width=4) (actual time=9.470..764.649 rows=25 loops=1)

2. 764.629 764.629 ↑ 400.0 25 1

Index Scan using doc_tags_json_doc_id_idx on doc_tags_json (cost=0.43..363,270.58 rows=10,000 width=4) (actual time=9.468..764.629 rows=25 loops=1)

  • Filter: (tags @> '["earth science"]'::jsonb)
  • Rows Removed by Filter: 2118982