explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dme7

Settings
# exclusive inclusive rows x rows loops node
1. 22.790 73.077 ↓ 586.4 53,948 1

Nested Loop (cost=18.50..37,348.42 rows=92 width=56) (actual time=6.905..73.077 rows=53,948 loops=1)

2. 1.420 7.138 ↓ 14.8 757 1

Nested Loop (cost=17.94..2,553.66 rows=51 width=26) (actual time=0.337..7.138 rows=757 loops=1)

3. 0.446 2.730 ↓ 10.9 996 1

Nested Loop (cost=17.52..2,234.03 rows=91 width=24) (actual time=0.328..2.730 rows=996 loops=1)

4. 0.003 0.023 ↑ 1.0 1 1

Nested Loop (cost=0.58..16.63 rows=1 width=16) (actual time=0.020..0.023 rows=1 loops=1)

5. 0.012 0.012 ↑ 1.0 1 1

Index Scan using screen_site_id_idx on screen (cost=0.29..8.31 rows=1 width=16) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: (site_id = 24661)
  • Filter: active
6. 0.008 0.008 ↑ 1.0 1 1

Index Scan using object_pkey on site (cost=0.29..8.31 rows=1 width=8) (actual time=0.007..0.008 rows=1 loops=1)

  • Index Cond: (id = 24661)
  • Filter: active
7. 2.102 2.261 ↓ 2.0 996 1

Bitmap Heap Scan on proposal_item_screen (cost=16.94..2,212.39 rows=501 width=24) (actual time=0.306..2.261 rows=996 loops=1)

  • Recheck Cond: (screen_id = screen.id)
  • Filter: active
  • Rows Removed by Filter: 196
  • Heap Blocks: exact=1185
8. 0.159 0.159 ↓ 2.0 1,192 1

Bitmap Index Scan on proposal_item_screen_screen_id_pi_id_idx (cost=0.00..16.81 rows=584 width=0) (actual time=0.159..0.159 rows=1,192 loops=1)

  • Index Cond: (screen_id = screen.id)
9. 2.988 2.988 ↑ 1.0 1 996

Index Scan using proposal_package_pkey on proposal_item (cost=0.42..3.50 rows=1 width=10) (actual time=0.003..0.003 rows=1 loops=996)

  • Index Cond: (id = proposal_item_screen.proposal_item_id)
  • Filter: (active AND (status = ANY ('{11,10,3,14}'::integer[])))
  • Rows Removed by Filter: 0
10. 43.149 43.149 ↑ 1.8 71 757

Index Scan using proposal_item_screen_external_schedule_pis_id_idx on proposal_item_screen_external_schedule (cost=0.56..680.96 rows=129 width=46) (actual time=0.015..0.057 rows=71 loops=757)

  • Index Cond: (proposal_item_screen_id = proposal_item_screen.id)
  • Filter: (end_date >= '2019-09-09'::date)
  • Rows Removed by Filter: 28
Planning time : 0.759 ms
Execution time : 82.402 ms