explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0L2X

Settings
# exclusive inclusive rows x rows loops node
1. 27.315 190,721.804 ↑ 1.0 1 1

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

2. 244.015 190,694.489 ↓ 89.0 47,334 1

Hash Join (cost=4,492.28..60,082.91 rows=532 width=4) (actual time=5,458.512..190,694.489 rows=47,334 loops=1)

  • Hash Cond: (t2.cve_id = t1.id)
3. 114.420 189,115.432 ↓ 9.4 625,791 1

Nested Loop (cost=1,247.51..56,583.59 rows=66,462 width=8) (actual time=218.738..189,115.432 rows=625,791 loops=1)

4. 0.076 0.076 ↓ 18.0 18 1

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

  • Filter: (((NOT soft_delete) OR (soft_delete IS NULL)) AND ((customer_id = 2) OR (customer_id = '-1'::integer)))
5. 186,313.806 189,000.936 ↑ 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=182.924..10,500.052 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. 2,687.130 2,687.130 ↑ 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=149.285..149.285 rows=34,766 loops=18)

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

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

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

Seq Scan on nvd_cve t1 (cost=0.00..3,232.51 rows=981 width=4) (actual time=87.064..1,334.005 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 : 231.719 ms
Execution time : 190,750.558 ms