explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5es4

Settings
# exclusive inclusive rows x rows loops node
1. 0.098 21,638.183 ↓ 2.5 100 1

Limit (cost=26,397.93..36,405.23 rows=40 width=224) (actual time=690.125..21,638.183 rows=100 loops=1)

2. 21,276.005 21,638.085 ↓ 2.5 100 1

Nested Loop (cost=26,397.93..36,405.23 rows=40 width=224) (actual time=690.123..21,638.085 rows=100 loops=1)

  • Join Filter: ((broker.inputs -> 'req_uid'::text) = (broker_1.inputs -> 'req_uid'::text))
  • Rows Removed by Join Filter: 15586525
3. 362.080 362.080 ↓ 35.5 7,961 1

Bitmap Heap Scan on broker broker_1 (cost=11,705.79..12,586.46 rows=224 width=127) (actual time=146.694..362.080 rows=7,961 loops=1)

  • Recheck Cond: ((outputs @> '{"strategy_type": "diagnostic"}'::jsonb) AND ((type)::text = 'locus_sauron.brokers.select_strategy.SelectReportAssayStrategyBroker'::text))
  • Rows Removed by Index Recheck: 75996
  • Heap Blocks: exact=1899 lossy=4081
  • Recheck Cond: ((outputs @> '{"strategy_type": "diagnostic"}'::jsonb) AND ((type)::text = 'locus_sauron.brokers
  • Rows Removed by Index Recheck: 75996
  • Heap Blocks: exact=1899 lossy=4081