explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0pID

Settings
# exclusive inclusive rows x rows loops node
1. 347.081 944.601 ↓ 1,085.7 409,291 1

Nested Loop (cost=0.00..23,048.18 rows=377 width=4,202) (actual time=9.236..944.601 rows=409,291 loops=1)

2. 3.295 3.295 ↓ 9.0 9 1

Seq Scan on company c (cost=0.00..295.93 rows=1 width=1,560) (actual time=0.317..3.295 rows=9 loops=1)

  • Filter: ((name)::text ~ 'irbus'::text)
  • Rows Removed by Filter: 4050
3. 32.958 594.225 ↓ 5.6 45,477 9

Append (cost=0.00..22,670.44 rows=8,182 width=2,640) (actual time=10.099..66.025 rows=45,477 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.054 0.054 ↓ 0.0 0 9

Index Scan using be_reservation_company_id_idx on reservation reservation_1 (cost=0.29..1,484.39 rows=672 width=2,960) (actual time=0.006..0.006 rows=0 loops=9)

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

Bitmap Heap Scan on reservation reservation_2 (cost=50.75..7,945.18 rows=2,365 width=3,053) (actual time=0.009..0.009 rows=0 loops=9)

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

Bitmap Index Scan on de_reservation_company_id_idx (cost=0.00..50.16 rows=2,365 width=0) (actual time=0.007..0.007 rows=0 loops=9)

  • Index Cond: (company_id = c.id)
8. 496.053 560.961 ↓ 18.6 45,477 9

Bitmap Heap Scan on reservation reservation_3 (cost=51.40..8,651.27 rows=2,448 width=2,444) (actual time=10.048..62.329 rows=45,477 loops=9)

  • Recheck Cond: (company_id = c.id)
  • Rows Removed by Index Recheck: 42225
  • Heap Blocks: exact=107518 lossy=52815
9. 64.908 64.908 ↓ 19.2 47,019 9

Bitmap Index Scan on fr_reservation_company_id_idx (cost=0.00..50.78 rows=2,448 width=0) (actual time=7.212..7.212 rows=47,019 loops=9)

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

Index Scan using it_reservation_company_id_idx on reservation reservation_4 (cost=0.42..736.80 rows=244 width=2,838) (actual time=0.009..0.009 rows=0 loops=9)

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

Index Scan using lu_reservation_company_id_idx on reservation reservation_5 (cost=0.28..93.24 rows=784 width=2,251) (actual time=0.004..0.004 rows=0 loops=9)

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

Bitmap Heap Scan on reservation reservation_6 (cost=33.22..3,759.56 rows=1,668 width=3,077) (actual time=0.006..0.006 rows=0 loops=9)

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

Bitmap Index Scan on uk_reservation_company_id_idx (cost=0.00..32.80 rows=1,668 width=0) (actual time=0.004..0.004 rows=0 loops=9)

  • Index Cond: (company_id = c.id)
Planning time : 2.092 ms
Execution time : 963.328 ms