explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PHCs

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

Unique (cost=5,126.21..5,126.22 rows=1 width=15) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=5,126.21..5,126.22 rows=1 width=15) (actual rows= loops=)

  • Sort Key: job_head_new.b2x_job_number
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5,118.17..5,126.20 rows=1 width=15) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Unique (cost=5,117.88..5,117.89 rows=1 width=4) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Sort (cost=5,117.88..5,117.88 rows=1 width=4) (actual rows= loops=)

  • Sort Key: a.job_id
6. 0.000 0.000 ↓ 0.0

Seq Scan on job_detail_new a (cost=0.00..5,117.87 rows=1 width=4) (actual rows= loops=)

  • Filter: ((created_on >= '2011-11-11 00:00:00+05:30'::timestamp with time zone) AND (created_on <= '2011-11-11 00:00:00+05:30'::timestamp with time zone) AND (partner_id = ''::text) AND ((repair_status = ''::text) OR (repair_status = '$38'::text)))
7. 0.000 0.000 ↓ 0.0

Index Scan using job_head_new_pkey on job_head_new (cost=0.29..8.31 rows=1 width=19) (actual rows= loops=)

  • Index Cond: (id = a.job_id)