explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ViHq

Settings
# exclusive inclusive rows x rows loops node
1. 44.032 236.273 ↓ 8,389.0 8,389 1

Sort (cost=54,506.88..54,506.88 rows=1 width=301) (actual time=222.714..236.273 rows=8,389 loops=1)

  • Sort Key: component_auction.created_date
  • Sort Method: external sort Disk: 2576kB
2. 44.408 192.241 ↓ 8,389.0 8,389 1

Nested Loop (cost=1,374.36..54,506.87 rows=1 width=301) (actual time=38.504..192.241 rows=8,389 loops=1)

3. 2.026 97.499 ↓ 8,389.0 8,389 1

Gather (cost=1,373.93..54,500.03 rows=1 width=233) (actual time=38.487..97.499 rows=8,389 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 18.281 95.473 ↓ 2,796.0 2,796 3

Nested Loop (cost=373.93..53,499.93 rows=1 width=233) (actual time=18.305..95.473 rows=2,796 loops=3)

5. 12.600 77.100 ↓ 2.2 157 3

Nested Loop (cost=373.37..39,468.88 rows=70 width=229) (actual time=13.408..77.100 rows=157 loops=3)

6. 2.366 64.490 ↓ 1.6 834 3

Hash Left Join (cost=372.94..31,452.33 rows=522 width=221) (actual time=12.635..64.490 rows=834 loops=3)

  • Hash Cond: (enquiry.id = booking.enquiry_id)
  • Filter: ((booking.id IS NULL) OR ((booking.status)::text <> 'confirmed'::text))
  • Rows Removed by Filter: 1
7. 9.220 61.238 ↑ 1.7 835 3

Nested Loop (cost=303.09..31,373.70 rows=1,402 width=221) (actual time=11.679..61.238 rows=835 loops=3)

8. 42.220 52.010 ↑ 1.7 843 3

Parallel Bitmap Heap Scan on component (cost=302.67..20,274.07 rows=1,448 width=217) (actual time=11.662..52.010 rows=843 loops=3)

  • Recheck Cond: ((component_type = 'job'::component_entity_type) AND (status = 'allocated'::component_status))
  • Filter: (active AND ((allocation_type = 'manual'::allocation_type) OR (allocation_type IS NULL)) AND (pm_id = ANY ('{308,301,176,184,135,12,76,93,109,162,319,366,339,187,58,84,91,334,186,605,477,514,258,558,311,905,338,209,219,44,214,136,130}'::integer[])))
  • Rows Removed by Filter: 663
  • Heap Blocks: exact=3541
9. 9.790 9.790 ↓ 3.3 17,420 1

Bitmap Index Scan on component_status_type (cost=0.00..301.80 rows=5,337 width=0) (actual time=9.790..9.790 rows=17,420 loops=1)

  • Index Cond: ((component_type = 'job'::component_entity_type) AND (status = 'allocated'::component_status))
10. 0.008 0.008 ↑ 1.0 1 2,529

Index Scan using enquiry_pkey on enquiry (cost=0.43..7.67 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=2,529)

  • Index Cond: (id = component.enquiry_id)
  • Filter: active
  • Rows Removed by Filter: 0
11. 0.382 0.886 ↓ 1.0 666 3

Hash (cost=61.61..61.61 rows=659 width=17) (actual time=0.886..0.886 rows=666 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 41kB
12. 0.504 0.504 ↓ 1.0 666 3

Seq Scan on booking (cost=0.00..61.61 rows=659 width=17) (actual time=0.011..0.504 rows=666 loops=3)

  • Filter: active
  • Rows Removed by Filter: 2
13. 0.010 0.010 ↓ 0.0 0 2,503

Index Scan using component_detail_component_id_idx on component_detail (cost=0.43..15.35 rows=1 width=8) (actual time=0.010..0.010 rows=0 loops=2,503)

  • Index Cond: (component_id = component.id)
  • Filter: (active AND (wb_user_id IS NULL) AND (process_service_mapping_id <> ALL ('{227,251,593,510,573,591,215,594,583,599,600,719,725,622,571,356,585,576,481,601,829,186,736,602,743,750,191,587,361,491,42,589,6,24,47,91,102,111,107,159,169,180,199,207,274,258,241,223,269,263,281,291,305,286,298,346,321,334,365,378,430,434,438,442,447,452,457,425,503}'::integer[])))
  • Rows Removed by Filter: 1
14. 0.092 0.092 ↓ 18.0 18 470

Index Scan using component_auction_component_detail_id_idx on component_auction (cost=0.56..200.43 rows=1 width=12) (actual time=0.011..0.092 rows=18 loops=470)

  • Index Cond: (component_detail_id = component_detail.id)
  • Filter: (active AND (status <> 'rejected'::component_auction_status) AND (last_modified_date > '2019-05-10 04:50:40'::timestamp without time zone) AND (status = 'pending'::component_auction_status))
  • Rows Removed by Filter: 3
15. 50.334 50.334 ↑ 1.0 1 8,389

Index Scan using component_component_id_idx on component_extended (cost=0.43..6.81 rows=1 width=159) (actual time=0.004..0.006 rows=1 loops=8,389)

  • Index Cond: (component_id = component_detail.component_id)
  • Filter: (active AND active)
Planning time : 2.814 ms
Execution time : 240.740 ms