explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZsoV

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=1,000.49..9,921.96 rows=20 width=360) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=1,000.49..1,253,128.93 rows=2,807 width=360) (actual rows= loops=)

  • Workers Planned: 4
3. 0.000 0.000 ↓ 0.0

Parallel Index Scan Backward using logs_outbounds_posted on logs_outbounds (cost=0.43..1,251,794.53 rows=702 width=360) (actual rows= loops=)

  • Filter: (((posted >= '2020-08-01 16:39:05'::timestamp without time zone) AND ((context)::text ~~ '%7142757985'::text)) OR ((message_did)::text ~~ '%7142757985'::text) OR ((port)::text ~~ '7142757985%'::text))