explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BC65

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,053.36..4,518.16 rows=1 width=3,286) (never executed)

  • Filter: (((dg.code)::text = ANY ('{ng,pg,g}'::text[])) OR ((bm.code)::text ~~* 'm%'::text))
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=953.36..4,336.87 rows=1 width=3,310) (never executed)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=853.36..4,164.73 rows=1 width=3,286) (never executed)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=753.36..3,958.05 rows=1 width=3,278) (never executed)

5. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on cs_gite_tampon gite (cost=152.63..3,136.56 rows=1 width=574) (never executed)

  • Filter: (gite.id IS NULL)
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on cs_gite_tampon_codesp_idx (cost=0..152.62 rows=8,427 width=0) (never executed)

  • Index Cond: ((gite.codesp)::text = ANY ('{murmur,myobly,myomyo,rhifer,myoema}'::text[]))
7. 0.000 0.000 ↓ 0.0

Hash Join (cost=600.74..810.14 rows=42 width=3,278) (never executed)

8. 0.000 0.000 ↓ 0.0

Hash Join (cost=470.76..678.64 rows=18 width=3,136) (never executed)

9. 0.000 0.000 ↓ 0.0

Foreign Scan (cost=100..306.64 rows=212 width=1,240) (never executed)

10. 0.000 0.000 ↓ 0.0

Hash (cost=370.55..370.55 rows=17 width=1,904) (never executed)

11. 0.000 0.000 ↓ 0.0

Hash Join (cost=219.5..370.55 rows=17 width=1,904) (never executed)

12. 0.000 0.000 ↓ 0.0

Foreign Scan (cost=100..250.31 rows=46 width=1,578) (never executed)

13. 0.000 0.000 ↓ 0.0

Hash (cost=118.55..118.55 rows=76 width=334) (never executed)

14. 0.000 0.000 ↓ 0.0

Foreign Scan (cost=100..118.55 rows=76 width=334) (never executed)

  • Filter: (date_part('year'::text, (ses.date_start)::timestamp without time zone) > '2010'::double precision)
15. 0.000 0.000 ↓ 0.0

Hash (cost=124.1..124.1 rows=470 width=150) (never executed)

16. 0.000 0.000 ↓ 0.0

Foreign Scan (cost=100..124.1 rows=470 width=150) (never executed)

17. 0.000 0.000 ↓ 0.0

Foreign Scan (cost=100..178.25 rows=2,275 width=12) (never executed)

18. 0.000 0.000 ↓ 0.0

Foreign Scan (cost=100..153.86 rows=1,462 width=32) (never executed)

19. 0.000 0.000 ↓ 0.0

Foreign Scan (cost=100..153.86 rows=1,462 width=32) (never executed)