explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OXib : OLD - 1

Settings
# exclusive inclusive rows x rows loops node
1. 0.410 6,656.111 ↑ 1.0 1 1

Aggregate (cost=201,058.66..201,058.67 rows=1 width=8) (actual time=6,656.110..6,656.111 rows=1 loops=1)

2. 236.689 6,655.701 ↑ 54.4 224 1

Nested Loop (cost=1,133.74..201,028.18 rows=12,193 width=0) (actual time=927.706..6,655.701 rows=224 loops=1)

3. 419.096 5,802.935 ↓ 1.6 56,007 1

Nested Loop (cost=1,133.32..184,099.85 rows=35,169 width=4) (actual time=110.328..5,802.935 rows=56,007 loops=1)

4. 1,819.939 1,917.794 ↓ 1.5 63,019 1

Bitmap Heap Scan on xfiler_tx (cost=1,132.89..57,264.87 rows=41,810 width=4) (actual time=110.112..1,917.794 rows=63,019 loops=1)

  • Recheck Cond: ((company_id = 2071) AND (NOT all_checked))
  • Filter: (NOT is_deleted)
  • Rows Removed by Filter: 1386
  • Heap Blocks: exact=46295
5. 97.855 97.855 ↓ 1.5 64,405 1

Bitmap Index Scan on xfiler_tx_all_checked2 (cost=0.00..1,122.43 rows=42,921 width=0) (actual time=97.855..97.855 rows=64,405 loops=1)

  • Index Cond: (company_id = 2071)
6. 3,466.045 3,466.045 ↑ 1.0 1 63,019

Index Scan using xfiler_checklist_tx_id_key on xfiler_checklist (cost=0.43..3.02 rows=1 width=8) (actual time=0.054..0.055 rows=1 loops=63,019)

  • Index Cond: (tx_id = xfiler_tx.id)
7. 616.077 616.077 ↓ 0.0 0 56,007

Index Only Scan using xfiler_checklistitemextra_opentask2 on xfiler_checklistitemextra (cost=0.42..0.47 rows=1 width=4) (actual time=0.011..0.011 rows=0 loops=56,007)

  • Index Cond: (checklist_id = xfiler_checklist.id)
  • Heap Fetches: 0