explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YKhK

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 37,351.445 ↓ 0.0 0 1

Limit (cost=0.56..2,332.61 rows=25 width=16) (actual time=37,351.445..37,351.445 rows=0 loops=1)

2. 37,351.443 37,351.443 ↓ 0.0 0 1

Index Scan Backward using analysis_events_pkey on analysis_events (cost=0.56..1,489,995.81 rows=15,973 width=16) (actual time=37,351.443..37,351.443 rows=0 loops=1)

  • Filter: (result @> '[{"i": 5,860, "s": true}]'::jsonb)
  • Rows Removed by Filter: 16,013,688
Planning time : 0.157 ms
Execution time : 37,351.488 ms