explain.depesz.com

PostgreSQL's explain analyze made readable

Result: emkw

Settings
# exclusive inclusive rows x rows loops node
1. 26.969 206,142.881 ↑ 1.0 1 1

Aggregate (cost=60,084.24..60,084.25 rows=1 width=4) (actual time=206,142.881..206,142.881 rows=1 loops=1)

2. 249.654 206,115.912 ↓ 89.0 47,334 1

Hash Join (cost=4,492.28..60,082.91 rows=532 width=4) (actual time=6,429.835..206,115.912 rows=47,334 loops=1)

  • Hash Cond: (t2.cve_id = t1.id)
3. 114.224 203,905.411 ↓ 9.4 625,791 1

Nested Loop (cost=1,247.51..56,583.59 rows=66,462 width=8) (actual time=423.500..203,905.411 rows=625,791 loops=1)

4. 51.815 51.815 ↓ 18.0 18 1

Seq Scan on recommendation_summary (cost=0.00..1.27 rows=1 width=8) (actual time=51.745..51.815 rows=18 loops=1)

  • Filter: (((NOT soft_delete) OR (soft_delete IS NULL)) AND ((customer_id = 2) OR (customer_id = '-1'::integer)))
5. 200,694.870 203,739.372 ↑ 1.9 34,766 18

Bitmap Heap Scan on device_recommendation_details t2 (cost=1,247.51..55,917.70 rows=66,462 width=8) (actual time=196.437..11,318.854 rows=34,766 loops=18)

  • Recheck Cond: (recommendation_id = recommendation_summary.recommendation_id)
  • Filter: (((NOT soft_delete) OR (soft_delete IS NULL)) AND ((customer_id = 2) OR (customer_id = '-1'::integer)))
  • Heap Blocks: exact=129588
6. 3,044.502 3,044.502 ↑ 1.9 34,766 18

Bitmap Index Scan on device_recommendation_details_rec_id_idx (cost=0.00..1,230.89 rows=66,462 width=0) (actual time=169.139..169.139 rows=34,766 loops=18)

  • Index Cond: (recommendation_id = recommendation_summary.recommendation_id)
7. 0.647 1,960.847 ↓ 3.5 3,473 1

Hash (cost=3,232.51..3,232.51 rows=981 width=4) (actual time=1,960.847..1,960.847 rows=3,473 loops=1)

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 155kB
8. 1,960.200 1,960.200 ↓ 3.5 3,473 1

Seq Scan on nvd_cve t1 (cost=0.00..3,232.51 rows=981 width=4) (actual time=152.416..1,960.200 rows=3,473 loops=1)

  • Filter: (((NOT soft_delete) OR (soft_delete IS NULL)) AND (lower(cve) ~~ '%2019%'::text))
  • Rows Removed by Filter: 119094
Planning time : 335.026 ms
Execution time : 206,164.694 ms