explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hiBv

Settings
# exclusive inclusive rows x rows loops node
1. 0.073 66.350 ↓ 10.0 10 1

Nested Loop (cost=23.54..32.01 rows=1 width=156) (actual time=66.110..66.350 rows=10 loops=1)

  • Join Filter: ((t.code)::text = dt.code)
  • Rows Removed by Join Filter: 120
2.          

CTE a

3. 0.006 0.120 ↑ 1.0 10 1

Limit (cost=0.44..20.71 rows=10 width=30) (actual time=0.036..0.120 rows=10 loops=1)

4. 0.024 0.114 ↑ 17,796,366.4 10 1

Nested Loop (cost=0.44..360,736,803.80 rows=177,963,664 width=30) (actual time=0.035..0.114 rows=10 loops=1)

5. 0.010 0.010 ↑ 17,796,366.4 10 1

Seq Scan on actuel a_1 (cost=0.00..3,284,292.64 rows=177,963,664 width=12) (actual time=0.010..0.010 rows=10 loops=1)

6. 0.080 0.080 ↑ 1.0 1 10

Index Scan using immeuble_commune_id_idx on immeuble ai (cost=0.44..2.00 rows=1 width=22) (actual time=0.008..0.008 rows=1 loops=10)

  • Index Cond: (id = a_1.immeuble_id)
7. 0.018 66.227 ↓ 10.0 10 1

Nested Loop (cost=2.83..10.01 rows=1 width=172) (actual time=66.064..66.227 rows=10 loops=1)

8. 0.125 0.429 ↓ 10.0 10 1

Hash Join (cost=2.70..9.52 rows=1 width=86) (actual time=0.303..0.429 rows=10 loops=1)

  • Hash Cond: (dimo.bk_operateur = a.operateur_id)
9. 0.049 0.049 ↑ 1.0 204 1

Seq Scan on d_operateur dimo (cost=0.00..6.04 rows=204 width=12) (actual time=0.013..0.049 rows=204 loops=1)

10. 0.012 0.255 ↓ 10.0 10 1

Hash (cost=2.69..2.69 rows=1 width=80) (actual time=0.255..0.255 rows=10 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
11. 0.078 0.243 ↓ 10.0 10 1

Nested Loop (cost=0.00..2.69 rows=1 width=80) (actual time=0.082..0.243 rows=10 loops=1)

  • Join Filter: (a.debit_descendant <@ int4range(dcd.min_debit, (dcd.max_debit - 1)))
  • Rows Removed by Join Filter: 60
12. 0.135 0.135 ↑ 1.0 10 1

CTE Scan on a (cost=0.00..0.20 rows=10 width=48) (actual time=0.040..0.135 rows=10 loops=1)

13. 0.020 0.030 ↑ 1.0 7 10

Materialize (cost=0.00..1.10 rows=7 width=44) (actual time=0.002..0.003 rows=7 loops=10)

14. 0.010 0.010 ↑ 1.0 7 1

Seq Scan on d_classe_debit dcd (cost=0.00..1.07 rows=7 width=44) (actual time=0.005..0.010 rows=7 loops=1)

15. 65.780 65.780 ↑ 1.0 1 10

Index Scan using reference_techno_pkey on techno t (cost=0.14..0.48 rows=1 width=90) (actual time=6.578..6.578 rows=1 loops=10)

  • Index Cond: (id = a.techno_id)
16. 0.050 0.050 ↑ 1.0 13 10

Seq Scan on d_techno dt (cost=0.00..1.13 rows=13 width=36) (actual time=0.003..0.005 rows=13 loops=10)

Planning time : 1.125 ms
Execution time : 66.549 ms