explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U1XE

Settings
# exclusive inclusive rows x rows loops node
1. 121.139 645.296 ↓ 353.3 407,367 1

Nested Loop (cost=0.00..89,684.01 rows=1,153 width=4,146) (actual time=17.085..645.296 rows=407,367 loops=1)

2. 2.949 2.949 ↓ 3.0 9 1

Seq Scan on company c (cost=0.00..302.00 rows=3 width=1,557) (actual time=0.731..2.949 rows=9 loops=1)

  • Filter: ((name)::text ~ 'irbus'::text)
  • Rows Removed by Filter: 3982
3. 18.081 521.208 ↓ 4.5 45,263 9

Append (cost=0.00..29,693.97 rows=10,003 width=2,720) (actual time=8.581..57.912 rows=45,263 loops=9)

4. 0.000 0.000 ↓ 0.0 0 9

Seq Scan on reservation (cost=0.00..0.00 rows=1 width=2,176) (actual time=0.000..0.000 rows=0 loops=9)

  • Filter: (c.id = company_id)
5. 0.036 0.036 ↓ 0.0 0 9

Index Scan using be_reservation_company_id_idx on reservation reservation_1 (cost=0.41..1,930.50 rows=723 width=2,880) (actual time=0.004..0.004 rows=0 loops=9)

  • Index Cond: (company_id = c.id)
6. 0.000 0.036 ↓ 0.0 0 9

Bitmap Heap Scan on reservation reservation_2 (cost=306.26..10,697.47 rows=3,162 width=2,963) (actual time=0.004..0.004 rows=0 loops=9)

  • Recheck Cond: (company_id = c.id)
7. 0.036 0.036 ↓ 0.0 0 9

Bitmap Index Scan on de_reservation_company_id_idx (cost=0.00..305.47 rows=3,162 width=0) (actual time=0.004..0.004 rows=0 loops=9)

  • Index Cond: (company_id = c.id)
8. 457.668 502.947 ↓ 13.8 45,263 9

Bitmap Heap Scan on reservation reservation_3 (cost=217.80..11,582.28 rows=3,274 width=2,403) (actual time=8.505..55.883 rows=45,263 loops=9)

  • Recheck Cond: (company_id = c.id)
  • Heap Blocks: exact=180786
9. 45.279 45.279 ↓ 13.8 45,263 9

Bitmap Index Scan on fr_reservation_company_id_idx (cost=0.00..216.98 rows=3,274 width=0) (actual time=5.031..5.031 rows=45,263 loops=9)

  • Index Cond: (company_id = c.id)
10. 0.009 0.045 ↓ 0.0 0 9

Bitmap Heap Scan on reservation reservation_4 (cost=22.36..238.54 rows=784 width=2,251) (actual time=0.005..0.005 rows=0 loops=9)

  • Recheck Cond: (company_id = c.id)
11. 0.036 0.036 ↓ 0.0 0 9

Bitmap Index Scan on lu_reservation_company_id_idx (cost=0.00..22.16 rows=784 width=0) (actual time=0.004..0.004 rows=0 loops=9)

  • Index Cond: (company_id = c.id)
12. 0.009 0.027 ↓ 0.0 0 9

Bitmap Heap Scan on reservation reservation_5 (cost=59.23..4,196.82 rows=1,756 width=3,007) (actual time=0.003..0.003 rows=0 loops=9)

  • Recheck Cond: (company_id = c.id)
13. 0.018 0.018 ↓ 0.0 0 9

Bitmap Index Scan on uk_reservation_company_id_idx (cost=0.00..58.79 rows=1,756 width=0) (actual time=0.002..0.002 rows=0 loops=9)

  • Index Cond: (company_id = c.id)
14. 0.036 0.036 ↓ 0.0 0 9

Index Scan using it_reservation_company_id_idx on reservation reservation_6 (cost=0.42..1,048.37 rows=303 width=2,769) (actual time=0.004..0.004 rows=0 loops=9)

  • Index Cond: (company_id = c.id)
Planning time : 3.056 ms