explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DVKE

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 454.158 ↑ 1.0 100 1

Limit (cost=1,000.57..1,868,440.71 rows=100 width=239) (actual time=1.031..454.158 rows=100 loops=1)

2. 11.390 474.025 ↑ 5.0 100 1

Gather (cost=1,000.57..9,412,898.87 rows=504 width=239) (actual time=1.029..474.025 rows=100 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.205 462.635 ↑ 5.8 36 3 / 3

Nested Loop (cost=0.56..9,411,848.47 rows=210 width=239) (actual time=16.224..462.635 rows=36 loops=3)

4. 68.003 68.003 ↑ 1.2 704 3 / 3

Parallel Seq Scan on jobitems ji (cost=0.00..9,404,691.60 rows=836 width=1,488) (actual time=0.635..68.003 rows=704 loops=3)

  • Filter: (((jobmetadata ->> 'zone'::text) = ANY ('{""South West"",""South Zone""}'::text[])) AND (to_date((jobmetadata ->> 'scheduledReadDate'::text), 'DD/MM/YYYY'::text) >= '2019-02-20'::date) AND (to_date((jobmetadata ->> 'scheduledReadDate'::text), 'DD/MM/YYYY'::text) <= '2019-04-30'::date))
  • Rows Removed by Filter: 23,632
5. 394.427 394.427 ↓ 0.0 0 2,113 / 3

Index Scan using unique_jobitemid on jobs j (cost=0.56..8.56 rows=1 width=63) (actual time=0.560..0.560 rows=0 loops=2,113)

  • Index Cond: (jobitemid = ji.id)
  • Filter: (jobstatuscode <> 'Released'::text)
  • Rows Removed by Filter: 1
Planning time : 0.254 ms