explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U6jy

Settings
# exclusive inclusive rows x rows loops node
1. 4.808 10,974.536 ↓ 0.0 0 1

Update on ar_payment_images (cost=273,154.41..2,790,806.18 rows=6,487,194 width=768) (actual time=10,974.536..10,974.536 rows=0 loops=1)

2. 9,293.443 10,969.728 ↑ 6,487,194.0 1 1

Bitmap Heap Scan on ar_payment_images (cost=273,154.41..2,790,806.18 rows=6,487,194 width=768) (actual time=10,969.115..10,969.728 rows=1 loops=1)

  • Recheck Cond: (lock_number IS NOT NULL)
  • Filter: ((endorsed_on IS NULL) AND ((locked_on IS NULL) OR (locked_on < (now() - '01:00:00'::interval))))
  • Rows Removed by Filter: 14,692,788
  • Heap Blocks: exact=1,162,635
3. 1,676.285 1,676.285 ↓ 1.0 14,692,789 1

Bitmap Index Scan on idx_ar_payment_images_lock_number (cost=0.00..271,532.61 rows=14,690,673 width=0) (actual time=1,676.285..1,676.285 rows=14,692,789 loops=1)

  • Index Cond: (lock_number IS NOT NULL)
Planning time : 0.674 ms
Execution time : 10,980.782 ms